github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/tests/integration_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  
    11  INSERT INTO many_cols1(col0) VALUES (1);
    12  
    13  ALTER TABLE many_cols1 DROP COLUMN col0;
    14  INSERT INTO many_cols1 (val) VALUES (1);
    15  
    16  CREATE TABLE many_cols2 (
    17  	id INT AUTO_INCREMENT PRIMARY KEY,
    18  	val INT DEFAULT 0,
    19  	col0 INT NOT NULL
    20  );
    21  
    22  INSERT INTO many_cols2(col0) VALUES (1);
    23  
    24  ALTER TABLE many_cols2 DROP COLUMN col0;
    25  INSERT INTO many_cols2 (val) VALUES (1);
    26  
    27  CREATE TABLE many_cols3 (
    28  	id INT AUTO_INCREMENT PRIMARY KEY,
    29  	val INT DEFAULT 0,
    30  	col0 INT NOT NULL
    31  );
    32  
    33  INSERT INTO many_cols3(col0) VALUES (1);
    34  ALTER TABLE many_cols3 DROP COLUMN col0;
    35  INSERT INTO many_cols3 (val) VALUES (1);
    36  
    37  CREATE TABLE many_cols4 (
    38  	id INT AUTO_INCREMENT PRIMARY KEY,
    39  	val INT DEFAULT 0,
    40  	col0 INT NOT NULL
    41  );
    42  INSERT INTO many_cols4(col0) VALUES (1);
    43  ALTER TABLE many_cols4 DROP COLUMN col0;
    44  INSERT INTO many_cols4 (val) VALUES (1);
    45  
    46  CREATE TABLE many_cols5 (
    47  	id INT AUTO_INCREMENT PRIMARY KEY,
    48  	val INT DEFAULT 0,
    49  	col0 INT NOT NULL
    50  );
    51  INSERT INTO many_cols5(col0) VALUES (1);
    52  ALTER TABLE many_cols5 DROP COLUMN col0;
    53  INSERT INTO many_cols5 (val) VALUES (1);
    54  
    55  CREATE TABLE finish_mark(a int primary key)