diff options
| author | brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-10-09 19:33:33 +0000 |
|---|---|---|
| committer | brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544> | 2009-10-09 19:33:33 +0000 |
| commit | f9aa70c258578d907cdeb1e9d5b26fffca5bede6 (patch) | |
| tree | 35596f164c262cc6d2f653ff16f7fa650118f186 /engine/schema | |
| parent | b62012bf3da994298ad52a4ccec06e814bcc5a79 (diff) | |
| download | elgg-f9aa70c258578d907cdeb1e9d5b26fffca5bede6.tar.gz elgg-f9aa70c258578d907cdeb1e9d5b26fffca5bede6.tar.bz2 | |
Pulled in Justin's search changes from github.
git-svn-id: http://code.elgg.org/elgg/trunk@3520 36083f99-b078-4883-b0ff-0f9b5a30f544
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; + |