2
DROP DATABASE IF EXISTS bup_ddl_blocker;
5
CREATE DATABASE bup_ddl_blocker;
7
# Create transaction tables and load them with data.
8
--echo con1: Creating tables
9
CREATE TABLE bup_ddl_blocker.t1 (col_a CHAR(40)) ENGINE=INNODB;
10
CREATE TABLE bup_ddl_blocker.t2 (col_a CHAR(40)) ENGINE=MYISAM;
11
CREATE TABLE bup_ddl_blocker.t3 (col_a CHAR(40)) ENGINE=INNODB;
12
CREATE TABLE bup_ddl_blocker.t4 (col_a CHAR(40)) ENGINE=MYISAM;
14
--echo con1: Loading data
15
INSERT INTO bup_ddl_blocker.t1 VALUES ("01 Some data to test");
16
INSERT INTO bup_ddl_blocker.t1 VALUES ("02 Some data to test");
17
INSERT INTO bup_ddl_blocker.t1 VALUES ("03 Some data to test");
19
INSERT INTO bup_ddl_blocker.t2 VALUES ("01 Some data to test");
20
INSERT INTO bup_ddl_blocker.t2 VALUES ("02 Some data to test");
21
INSERT INTO bup_ddl_blocker.t2 VALUES ("03 Some data to test");
23
INSERT INTO bup_ddl_blocker.t3 VALUES ("01 Some data to test");
24
INSERT INTO bup_ddl_blocker.t3 VALUES ("02 Some data to test");
25
INSERT INTO bup_ddl_blocker.t3 VALUES ("03 Some data to test");
27
INSERT INTO bup_ddl_blocker.t4 VALUES ("01 Some data to test");
28
INSERT INTO bup_ddl_blocker.t4 VALUES ("02 Some data to test");
29
INSERT INTO bup_ddl_blocker.t4 VALUES ("03 Some data to test");