1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
DROP SCHEMA IF EXISTS drizzledump_migrate_test;
Dropping test database on MySQL...
Create test database on MySQL...
populating MySQL with test data...
calling drizzledump to populate Drizzle...
test our table:
SHOW CREATE TABLE drizzledump_migrate_test.t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` INT DEFAULT NULL COMMENT '.'
) ENGINE=InnoDB COLLATE = utf8_general_ci
SHOW CREATE TABLE drizzledump_migrate_test.t2;
Table Create Table
t2 CREATE TABLE `t2` (
`a` INT DEFAULT NULL COMMENT 'This is a pretty long comment so we can see how drizzledump will handle this'
) ENGINE=InnoDB COLLATE = utf8_general_ci
SHOW CREATE TABLE drizzledump_migrate_test.t3;
Table Create Table
t3 CREATE TABLE `t3` (
`a` INT DEFAULT NULL
) ENGINE=InnoDB COMMENT='.' COLLATE = utf8_general_ci
SHOW CREATE TABLE drizzledump_migrate_test.t4;
Table Create Table
t4 CREATE TABLE `t4` (
`a` INT DEFAULT NULL
) ENGINE=InnoDB COMMENT='This is a longish table comment so we can test drizzledumps ' COLLATE = utf8_general_ci
SHOW CREATE TABLE drizzledump_migrate_test.t5;
Table Create Table
t5 CREATE TABLE `t5` (
`a` INT DEFAULT NULL COMMENT 'Now we test column + table comments'
) ENGINE=InnoDB COMMENT='Now we test table + column comments' COLLATE = utf8_general_ci
Dropping test database on MySQL...
DROP SCHEMA drizzledump_migrate_test ;
|