github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/import_v10x/data/v106_syncer_checkpoint.sql (about)

     1  create database if not exists `dm_meta`;
     2  CREATE TABLE IF NOT EXISTS `dm_meta`.`test_syncer_checkpoint` (
     3      `id` varchar(32) NOT NULL,
     4      `cp_schema` varchar(128) NOT NULL,
     5      `cp_table` varchar(128) NOT NULL,
     6      `binlog_name` varchar(128) DEFAULT NULL,
     7      `binlog_pos` int(10) unsigned DEFAULT NULL,
     8      `is_global` tinyint(1) DEFAULT NULL,
     9      `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    10      `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    11      UNIQUE KEY `uk_id_schema_table` (`id`,`cp_schema`,`cp_table`)
    12  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
    13  INSERT INTO `dm_meta`.`test_syncer_checkpoint` VALUES
    14  ('mysql-replica-01','','','BINLOG_NAME1',BINLOG_POS1,1,'2020-07-31 18:10:40','2020-07-31 18:11:40'),
    15  ('mysql-replica-01','import_v10x','t1','BINLOG_NAME1',BINLOG_POS1,0,'2020-07-31 18:10:40','2020-07-31 18:11:40'),
    16  ('mysql-replica-02','','','BINLOG_NAME2',BINLOG_POS2,1,'2020-07-31 18:10:40','2020-07-31 18:11:40'),
    17  ('mysql-replica-02','import_v10x','t2','BINLOG_NAME2',BINLOG_POS2,0,'2020-07-31 18:10:40','2020-07-31 18:11:40');