From f9aa70c258578d907cdeb1e9d5b26fffca5bede6 Mon Sep 17 00:00:00 2001
From: brettp <brettp@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Fri, 9 Oct 2009 19:33:33 +0000
Subject: Pulled in Justin's search changes from github.

git-svn-id: http://code.elgg.org/elgg/trunk@3520 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/upgrades/2009093001.sql | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100644 engine/schema/upgrades/2009093001.sql

(limited to 'engine/schema/upgrades/2009093001.sql')

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;
+
-- 
cgit v1.2.3

