|
1
by brian
clean slate |
1 |
--disable_warnings |
2 |
DROP DATABASE IF EXISTS bup_ddl_blocker; |
|
3 |
--enable_warnings |
|
4 |
||
5 |
CREATE DATABASE bup_ddl_blocker; |
|
6 |
||
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; |
|
13 |
||
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"); |
|
18 |
||
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"); |
|
22 |
||
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"); |
|
26 |
||
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"); |
|
30 |