CREATE TABLE `xf_search_index` (
`content_type` VARCHAR(25) NOT NULL,
`content_id` INT(10) UNSIGNED NOT NULL,
`title` VARCHAR(250) NOT NULL DEFAULT '',
`message` MEDIUMTEXT NOT NULL,
`metadata` MEDIUMTEXT NOT NULL,
`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`item_date` INT(10) UNSIGNED NOT NULL,
`discussion_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (`content_type`, `content_id`),
INDEX `user_id_item_date` (`user_id`, `item_date`),
FULLTEXT INDEX `title_message_metadata` (`title`, `message`, `metadata`),
FULLTEXT INDEX `title_metadata` (`title`, `metadata`)
) COLLATE='utf8mb4_general_ci' ENGINE=MyISAM;