1 files changed, 8 insertions, 0 deletions
diff --git a/database.sql b/database.sql
index 432ce7693..343d4c497 100644
--- a/database.sql
+++ b/database.sql
@@ -613,3 +613,11 @@ CREATE TABLE IF NOT EXISTS `deliverq` (
 `item` INT NOT NULL ,
 `contact` INT NOT NULL
 ) ENGINE = MyISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE IF NOT EXISTS `search` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`uid` INT NOT NULL ,
+`term` CHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
+INDEX ( `uid` ),
+INDEX ( `term` )
+) ENGINE = MyISAM DEFAULT CHARSET=utf8;