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

     1  drop database if exists test;
     2  create database test;
     3  use test;
     4  
     5  create table t (
     6      id          int primary key auto_increment,
     7  
     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  
    14      c_unsigned_tinyint   tinyint   unsigned null,
    15      c_unsigned_smallint  smallint  unsigned null,
    16      c_unsigned_mediumint mediumint unsigned null,
    17      c_unsigned_int       int       unsigned null,
    18      c_unsigned_bigint    bigint    unsigned null,
    19  
    20      c_float   float   null,
    21      c_double  double  null,
    22      c_decimal decimal null,
    23      c_decimal_2 decimal(10, 4) null,
    24  
    25      c_unsigned_float     float unsigned   null,
    26      c_unsigned_double    double unsigned  null,
    27      c_unsigned_decimal   decimal unsigned null,
    28      c_unsigned_decimal_2 decimal(10, 4) unsigned null,
    29  
    30      c_date      date      null,
    31      c_datetime  datetime  null,
    32      c_timestamp timestamp null,
    33      c_time      time      null,
    34      c_year      year      null,
    35  
    36      c_tinytext   tinytext      null,
    37      c_text       text          null,
    38      c_mediumtext mediumtext    null,
    39      c_longtext   longtext      null,
    40  
    41      c_tinyblob   tinyblob      null,
    42      c_blob       blob          null,
    43      c_mediumblob mediumblob    null,
    44      c_longblob   longblob      null,
    45  
    46      c_char       char(16)      null,
    47      c_varchar    varchar(16)   null,
    48      c_binary     binary(16)    null,
    49      c_varbinary  varbinary(16) null,
    50  
    51      c_enum enum ('a','b','c') null,
    52      c_set  set ('a','b','c')  null,
    53      c_bit  bit(64)            null,
    54      c_json json               null
    55  );