github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_tests/multi_topics/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);
    45  
    46  create database workload;
    47  use workload;
    48  
    49  create table table1
    50  (
    51      id          int auto_increment,
    52      c_tinyint   tinyint null,
    53      c_smallint  smallint null,
    54      c_mediumint mediumint null,
    55      c_int       int null,
    56      c_bigint    bigint null,
    57      constraint pk
    58          primary key (id)
    59  );
    60  insert into table1(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    61  values (1, 2, 3, 4, 5);
    62  
    63  create table table2
    64  (
    65      id          int auto_increment,
    66      c_tinyint   tinyint null,
    67      c_smallint  smallint null,
    68      c_mediumint mediumint null,
    69      c_int       int null,
    70      c_bigint    bigint null,
    71      constraint pk
    72          primary key (id)
    73  );
    74  insert into table2(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    75  values (1, 2, 3, 4, 5);
    76  
    77  create table table3
    78  (
    79      id          int auto_increment,
    80      c_tinyint   tinyint null,
    81      c_smallint  smallint null,
    82      c_mediumint mediumint null,
    83      c_int       int null,
    84      c_bigint    bigint null,
    85      constraint pk
    86          primary key (id)
    87  );
    88  
    89  insert into table3(c_tinyint, c_smallint, c_mediumint, c_int, c_bigint)
    90  values (1, 2, 3, 4, 5);