X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-searchindex.sql;h=36507a2be8e889e5b0f6d0080eec9929dbce35b1;hb=08e0ed2b70ba5986a96c701f84a7679c98a6f2fd;hp=aafe21fedac441500b15128eaf43d7d03c22979a;hpb=d82c14fb4fbac288b42ca5918b0a72f33ecb1e69;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/archives/patch-searchindex.sql b/maintenance/archives/patch-searchindex.sql
index aafe21feda..36507a2be8 100644
--- 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;