github.com/pingcap/ticdc@v0.0.0-20220526033649-485a10ef2652/tests/ddl_async/data/prepare.sql (about)

     1  drop database if exists `ddl_async`;
     2  create database `ddl_async`;
     3  use `ddl_async`;
     4  
     5  CREATE TABLE ddl_block1 (
     6                              id INT AUTO_INCREMENT PRIMARY KEY,
     7                              val INT DEFAULT 0,
     8                              col0 INT NOT NULL
     9  );
    10  ALTER TABLE ddl_block1 DROP COLUMN col0;
    11  INSERT INTO ddl_block1 (val) VALUES (1);
    12  
    13  CREATE TABLE ddl_block2 (
    14                              id INT AUTO_INCREMENT PRIMARY KEY,
    15                              val INT DEFAULT 0,
    16                              col0 INT NOT NULL
    17  );
    18  ALTER TABLE ddl_block2 DROP COLUMN col0;
    19  INSERT INTO ddl_block2 (val) VALUES (1);
    20  
    21  CREATE TABLE ddl_block3 (
    22                              id INT AUTO_INCREMENT PRIMARY KEY,
    23                              val INT DEFAULT 0,
    24                              col0 INT NOT NULL
    25  );
    26  ALTER TABLE ddl_block3 DROP COLUMN col0;
    27  INSERT INTO ddl_block3 (val) VALUES (1);
    28  
    29  
    30  CREATE TABLE many_cols1 (
    31                              id INT AUTO_INCREMENT PRIMARY KEY,
    32                              val INT DEFAULT 0,
    33                              col0 INT NOT NULL
    34  );
    35  ALTER TABLE many_cols1 DROP COLUMN col0;
    36  INSERT INTO many_cols1 (val) VALUES (1);
    37  
    38  CREATE TABLE many_cols2 (
    39                              id INT AUTO_INCREMENT PRIMARY KEY,
    40                              val INT DEFAULT 0,
    41                              col0 INT NOT NULL
    42  );
    43  ALTER TABLE many_cols2 DROP COLUMN col0;
    44  INSERT INTO many_cols2 (val) VALUES (1);
    45  
    46  CREATE TABLE many_cols3 (
    47                              id INT AUTO_INCREMENT PRIMARY KEY,
    48                              val INT DEFAULT 0,
    49                              col0 INT NOT NULL
    50  );
    51  ALTER TABLE many_cols3 DROP COLUMN col0;
    52  INSERT INTO many_cols3 (val) VALUES (1);
    53  
    54  CREATE TABLE many_cols4 (
    55                              id INT AUTO_INCREMENT PRIMARY KEY,
    56                              val INT DEFAULT 0,
    57                              col0 INT NOT NULL
    58  );
    59  ALTER TABLE many_cols4 DROP COLUMN col0;
    60  INSERT INTO many_cols4 (val) VALUES (1);
    61  
    62  CREATE TABLE many_cols5 (
    63                              id INT AUTO_INCREMENT PRIMARY KEY,
    64                              val INT DEFAULT 0,
    65                              col0 INT NOT NULL
    66  );
    67  ALTER TABLE many_cols5 DROP COLUMN col0;
    68  INSERT INTO many_cols5 (val) VALUES (1);
    69  
    70  CREATE TABLE finish_mark(a int primary key)