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

     1  drop database if exists `sharding_seq`;
     2  create database `sharding_seq`;
     3  use `sharding_seq`;
     4  create table t1 (id bigint auto_increment,uid int,name varchar(20),primary key (`id`),unique key(`uid`)) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin auto_increment=100000;
     5  create table t2 (id bigint auto_increment,uid int,name varchar(20),primary key (`id`),unique key(`uid`)) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin auto_increment=200000;
     6  insert into t1 (uid,name) values (100001,'igvApUx'),(100002,'qUyrcOBkwDK');
     7  insert into t2 (uid,name) values (200001,'EycletJHetWHMfH'),(200002,'ytkIaCOwXnWmy'),(200003,'MWQeWw""''rNmtGxzGp');