1 files changed, 14 insertions, 2 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 9eace7d52..b1e926325 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -534,10 +534,22 @@ CREATE TABLE role (
 
 CREATE TABLE search_index (
   word varchar(50) NOT NULL default '',
-  lno int(10) unsigned NOT NULL default '0',
+  sid int(10) unsigned NOT NULL default '0',
   type varchar(16) default NULL,
+  fromsid int(10) unsigned NOT NULL default '0',
+  fromtype varchar(16) default NULL,
+  score int(10) unsigned default NULL,
+  KEY sid (sid),
+  KEY word (word)
+) TYPE=MyISAM;
+
+--
+-- Table structure for table 'search_total'
+--
+
+CREATE TABLE search_total (
+  word varchar(50) NOT NULL default '',
   count int(10) unsigned default NULL,
-  KEY lno (lno),
   KEY word (word)
 ) TYPE=MyISAM;