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

     1  drop database if exists `incompatible_ddl_changes`;
     2  create database `incompatible_ddl_changes`;
     3  use `incompatible_ddl_changes`;
     4  -- https://dev.mysql.com/doc/refman/8.0/en/data-types.html
     5  create table t1 (
     6      id int NOT NULL AUTO_INCREMENT,
     7      should_skip int,
     8  
     9      c_null int,
    10  
    11      c_bit bit(8),
    12      c_tinyint tinyint(5) unsigned,
    13      c_smallint smallint(6),
    14      c_mediumint mediumint(7),
    15      c_int int(8),
    16      c_bigint bigint(9) unsigned,
    17      c_decimal decimal(7,2),
    18      c_float float(10),
    19      c_double double,
    20  
    21      c_date date,
    22      c_datetime datetime(3),
    23      c_timestamp timestamp(4),
    24      c_time time(5),
    25      c_year year,
    26  
    27      c_char char(4),
    28      c_varchar national varchar(255),
    29      c_binary binary(1),
    30      c_varbinary varbinary(4),
    31      c_tinyblob tinyblob,
    32      c_tinytext tinytext,
    33      c_blob blob(20),
    34      c_text text(10),
    35      c_mediumblob mediumblob,
    36      c_mediumtext mediumtext,
    37      c_longblob longblob,
    38      c_longtext longtext,
    39      c_enum enum('a', 'b', 'c'),
    40      c_set set('a', 'b', 'c'),
    41  
    42      c_json json,
    43  
    44      PRIMARY KEY (id)
    45  );