From 315f04e9bba3d2564fd559b5db9c2df851d26ab2 Mon Sep 17 00:00:00 2001
From: Aaron Schulz <aaron@users.mediawiki.org>
Date: Mon, 9 Jul 2007 20:05:22 +0000
Subject: [PATCH] *Include usertext_timestamp index here

---
 maintenance/tables.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index ed7ecd3668..39d632e7de 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -377,7 +377,8 @@ CREATE TABLE /*$wgDBprefix*/archive (
   -- Length of this revision in bytes
   ar_len int unsigned,
   
-  KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp)
+  KEY name_title_timestamp (ar_namespace,ar_title,ar_timestamp),
+  KEY usertext_timestamp (ar_user_text,ar_timestamp)
 
 ) /*$wgDBTableOptions*/;
 
-- 
2.20.1