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

     1  drop database if exists `dm_syncer`;
     2  create database `dm_syncer`;
     3  use `dm_syncer`;
     4  create table t1 (id int, name varchar(20), primary key(`id`));
     5  insert into t1 (id, name) values (1, 'arya'), (2, 'catelyn');
     6  create table dm_syncer_1(id int, name varchar(20), primary key(`id`));
     7  insert into dm_syncer_1 values (1, 'arya'), (2, 'catelyn');
     8  
     9  drop database if exists `dm_syncer_do_db`;
    10  create database `dm_syncer_do_db`;
    11  use `dm_syncer_do_db`;
    12  create table dm_syncer_do_db_1(id int, name varchar(20), primary key(`id`));
    13  insert into dm_syncer_do_db_1(id, name) values (1, 'Howie'), (2, 'howie');
    14  create table dm_syncer_do_db_2(id int, name varchar(20), primary key(`id`));
    15  insert into dm_syncer_do_db_2(id, name) values (1, 'Howie'), (2, 'howie');
    16  create table dm_syncer_do_db_3(id int, name varchar(20), primary key(`id`));
    17  insert into dm_syncer_do_db_3(id, name) values (1, 'Howie'), (2, 'howie');
    18  
    19  drop database if exists `dm_syncer_ignore_db`;
    20  create database `dm_syncer_ignore_db`;
    21  use `dm_syncer_ignore_db`;
    22  create table dm_syncer_ignore_db_1(id int, name varchar(20), primary key(`id`));
    23  insert into dm_syncer_ignore_db_1(id, name) values (1, 'Howie'), (2, 'howie');
    24  create table dm_syncer_ignore_db_2(id int, name varchar(20), primary key(`id`));
    25  insert into dm_syncer_ignore_db_2(id, name) values (1, 'Howie'), (2, 'howie');
    26  
    27  use `dm_syncer_do_db`;
    28  create table dm_syncer_do_db_4(id int, foreign_id int, primary key (id), foreign key (foreign_id) references dm_syncer_ignore_db.dm_syncer_ignore_db_1(id));
    29  insert into dm_syncer_do_db_4(id, foreign_id) values (1, 1), (2, 2);
    30  create table dm_syncer_do_db_5 like dm_syncer_do_db_4;
    31  insert into dm_syncer_do_db_5(id, foreign_id) values (1, 1), (2, 2);