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

     1  drop database if exists `ddl_sequence`;
     2  create database `ddl_sequence`;
     3  use `ddl_sequence`;
     4  
     5  CREATE TABLE many_cols1 (
     6  	id INT AUTO_INCREMENT PRIMARY KEY,
     7  	val INT DEFAULT 0,
     8  	col0 INT NOT NULL
     9  );
    10  ALTER TABLE many_cols1 DROP COLUMN col0;
    11  INSERT INTO many_cols1 (val) VALUES (1);
    12  
    13  CREATE TABLE many_cols2 (
    14  	id INT AUTO_INCREMENT PRIMARY KEY,
    15  	val INT DEFAULT 0,
    16  	col0 INT NOT NULL
    17  );
    18  ALTER TABLE many_cols2 DROP COLUMN col0;
    19  INSERT INTO many_cols2 (val) VALUES (1);
    20  
    21  CREATE TABLE many_cols3 (
    22  	id INT AUTO_INCREMENT PRIMARY KEY,
    23  	val INT DEFAULT 0,
    24  	col0 INT NOT NULL
    25  );
    26  ALTER TABLE many_cols3 DROP COLUMN col0;
    27  INSERT INTO many_cols3 (val) VALUES (1);
    28  
    29  CREATE TABLE many_cols4 (
    30  	id INT AUTO_INCREMENT PRIMARY KEY,
    31  	val INT DEFAULT 0,
    32  	col0 INT NOT NULL
    33  );
    34  ALTER TABLE many_cols4 DROP COLUMN col0;
    35  INSERT INTO many_cols4 (val) VALUES (1);
    36  
    37  CREATE TABLE many_cols5 (
    38  	id INT AUTO_INCREMENT PRIMARY KEY,
    39  	val INT DEFAULT 0,
    40  	col0 INT NOT NULL
    41  );
    42  ALTER TABLE many_cols5 DROP COLUMN col0;
    43  INSERT INTO many_cols5 (val) VALUES (1);
    44  
    45  CREATE TABLE finish_mark(a int primary key)