Here's the query for creating ost__search: CREATE TABLE IF NOT EXISTS ost__search ( `object_type` varchar(8) not null, `object_id` int(11) unsigned not null, `title` text collate utf8_general_ci, `content` text collate utf8_general_ci, primary key `object` (`object_type`, `object_id`), fulltext key `search` (`title`, `content`)) ENGINE=MyISAM DEFAULT=utf8reference: https://github.com/osTicket/osTicket/blob/405b909209c0b9b6fd4f31963c38ed5f22537e5c/include/class.search.php#L425-L457