Merge "Add constants for schema migration feature flags"

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

diff --git a/maintenance/archives/patch-searchindex.sql b/maintenance/archives/patch-searchindex.sql
index aafe21f..36507a2 100644 (file)
--- a/maintenance/archives/patch-searchindex.sql
+++ b/maintenance/archives/patch-searchindex.sql
@@ -6,28 +6,35 @@
 -- 2002-12-16, 2003-01-25 Brion VIBBER <brion@pobox.com>
 
 -- Creating searchindex table...
-DROP TABLE IF EXISTS searchindex;
-CREATE TABLE searchindex (
-  si_page int(8) unsigned NOT NULL,
+DROP TABLE IF EXISTS /*$wgDBprefix*/searchindex;
+CREATE TABLE /*$wgDBprefix*/searchindex (
+  -- 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 searchindex
+INSERT INTO /*$wgDBprefix*/searchindex
   (si_page,si_title,si_text)
   SELECT
     cur_id,cur_ind_title,cur_ind_text
-    FROM cur;
+    FROM /*$wgDBprefix*/cur;
 
 
 -- Creating fulltext index...
-ALTER TABLE searchindex
+ALTER TABLE /*$wgDBprefix*/searchindex
   ADD FULLTEXT si_title (si_title),
   ADD FULLTEXT si_text (si_text);
 
 -- Dropping index columns from cur table.
-ALTER TABLE cur
+ALTER TABLE /*$wgDBprefix*/cur
   DROP COLUMN cur_ind_title,
   DROP COLUMN cur_ind_text;