github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/table/create_pub_table.sql (about)

     1  create database if not EXISTS db_from_gh_monitor;
     2  use db_from_gh_monitor;
     3  CREATE TABLE `qrtz_job_details` ( `sched_name` VARCHAR(120) NOT NULL, `job_name` VARCHAR(190) NOT NULL, `job_group` VARCHAR(190) NOT NULL, `description` VARCHAR(250) DEFAULT null, `job_class_name` VARCHAR(250) NOT NULL, `is_durable` VARCHAR(1) NOT NULL, `is_nonconcurrent` VARCHAR(1) NOT NULL, `is_update_data` VARCHAR(1) NOT NULL, `requests_recovery` VARCHAR(1) NOT NULL, `job_data` BLOB DEFAULT NULL, PRIMARY KEY (`sched_name`,`job_name`,`job_group`), KEY `idx_qrtz_j_req_recovery` (`sched_name`,`requests_recovery`), KEY `idx_qrtz_j_grp` (`sched_name`,`job_group`) );
     4  DROP TABLE IF EXISTS `qrtz_triggers`;
     5  /*!40101 SET @saved_cs_client     = @@character_set_client */;
     6  /*!50503 SET character_set_client = utf8mb4 */;
     7  CREATE TABLE `qrtz_triggers` (
     8    `SCHED_NAME` varchar(120) NOT NULL,
     9    `TRIGGER_NAME` varchar(190) NOT NULL,
    10    `TRIGGER_GROUP` varchar(190) NOT NULL,
    11    `JOB_NAME` varchar(190) NOT NULL,
    12    `JOB_GROUP` varchar(190) NOT NULL,
    13    `DESCRIPTION` varchar(250) DEFAULT NULL,
    14    `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
    15    `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
    16    `PRIORITY` int(11) DEFAULT NULL,
    17    `TRIGGER_STATE` varchar(16) NOT NULL,
    18    `TRIGGER_TYPE` varchar(8) NOT NULL,
    19    `START_TIME` bigint(13) NOT NULL,
    20    `END_TIME` bigint(13) DEFAULT NULL,
    21    `CALENDAR_NAME` varchar(190) DEFAULT NULL,
    22    `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
    23    `JOB_DATA` blob,
    24    PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
    25    KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
    26    KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
    27    KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
    28    KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
    29    KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
    30    KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
    31    KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
    32    KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
    33    KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
    34    KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
    35    KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
    36    KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
    37    CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
    38  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
    39  /*!40101 SET character_set_client = @saved_cs_client */;
    40  
    41  SHOW CREATE TABLE `qrtz_triggers`;
    42  SHOW CREATE TABLE `qrtz_job_details`;
    43  
    44  create account acc1 ADMIN_NAME 'root' IDENTIFIED BY '123456';
    45  create publication pubname1 database db_from_gh_monitor account acc1;
    46  
    47  -- @session:id=2&user=acc1:root&password=123456
    48  create database sub_db1 from sys publication pubname1;
    49  use sub_db1;
    50  show tables;
    51  show create table qrtz_job_details;
    52  show create table qrtz_triggers;
    53  -- @session
    54  
    55  drop publication pubname1;
    56  drop account acc1;
    57  drop database db_from_gh_monitor;