diff options
Diffstat (limited to 'engine/schema')
| -rw-r--r-- | engine/schema/upgrades/2009093001.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/engine/schema/upgrades/2009093001.sql b/engine/schema/upgrades/2009093001.sql new file mode 100644 index 000000000..ce7bf96e4 --- /dev/null +++ b/engine/schema/upgrades/2009093001.sql @@ -0,0 +1,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; + |