1
DROP SCHEMA IF EXISTS drizzledump_migrate_test;
2
Dropping test database on MySQL...
3
Create test database on MySQL...
4
populating MySQL with test data...
5
calling drizzledump to populate Drizzle...
8
SHOW CREATE TABLE drizzledump_migrate_test.float_table;
10
float_table CREATE TABLE `float_table` (
11
`description` TEXT COLLATE utf8_general_ci,
12
`col_float_unsigned` DOUBLE(12,0) DEFAULT NULL,
13
`col_float0` DOUBLE(12,0) DEFAULT NULL,
14
`col_float1` DOUBLE(12,0) DEFAULT NULL,
15
`col_float2` DOUBLE(2,0) DEFAULT NULL,
16
`col_float2_1` DOUBLE(12,0) DEFAULT NULL,
17
`col_float` DOUBLE(12,0) DEFAULT NULL,
18
`col_float_5_2` DOUBLE(5,2) DEFAULT NULL,
19
`col_float_23` DOUBLE(23,1) DEFAULT NULL,
20
`col_float_not_null` DOUBLE(12,0) NOT NULL,
21
`col_float_default_null` DOUBLE(12,0) DEFAULT NULL,
22
`col_float_default` DOUBLE(5,2) DEFAULT '999.99'
23
) ENGINE=InnoDB COLLATE = utf8_general_ci
24
SELECT * FROM drizzledump_migrate_test.float_table;
25
description col_float_unsigned col_float0 col_float1 col_float2 col_float2_1 col_float col_float_5_2 col_float_23 col_float_not_null col_float_default_null col_float_default
26
MIN 0 NULL -9 -99 -99 -10000000000 -999.99 -9999999778196308000000.0 -10000000000 NULL 999.99
27
MAX 1000000000 NULL 9 99 99 10000000000 999.99 9999999778196308000000.0 10000000000 NULL 999.99
28
NULL NULL NULL NULL NULL NULL NULL NULL NULL 1000 NULL 999.99
29
Dropping test database on MySQL...
30
DROP SCHEMA drizzledump_migrate_test;