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

     1  drop database if exists `sharding_seq_opt`;
     2  create database `sharding_seq_opt`;
     3  use `sharding_seq_opt`;
     4  create table t2 (id bigint primary key, c1 varchar(20), c2 varchar(20)) CHARSET=latin1 COLLATE=latin1_bin;
     5  create table t3 (id bigint primary key, c1 varchar(20), c2 varchar(20)) CHARSET=latin1 COLLATE=latin1_bin;
     6  create table t4 (id bigint primary key, c1 varchar(20), c2 varchar(20)) CHARSET=latin1 COLLATE=latin1_bin;
     7  insert into t2 (id, c1, c2) values (300001, 'five', 'fifth'), (300002, 'six', 'sixth');
     8  insert into t3 (id, c1, c2) values (400001, 'seven', 'seventh'), (400002, 'eight', 'eighth');
     9  insert into t4 (id, c1, c2) values (500001, 'nine', 'nineth'), (500002, 'ten', 'tenth');