Merge "Add default for revision.rev_text_id where missing"

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

diff --git a/maintenance/archives/patch-indexes.sql b/maintenance/archives/patch-indexes.sql
index 58fb365..c24d995 100644 (file)
--- a/maintenance/archives/patch-indexes.sql
+++ b/maintenance/archives/patch-indexes.sql
@@ -1,24 +1,24 @@
--- 
+--
 -- patch-indexes.sql
--- 
+--
 -- Fix up table indexes; new to stable release in November 2003
--- 
+--
 
-ALTER TABLE links
+ALTER TABLE IF EXISTS /*$wgDBprefix*/links
    DROP INDEX l_from,
    ADD INDEX l_from (l_from);
 
-ALTER TABLE brokenlinks
+ALTER TABLE /*$wgDBprefix*/brokenlinks
    DROP INDEX bl_to,
    ADD INDEX bl_to (bL_to);
 
-ALTER TABLE recentchanges
+ALTER TABLE /*$wgDBprefix*/recentchanges
    ADD INDEX rc_timestamp (rc_timestamp),
    ADD INDEX rc_namespace_title (rc_namespace, rc_title),
    ADD INDEX rc_cur_id (rc_cur_id);
 
-ALTER TABLE archive
+ALTER TABLE /*$wgDBprefix*/archive
    ADD KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp);
 
-ALTER TABLE watchlist
+ALTER TABLE /*$wgDBprefix*/watchlist
    ADD KEY namespace_title (wl_namespace,wl_title);