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

     1  USE `test`;
     2  
     3  CREATE TABLE `test_update` (
     4    `id` int(11) NOT NULL,
     5    `uk` varchar(50) DEFAULT NULL,
     6    `other` varchar(100) DEFAULT NULL,
     7    PRIMARY KEY (`id`),
     8    UNIQUE KEY `uk` (`uk`)
     9  );
    10  
    11  CREATE TABLE multi_data_type
    12  (
    13      id                   INT AUTO_INCREMENT,
    14      t_tinyint            TINYINT,
    15      t_tinyint_unsigned   TINYINT UNSIGNED,
    16      t_smallint           SMALLINT,
    17      t_smallint_unsigned  SMALLINT UNSIGNED,
    18      t_mediumint          MEDIUMINT,
    19      t_mediumint_unsigned MEDIUMINT UNSIGNED,
    20      t_int                INT,
    21      t_int_unsigned       INT UNSIGNED,
    22      t_bigint             BIGINT,
    23      t_bigint_unsigned    BIGINT UNSIGNED,
    24      t_boolean            BOOLEAN,
    25      t_float              FLOAT(6, 2),
    26      t_double             DOUBLE(6, 2),
    27      t_decimal            DECIMAL(38, 19),
    28      t_char               CHAR,
    29      t_varchar            VARCHAR(10),
    30      c_binary             binary(16),
    31      c_varbinary          varbinary(16),
    32      t_tinytext           TINYTEXT,
    33      t_text               TEXT,
    34      t_mediumtext         MEDIUMTEXT,
    35      t_longtext           LONGTEXT,
    36      t_tinyblob           TINYBLOB,
    37      t_blob               BLOB,
    38      t_mediumblob         MEDIUMBLOB,
    39      t_longblob           LONGBLOB,
    40      t_date               DATE,
    41      t_datetime           DATETIME,
    42      t_timestamp          TIMESTAMP NULL,
    43      t_time               TIME,
    44  --  t_year               YEAR,
    45      t_enum               ENUM ('enum1', 'enum2', 'enum3'),
    46      t_set                SET ('a', 'b', 'c'),
    47  --  t_bit                BIT(64),
    48      t_json               JSON,
    49      PRIMARY KEY (id)
    50  );
    51  
    52  CREATE TABLE multi_charset (
    53  	id INT,
    54  	name varchar(128) CHARACTER SET gbk,
    55  	country char(32) CHARACTER SET gbk,
    56  	city varchar(64),
    57  	description text CHARACTER SET gbk,
    58  	image tinyblob,
    59  	PRIMARY KEY (id)
    60  ) ENGINE = InnoDB CHARSET = utf8mb4;
    61  
    62  CREATE TABLE binary_columns
    63  (
    64      id                   INT AUTO_INCREMENT,
    65      c_binary             binary(255),
    66      c_varbinary          varbinary(255),
    67      t_tinyblob           TINYBLOB,
    68      t_blob               BLOB,
    69      t_mediumblob         MEDIUMBLOB,
    70      t_longblob           LONGBLOB,
    71      PRIMARY KEY (id)
    72  );