Merge "Fix missingcommenttext message to be more useful in different page layouts"

[lhc/web/wiklou.git] / maintenance / archives / patch-searchindex.sql

diff --git a/maintenance/archives/patch-searchindex.sql b/maintenance/archives/patch-searchindex.sql
index a9f4cdb..36507a2 100644 (file)
--- a/maintenance/archives/patch-searchindex.sql
+++ b/maintenance/archives/patch-searchindex.sql
@@ -8,11 +8,18 @@
 -- Creating searchindex table...
 DROP TABLE IF EXISTS /*$wgDBprefix*/searchindex;
 CREATE TABLE /*$wgDBprefix*/searchindex (
-  si_page int(8) unsigned NOT NULL,
+  -- Key to page_id
+  si_page int unsigned NOT NULL,
+
+  -- Munged version of title
   si_title varchar(255) NOT NULL default '',
-  si_text mediumtext NOT NULL default '',
+
+  -- Munged version of body text
+  si_text mediumtext NOT NULL,
+
   UNIQUE KEY (si_page)
-) TYPE=MyISAM PACK_KEYS=1;
+
+) ENGINE=MyISAM;
 
 -- Copying data into new table...
 INSERT INTO /*$wgDBprefix*/searchindex