1 files changed, 24 insertions, 0 deletions
diff --git a/maintenance/archives/patch-indexes.sql b/maintenance/archives/patch-indexes.sql
new file mode 100644
index 00000000..23eec07d
--- /dev/null
+++ b/maintenance/archives/patch-indexes.sql
@@ -0,0 +1,24 @@
+-- 
+-- patch-indexes.sql
+-- 
+-- Fix up table indexes; new to stable release in November 2003
+-- 
+
+ALTER TABLE /*$wgDBprefix*/links
+   DROP INDEX l_from,
+   ADD INDEX l_from (l_from);
+
+ALTER TABLE /*$wgDBprefix*/brokenlinks
+   DROP INDEX bl_to,
+   ADD INDEX bl_to (bL_to);
+
+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 /*$wgDBprefix*/archive
+   ADD KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp);
+
+ALTER TABLE /*$wgDBprefix*/watchlist
+   ADD KEY namespace_title (wl_namespace,wl_title);