2 CREATE TABLE `search_searchentry` (
3 `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
4 `text` longtext NOT NULL,
5 `obj_type` varchar(20) NOT NULL,
6 `obj_id` integer NOT NULL,
7 `tags` varchar(200) NOT NULL,
8 `priority` integer NOT NULL
13 create fulltext index search_text on search_searchentry (text);
14 create index search_objtype on search_searchentry (obj_type);
15 create index search_objid on search_searchentry (obj_id);
16 create index search_tags on search_searchentry (tags);
17 create index search_priority on search_searchentry (priority);