adapter/persistence/src/main/resources/db/migration/V1__baseline.sql

# Licensed to the Apache Software Foundation (ASF) under one or more
# contributor license agreements.  See the NOTICE file distributed with
# this work for additional information regarding copyright ownership.
# The ASF licenses this file to You under the Apache License, Version 2.0
# (the "License"); you may not use this file except in compliance with
# the License.  You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

CREATE TABLE IF NOT EXISTS `event_bus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) NOT NULL COMMENT 'bus account id',
  `name` varchar(255) NOT NULL COMMENT 'bus name',
  `description` varchar(256) DEFAULT NULL COMMENT 'bus description',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`account_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8  COMMENT='event bus meta'
;

CREATE TABLE `event_topic` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) DEFAULT 'SYSTEM' COMMENT 'source account id',
  `bus` varchar(255) NOT NULL COMMENT 'bus name',
  `name` varchar(255) NOT NULL COMMENT 'topic name',
  `msg_ttl` int(11) NOT NULL COMMENT 'msg ttl',
  `cluster` varchar(255) NOT NULL COMMENT 'the cluster of topic',
  `status` tinyint(4) NOT NULL COMMENT '0:disable, 1:enable',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
;

CREATE TABLE IF NOT EXISTS `event_source` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) DEFAULT 'SYSTEM' COMMENT 'source account id',
  `bus` varchar(255) NOT NULL COMMENT 'bus name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'source name',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0:disable, 1:enable',
  `type` int(11) NOT NULL DEFAULT '1' COMMENT 'event source type',
  `class_name` varchar(255) COMMENT 'event source class name',
  `config` text COMMENT 'event source runner config',
  `description` varchar(1024) DEFAULT NULL COMMENT 'event source description',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`account_id`,`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='event source meta'
;

CREATE TABLE IF NOT EXISTS `event_type` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) NOT NULL COMMENT 'bus account id',
  `bus` varchar(255) NOT NULL COMMENT 'bus name',
  `source` varchar(255) NOT NULL DEFAULT '' COMMENT 'event source name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'event type name',
  `description` varchar(255) DEFAULT NULL COMMENT 'a description about the event type',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`source`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='event type meta'
;

CREATE TABLE IF NOT EXISTS  `event_rule` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) NOT NULL COMMENT 'bus account id',
  `bus` varchar(255) NOT NULL COMMENT 'bus name',
  `name` varchar(255) NOT NULL COMMENT 'rule name',
  `filter_pattern` varchar(4096) DEFAULT NULL COMMENT 'event filter pattern',
  `status` tinyint(4) NOT NULL COMMENT '0:disable, 1:enable',
  `description` varchar(255) DEFAULT NULL COMMENT 'a description about the event rule',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `name_uniq_key` (`account_id`,`name`,`bus`)
) ENGINE=InnoDB AUTO_INCREMENT=51815 DEFAULT CHARSET=utf8 COMMENT='event rule meta'
;

CREATE TABLE IF NOT EXISTS `event_source_runner` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) DEFAULT 'SYSTEM' COMMENT 'source account id',
  `bus` varchar(255) NOT NULL COMMENT 'bus name',
  `source` varchar(255) NOT NULL DEFAULT '' COMMENT 'source name',
  `run_options` varchar(1024) DEFAULT NULL COMMENT 'event source runner options',
  `run_context` varchar(1024) DEFAULT NULL COMMENT 'event source running context',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`account_id`,`bus`,`source`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='event source runner meta'
;

CREATE TABLE IF NOT EXISTS `event_target` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) DEFAULT 'SYSTEM' COMMENT 'target account id',
  `bus` varchar(255) NOT NULL COMMENT 'bus name',
  `rule` varchar(255) NOT NULL DEFAULT '' COMMENT 'rule name',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'target name',
  `class_name` varchar(255) NOT NULL COMMENT 'event target class name',
  `config` text NOT NULL COMMENT 'event target runner config',
  `run_options` varchar(1024) DEFAULT NULL COMMENT 'event target runner options',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`account_id`,`bus`,`rule`,`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='event target meta'
;



CREATE TABLE IF NOT EXISTS `event_target_runner` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(255) DEFAULT 'SYSTEM' COMMENT 'target account id',
  `bus` varchar(255) NOT NULL COMMENT 'bus name',
  `rule` varchar(255) NOT NULL DEFAULT '' COMMENT 'rule name',
  `target` varchar(255) NOT NULL DEFAULT '' COMMENT 'target name',
  `run_context` varchar(1024) DEFAULT NULL COMMENT 'event target running context',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`account_id`,`bus`,`rule`,`target`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='event target runner meta'
;


CREATE TABLE IF NOT EXISTS `event_source_class` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'source class name',
  `api_params` text NOT NULL COMMENT 'event source api params',
  `required_params` text NOT NULL COMMENT 'event source required params',
  `transform` text NOT NULL COMMENT 'transform the event source data',
  `visual_config` text DEFAULT NULL COMMENT 'event source fore-end visual config',
  `description` varchar(255) DEFAULT NULL COMMENT 'a description about the source class',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='event source class meta'
;


CREATE TABLE IF NOT EXISTS `event_target_class` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'target class name',
  `api_params` text NOT NULL COMMENT 'event target api params',
  `target_transform` text NOT NULL COMMENT 'event target required data',
  `required_params` text NOT NULL COMMENT 'event target required params',
  `visual_config` text DEFAULT NULL COMMENT 'event target fore-end visual config',
  `description` varchar(255) DEFAULT NULL COMMENT 'a description about the target class',
  `gmt_create` datetime DEFAULT NULL COMMENT 'create time',
  `gmt_modify` datetime DEFAULT NULL COMMENT 'modify time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_uniq_key` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='event target class meta'
;