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

     1  drop database if exists `dm_syncer`;
     2  create database `dm_syncer`;
     3  use `dm_syncer`;
     4  create table t2 (id int auto_increment, name varchar(20), primary key (`id`));
     5  insert into t2 (name) values ('Arya'), ('Bran'), ('Sansa');
     6  
     7  create table dm_syncer_route_rules_1 (id int, name varchar(20), primary key (`id`));
     8  insert into dm_syncer_route_rules_1 (id, name) values (1, 'Howie'), (2, 'howie');
     9  
    10  create table dm_syncer_route_rules_2 (id int, name varchar(20), primary key (`id`));
    11  insert into dm_syncer_route_rules_2 (id, name) values (3, 'howie'), (4, 'Bran'), (5, 'Sansa');
    12  
    13  create table dm_syncer_route_rules_3 (id int, name varchar(20), primary key (`id`));
    14  insert into dm_syncer_route_rules_3 (id, name) values (6, 'Arya'), (7, 'Howie'), (8, 'Sansa');