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

     1  drop database if exists `sharding1`;
     2  drop database if exists `sharding2`;
     3  create database `sharding1`;
     4  use `sharding1`;
     5  create table t2 (id bigint auto_increment, uid int, name varchar(80), info varchar(100), primary key (`id`), unique key(`uid`)) auto_increment=2000;
     6  create table t3 (id bigint auto_increment, uid int, name varchar(80), info varchar(100), primary key (`id`), unique key(`uid`)) auto_increment=3000;
     7  insert into t2 (uid, name, info) values (40000, 'Remedios Moscote', '{}');
     8  insert into t3 (uid, name, info) values (30001, 'Aureliano José', '{}'), (30002, 'Santa Sofía de la Piedad', '{}'), (30003, '17 Aurelianos', NULL);