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

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