DM两张表没有PK,“loader_checkpoint”和“syncer_checkpoint”
CREATE TABLE `test212-3307_loader_checkpoint` (
`id` char(32) NOT NULL,
`filename` varchar(255) NOT NULL,
`cp_schema` varchar(128) NOT NULL,
`cp_table` varchar(128) NOT NULL,
`offset` bigint(20) NOT NULL,
`end_pos` bigint(20) NOT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
UNIQUE KEY `uk_id_f` (`id`,`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `test212-3307_syncer_checkpoint` (
`id` varchar(32) NOT NULL,
`cp_schema` varchar(128) NOT NULL,
`cp_table` varchar(128) NOT NULL,
`binlog_name` varchar(128) DEFAULT NULL,
`binlog_pos` int(10) unsigned DEFAULT NULL,
`binlog_gtid` text DEFAULT NULL,
`exit_safe_binlog_name` varchar(128) DEFAULT '',
`exit_safe_binlog_pos` int(10) unsigned DEFAULT '0',
`exit_safe_binlog_gtid` text DEFAULT NULL,
`table_info` json NOT NULL,
`is_global` tinyint(1) DEFAULT NULL,
`create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
UNIQUE KEY `uk_id_schema_table` (`id`,`cp_schema`,`cp_table`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;