blob: ce7bf96e4d569922ed0f75c1673c51741c679633 (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
--Search Index
CREATE TABLE IF NOT EXISTS `prefix_search_index`(
`guid` INT NOT NULL,
`subtype` VARCHAR( 32 ) NOT NULL,
`string` TEXT NOT NULL,
PRIMARY KEY (`guid`,`subtype`),
KEY `guid` (`guid`),
KEY `subtype` (`subtype`),
FULLTEXT KEY `string` (`string`)
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
|