Mycat2在启动的时候会自动创建该库(可能会创建失败,此时要自行创建)

    1. CREATE DATABASE IF NOT EXISTS `mycat`;
    2. USE `mycat`;
    3. DROP TABLE IF EXISTS `analyze_table`;
    4. CREATE TABLE `analyze_table` (
    5.   `table_rows` bigint(20) NOT NULL,
    6.   `name` varchar(64) NOT NULL,
    7.   PRIMARY KEY (`name`)
    8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    9. DROP TABLE IF EXISTS `config`;
    10. CREATE TABLE `config` (
    11.   `key` varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    12.   `value` longtext,
    13.   `version` bigint(20) DEFAULT NULL,
    14.   `secondKey` longtext,
    15.   `deleted` tinyint(1) DEFAULT '0',
    16.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    17.   PRIMARY KEY (`id`),
    18.   KEY `id` (`id`)
    19. ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    20. DROP TABLE IF EXISTS `replica_log`;
    21. CREATE TABLE `replica_log` (
    22.   `name` varchar(22) DEFAULT NULL,
    23.   `dsNames` text,
    24.   `time` datetime DEFAULT NULL,
    25.   `id` bigint(20) NOT NULL AUTO_INCREMENT,
    26.   PRIMARY KEY (`id`)
    27. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    28. DROP TABLE IF EXISTS `spm_baseline`;
    29. CREATE TABLE `spm_baseline` (
    30.   `id` bigint(22) NOT NULL AUTO_INCREMENT,
    31.   `fix_plan_id` bigint(22) DEFAULT NULL,
    32.   `constraint` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    33.   `extra_constraint` longtext,
    34.   PRIMARY KEY (`id`),
    35.   UNIQUE KEY `constraint_index` (`constraint`(22)),
    36.   KEY `id` (`id`)
    37. ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    38. DROP TABLE IF EXISTS `spm_plan`;
    39. CREATE TABLE `spm_plan` (
    40.   `id` bigint(22) NOT NULL AUTO_INCREMENT,
    41.   `sql` longtext,
    42.   `rel` longtext,
    43.   `baseline_id` bigint(22) DEFAULT NULL,
    44.   PRIMARY KEY (`id`),
    45.   KEY `id` (`id`)
    46. ) ENGINE=InnoDB AUTO_INCREMENT=0 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    47. DROP TABLE IF EXISTS `sql_log`;
    48. CREATE TABLE `sql_log` (
    49.   `instanceId` bigint(20) DEFAULT NULL,
    50.   `user` varchar(64) DEFAULT NULL,
    51.   `connectionId` bigint(20) DEFAULT NULL,
    52.   `ip` varchar(22) DEFAULT NULL,
    53.   `port` bigint(20) DEFAULT NULL,
    54.   `traceId` varchar(22) NOT NULL,
    55.   `hash` varchar(22) DEFAULT NULL,
    56.   `sqlType` varchar(22) DEFAULT NULL,
    57.   `sql` longtext,
    58.   `transactionId` varchar(22) DEFAULT NULL,
    59.   `sqlTime` bigint(20) DEFAULT NULL,
    60.   `responseTime` datetime DEFAULT NULL,
    61.   `affectRow` int(11) DEFAULT NULL,
    62.   `result` tinyint(1) DEFAULT NULL,
    63.   `externalMessage` tinytext,
    64.   PRIMARY KEY (`traceId`)
    65. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
    66. DROP TABLE IF EXISTS `variable`;
    67. CREATE TABLE `variable` (
    68.     `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    69.     `value` varchar(22) DEFAULT NULL,
    70.     PRIMARY KEY (`name`)
    71. ) ENGINE = InnoDB CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
    72. DROP TABLE IF EXISTS `xa_log`;
    73. CREATE TABLE `xa_log` (
    74.     `xid` bigint(20) NOT NULL,
    75.     PRIMARY KEY (`xid`)
    76. ) ENGINE = InnoDB CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;