40
CREATE TABLE `test`.`t1` ( `autoinc_int_field` INT NOT NULL AUTO_INCREMENT, `null_int_field` INT DEFAULT NULL, `not_null_bigint_field` BIGINT NOT NULL, `null_bigint_field` BIGINT DEFAULT NULL, `not_null_int_field` INT NOT NULL, `null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci DEFAULT NULL, `not_null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci NOT NULL, `null_enum_field` ENUM('val1','val2') DEFAULT NULL, `not_null_enum_field` ENUM('val1','val2') NOT NULL, `null_date_field` DATE DEFAULT NULL, `not_null_date_field` DATE NOT NULL, `null_datetime_field` DATETIME DEFAULT NULL, `not_null_datetime_field` DATETIME NOT NULL, `null_blob_field` BLOB, `not_null_blob_field` BLOB NOT NULL, `null_text_field` TEXT COLLATE utf8_general_ci, `not_null_text_field` TEXT COLLATE utf8_general_ci NOT NULL, `null_timestamp_field` TIMESTAMP NULL DEFAULT NULL, `not_null_timestamp_field` TIMESTAMP NOT NULL, `null_double_field` DOUBLE DEFAULT NULL, `not_null_double_field` DOUBLE NOT NULL, `null_decimal_field` DECIMAL(10,2) DEFAULT NULL, `not_null_decimal_field` DECIMAL(10,2) NOT NULL, PRIMARY KEY (`autoinc_int_field`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
40
CREATE TABLE `test`.`t1` ( `autoinc_int_field` INT NOT NULL AUTO_INCREMENT, `null_int_field` INT DEFAULT NULL, `not_null_bigint_field` BIGINT NOT NULL, `null_bigint_field` BIGINT DEFAULT NULL, `not_null_int_field` INT NOT NULL, `null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci DEFAULT NULL, `not_null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci NOT NULL, `null_enum_field` ENUM('val1','val2') DEFAULT NULL, `not_null_enum_field` ENUM('val1','val2') NOT NULL, `null_date_field` DATE DEFAULT NULL, `not_null_date_field` DATE NOT NULL, `null_datetime_field` DATETIME DEFAULT NULL, `not_null_datetime_field` DATETIME NOT NULL, `null_blob_field` BLOB, `not_null_blob_field` BLOB NOT NULL, `null_text_field` TEXT COLLATE utf8_general_ci, `not_null_text_field` TEXT COLLATE utf8_general_ci NOT NULL, `null_timestamp_field` TIMESTAMP NULL DEFAULT NULL, `not_null_timestamp_field` TIMESTAMP NOT NULL, `null_double_field` DOUBLE DEFAULT NULL, `not_null_double_field` DOUBLE NOT NULL, `null_decimal_field` DECIMAL(10,2) DEFAULT NULL, `not_null_decimal_field` DECIMAL(10,2) NOT NULL, PRIMARY KEY (`autoinc_int_field`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
43
43
DROP TABLE `test`.`t1`;
46
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `key1` VARCHAR(10) COLLATE utf8_general_ci NOT NULL, `key2` DOUBLE NOT NULL, `key3` BLOB NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `key1` (`key1`), KEY `named_key` (`key2`), KEY `partial_key` (`key3`(30)) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
46
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `key1` VARCHAR(10) COLLATE utf8_general_ci NOT NULL, `key2` DOUBLE NOT NULL, `key3` BLOB NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `key1` (`key1`) USING BTREE, KEY `named_key` (`key2`) USING BTREE, KEY `partial_key` (`key3`(30)) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
49
49
DROP TABLE `test`.`t1`;
52
52
Generating statements for innodb replication log
54
CREATE TABLE `test`.`t1` ( `autoinc_int_field` INT NOT NULL AUTO_INCREMENT, `null_int_field` INT DEFAULT NULL, `not_null_bigint_field` BIGINT NOT NULL, `null_bigint_field` BIGINT DEFAULT NULL, `not_null_int_field` INT NOT NULL, `null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci DEFAULT NULL, `not_null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci NOT NULL, `null_enum_field` ENUM('val1','val2') DEFAULT NULL, `not_null_enum_field` ENUM('val1','val2') NOT NULL, `null_date_field` DATE DEFAULT NULL, `not_null_date_field` DATE NOT NULL, `null_datetime_field` DATETIME DEFAULT NULL, `not_null_datetime_field` DATETIME NOT NULL, `null_blob_field` BLOB, `not_null_blob_field` BLOB NOT NULL, `null_text_field` TEXT COLLATE utf8_general_ci, `not_null_text_field` TEXT COLLATE utf8_general_ci NOT NULL, `null_timestamp_field` TIMESTAMP NULL DEFAULT NULL, `not_null_timestamp_field` TIMESTAMP NOT NULL, `null_double_field` DOUBLE DEFAULT NULL, `not_null_double_field` DOUBLE NOT NULL, `null_decimal_field` DECIMAL(10,2) DEFAULT NULL, `not_null_decimal_field` DECIMAL(10,2) NOT NULL, PRIMARY KEY (`autoinc_int_field`) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
54
CREATE TABLE `test`.`t1` ( `autoinc_int_field` INT NOT NULL AUTO_INCREMENT, `null_int_field` INT DEFAULT NULL, `not_null_bigint_field` BIGINT NOT NULL, `null_bigint_field` BIGINT DEFAULT NULL, `not_null_int_field` INT NOT NULL, `null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci DEFAULT NULL, `not_null_varchar_field` VARCHAR(100) COLLATE utf8_general_ci NOT NULL, `null_enum_field` ENUM('val1','val2') DEFAULT NULL, `not_null_enum_field` ENUM('val1','val2') NOT NULL, `null_date_field` DATE DEFAULT NULL, `not_null_date_field` DATE NOT NULL, `null_datetime_field` DATETIME DEFAULT NULL, `not_null_datetime_field` DATETIME NOT NULL, `null_blob_field` BLOB, `not_null_blob_field` BLOB NOT NULL, `null_text_field` TEXT COLLATE utf8_general_ci, `not_null_text_field` TEXT COLLATE utf8_general_ci NOT NULL, `null_timestamp_field` TIMESTAMP NULL DEFAULT NULL, `not_null_timestamp_field` TIMESTAMP NOT NULL, `null_double_field` DOUBLE DEFAULT NULL, `not_null_double_field` DOUBLE NOT NULL, `null_decimal_field` DECIMAL(10,2) DEFAULT NULL, `not_null_decimal_field` DECIMAL(10,2) NOT NULL, PRIMARY KEY (`autoinc_int_field`) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
57
57
DROP TABLE `test`.`t1`;
60
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `key1` VARCHAR(10) COLLATE utf8_general_ci NOT NULL, `key2` DOUBLE NOT NULL, `key3` BLOB NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `key1` (`key1`), KEY `named_key` (`key2`), KEY `partial_key` (`key3`(30)) ) ENGINE=InnoDB COLLATE = utf8_general_ci;
60
CREATE TABLE `test`.`t1` ( `id` INT NOT NULL AUTO_INCREMENT, `key1` VARCHAR(10) COLLATE utf8_general_ci NOT NULL, `key2` DOUBLE NOT NULL, `key3` BLOB NOT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `key1` (`key1`) USING BTREE, KEY `named_key` (`key2`) USING BTREE, KEY `partial_key` (`key3`(30)) USING BTREE ) ENGINE=InnoDB COLLATE = utf8_general_ci;
63
63
DROP TABLE `test`.`t1`;