create_table.sql

CREATE TABLE IF NOT EXISTS `app_revision`
(
    `id`                   bigint(20)   NOT NULL AUTO_INCREMENT COMMENT '主键',
    `data_center`          varchar(128) NOT NULL COMMENT '集群名',
    `revision`             varchar(128) NOT NULL COMMENT 'revision',
    `app_name`             varchar(128) NOT NULL COMMENT '应用名',
    `base_params`          text                  DEFAULT NULL COMMENT '基础参数',
    `service_params`       text                  DEFAULT NULL COMMENT '服务参数',
    `service_params_large` mediumtext            DEFAULT NULL COMMENT '服务参数',
    `gmt_create`           timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`         timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `client_version`       varchar(512)          DEFAULT NULL COMMENT '客户端版本',
    `deleted`              tinyint(1)   NOT NULL DEFAULT 0 COMMENT '是否被删除',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_data_center_revision` (`data_center`, `revision`)
) DEFAULT CHARSET=utf8mb4  COMMENT='服务元数据表';

CREATE TABLE IF NOT EXISTS `interface_apps_index`
(
    `id`             bigint(20)   NOT NULL AUTO_INCREMENT COMMENT '主键',
    `data_center`    varchar(128) NOT NULL COMMENT '集群名称',
    `app_name`       varchar(128) NOT NULL COMMENT '应用名',
    `interface_name` varchar(386) NOT NULL COMMENT '接口名',
    `gmt_create`     timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT '创建时间',
    `gmt_modified`   timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '修改时间',
    `hashcode`       varchar(128) NOT NULL COMMENT '唯一索引hashcode',
    `reference`      tinyint(4)   NOT NULL COMMENT '是否被引用',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_hashcode` (`data_center`, `app_name`, `hashcode`),
    KEY              `idx_data_center_interface` (`interface_name`)
) DEFAULT CHARSET=utf8mb4 COMMENT='interface与revision索引表';

CREATE TABLE IF NOT EXISTS `provide_data`
(
    `id`           bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
    `data_center`  varchar(128) NOT NULL COMMENT '集群名',
    `data_key`     varchar(512) NOT NULL COMMENT 'data.yaml key',
    `data_value`   mediumtext            DEFAULT NULL COMMENT 'data.yaml value',
    `gmt_create`   timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `data_version` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '版本号',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_data_center_key` (`data_center`(128), `data_key`(512))
) DEFAULT CHARSET = utf8mb4 COMMENT = '注册中心配置存储表';

CREATE TABLE IF NOT EXISTS `distribute_lock`
(
    `id`            bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
    `data_center`   varchar(128) NOT NULL COMMENT '集群名',
    `lock_name`     varchar(512) NOT NULL COMMENT '分布式锁名称',
    `owner`         varchar(512) NOT NULL COMMENT '锁拥有者',
    `duration`      bigint(20)   NOT NULL COMMENT '持续周期',
    `gmt_create`    timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
    `gmt_modified`  timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '修改时间',
    `term`          bigint(20)   NOT NULL DEFAULT 0 COMMENT '任期',
    `term_duration` bigint(20)   NOT NULL DEFAULT 0 COMMENT '租期',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_data_center_lock` (`data_center`(128), `lock_name`(512)),
    KEY             `idx_lock_owner` (`owner`(512))
) DEFAULT CHARSET = utf8mb4 COMMENT = '分布式锁';


CREATE TABLE IF NOT EXISTS `client_manager_address`
(
    `id`           bigint(20)   NOT NULL AUTO_INCREMENT,
    `data_center`  varchar(128) NOT NULL COMMENT '集群名称',
    `address`      varchar(256) NOT NULL COMMENT 'address',
    `gmt_create`   timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified` timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `operation`    varchar(128) NOT NULL COMMENT '操作类型',
    `pub`          tinyint(1)   NOT NULL DEFAULT 1 COMMENT '是否持久化关流pub',
    `sub`          tinyint(1)   NOT NULL DEFAULT 1 COMMENT '是否持久化关流sub',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_data_center_address` (`data_center`, `address`)
) DEFAULT CHARSET = utf8mb4 COMMENT = '关流量pod数据表';


CREATE TABLE IF NOT EXISTS `recover_config`
(
    `id`             bigint(20)   NOT NULL AUTO_INCREMENT COMMENT '主键',
    `property_table` varchar(256) NOT NULL COMMENT '容灾独立存储配置table',
    `property_key`   varchar(512) NOT NULL COMMENT '容灾独立存储配置table_key',
    `gmt_create`     timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`   timestamp    NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_table_key` (`property_table`, `property_key`)
);

CREATE TABLE IF NOT EXISTS `multi_cluster_sync_info`
(
    `id`                   bigint(20)    NOT NULL AUTO_INCREMENT COMMENT '主键',
    `data_center`          varchar(255)  NOT NULL COMMENT '集群名称',
    `remote_data_center`   varchar(255)  NOT NULL COMMENT '同步的集群名称',
    `remote_meta_address`  varchar(1024) NOT NULL COMMENT '同步的集群地址',
    `enable_sync_datum`    varchar(16)   NOT NULL COMMENT 'datum同步的开关是否开启',
    `enable_push`          varchar(16)   NOT NULL COMMENT '同步的数据是否允许推送',
    `sync_datainfoids`     MEDIUMTEXT    NOT NULL COMMENT '同步的dataInfoId名单',
    `syn_publisher_groups` varchar(4096) NOT NULL COMMENT '同步的group名单',
    `ignore_datainfoids`   MEDIUMTEXT    NOT NULL COMMENT '忽略同步的dataInfoId',
    `data_version`         bigint(20)    NOT NULL DEFAULT '0' COMMENT '版本号',
    `gmt_create`           timestamp     NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `gmt_modified`         timestamp     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_table_key` (`data_center`, `remote_data_center`),
    KEY                    `idx_data_center` (`data_center`)
)