CREATE TABLE `table_name` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`int_field` BIGINT(20) NOT NULL DEFAULT '0',
`string_field` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`long_text_field` LONGTEXT NULL COLLATE 'utf8_unicode_ci',
`time_stamp_field` TIMESTAMP NULL DEFAULT NULL,
`date_field` DATE NULL DEFAULT NULL,
`date_time_field` DATETIME NULL DEFAULT NULL,
`tinyint_field` TINYINT(1) NOT NULL DEFAULT '0',
`double_field` DOUBLE(30,10) NULL DEFAULT '0.0000000000',
`enum_field` ENUM('TRUE','FALSE') NULL DEFAULT 'TRUE' COLLATE 'utf8_unicode_ci',
`set_field` SET('XA','XB','XC') NULL DEFAULT 'XA,XB' COLLATE 'utf8_unicode_ci',
`uuid` VARCHAR(70) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
PRIMARY KEY (`id`),
UNIQUE INDEX `uuid` (`uuid`),
INDEX `int_field_index` (`int_field`),
INDEX `int_field_index_complex` (`int_field`, `string_field`)
) COLLATE='utf8_general_ci' ENGINE=InnoDB;