github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/multi_topics_v2/data/step1.sql (about)

     1  use test;
     2  
     3  create table table1
     4  (
     5      id          int auto_increment,
     6      c_tinyint   tinyint null,
     7      c_smallint  smallint null,
     8      c_mediumint mediumint null,
     9      c_int       int null,
    10      c_bigint    bigint null,
    11      constraint pk
    12          primary key (id)
    13  );
    14  insert into table1(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    15  values (1, 2, 3, 4, 5);
    16  
    17  create table table2
    18  (
    19      id          int auto_increment,
    20      c_tinyint   tinyint null,
    21      c_smallint  smallint null,
    22      c_mediumint mediumint null,
    23      c_int       int null,
    24      c_bigint    bigint null,
    25      constraint pk
    26          primary key (id)
    27  );
    28  insert into table2(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    29  values (1, 2, 3, 4, 5);
    30  
    31  create table table3
    32  (
    33      id          int auto_increment,
    34      c_tinyint   tinyint null,
    35      c_smallint  smallint null,
    36      c_mediumint mediumint null,
    37      c_int       int null,
    38      c_bigint    bigint null,
    39      constraint pk
    40          primary key (id)
    41  );
    42  
    43  insert into table3(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    44  values (1, 2, 3, 4, 5);