From 97f20360215b8e0105209d8f1e7d4e68a343061d Mon Sep 17 00:00:00 2001
From: Brion Vibber <brion@users.mediawiki.org>
Date: Thu, 20 Nov 2003 01:36:53 +0000
Subject: [PATCH] Add forgotten index patch

---
 maintenance/archives/patch-indexes.sql | 24 ++++++++++++++++++++++++
 maintenance/archives/patch-list.txt    | 14 ++++++++++++++
 2 files changed, 38 insertions(+)
 create mode 100644 maintenance/archives/patch-indexes.sql

diff --git a/maintenance/archives/patch-indexes.sql b/maintenance/archives/patch-indexes.sql
new file mode 100644
index 0000000000..58fb3656af
--- /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 links
+   DROP INDEX l_from,
+   ADD INDEX l_from (l_from);
+
+ALTER TABLE brokenlinks
+   DROP INDEX bl_to,
+   ADD INDEX bl_to (bL_to);
+
+ALTER TABLE 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
+   ADD KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp);
+
+ALTER TABLE watchlist
+   ADD KEY namespace_title (wl_namespace,wl_title);
diff --git a/maintenance/archives/patch-list.txt b/maintenance/archives/patch-list.txt
index 9829b1107c..d4f0bee13c 100644
--- a/maintenance/archives/patch-list.txt
+++ b/maintenance/archives/patch-list.txt
@@ -138,6 +138,20 @@ plain interwiki.sql to load up the default set of mappings.
 * 2003-09: Ipblocks auto-expiry update
 patch-ipblocks.sql
 
+* Interwiki URL table
+Moves the interwiki prefix<->url mapping table from a static array
+into the database. If you've got a custom table, be sure to make
+your changes!
+ 
+Run patch-interwiki.sql to create the interwiki table, then the
+plain interwiki.sql to load up the default set of mappings.
+
+* 2003-11: Indexes
+Fixes up indexes on links, brokenlinks, recentchanges, watchlist,
+and archive tables to boost speed.
+
+Run patch-indexes.sql.
+
 * 2003-11: linkscc table creation
 patch-linkscc.sql
 
-- 
2.20.1