CREATE TABLE nucaeb.`message` (
	`id` VARCHAR(100) NOT NULL COLLATE 'euckr_bin',
	`destination` VARCHAR(1000) NOT NULL COLLATE 'euckr_bin',
	`headers` VARCHAR(2000) NOT NULL COLLATE 'euckr_bin',
	`payload` MEDIUMTEXT NOT NULL COLLATE 'euckr_bin',
	`published` SMALLINT(6) NULL DEFAULT '0',
	`message_partition` SMALLINT(6) NULL DEFAULT NULL,
	`creation_time` DATETIME NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `message_published_idx` (`published`, `id`) USING BTREE,
	INDEX `ix_message01` (`published`, `creation_time`) USING BTREE,
	INDEX `ix_message02` (`destination`, `creation_time`) USING BTREE
)
COLLATE='euckr_bin'
ENGINE=InnoDB
;