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

     1  drop database if exists test;
     2  create database test;
     3  use test;
     4  
     5  create table tp_int
     6  (
     7      id          int auto_increment,
     8      c_tinyint   tinyint   null,
     9      c_smallint  smallint  null,
    10      c_mediumint mediumint null,
    11      c_int       int       null,
    12      c_bigint    bigint    null,
    13      constraint pk
    14          primary key (id)
    15  );
    16  
    17  
    18  -- unsigned int
    19  create table tp_unsigned_int (
    20      id          int auto_increment,
    21      c_unsigned_tinyint   tinyint   unsigned null,
    22      c_unsigned_smallint  smallint  unsigned null,
    23      c_unsigned_mediumint mediumint unsigned null,
    24      c_unsigned_int       int       unsigned null,
    25      c_unsigned_bigint    bigint    unsigned null,
    26      constraint pk
    27          primary key (id)
    28  );
    29  
    30  
    31  -- real
    32  create table tp_real
    33  (
    34      id        int auto_increment,
    35      c_float   float   null,
    36      c_double  double  null,
    37      c_decimal decimal null,
    38      c_decimal_2 decimal(10, 4) null,
    39      constraint pk
    40          primary key (id)
    41  );
    42  
    43  
    44  
    45  -- unsigned real
    46  create table tp_unsigned_real (
    47      id                   int auto_increment,
    48      c_unsigned_float     float unsigned   null,
    49      c_unsigned_double    double unsigned  null,
    50      c_unsigned_decimal   decimal unsigned null,
    51      c_unsigned_decimal_2 decimal(10, 4) unsigned null,
    52      constraint pk
    53          primary key (id)
    54  );
    55  
    56  create table finish_mark_for_ddl
    57  (
    58      id int PRIMARY KEY
    59  );
    60  
    61