From 64ac200ca31b77fdb244496e5d1571c77839db84 Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Tue, 6 Mar 2012 00:05:48 +0000 Subject: [PATCH] Pull patch-revision-user-page-index.sql from r25267 --- maintenance/archives/patch-revision-user-page-index.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 maintenance/archives/patch-revision-user-page-index.sql diff --git a/maintenance/archives/patch-revision-user-page-index.sql b/maintenance/archives/patch-revision-user-page-index.sql new file mode 100644 index 0000000000..9058e4e9fc --- /dev/null +++ b/maintenance/archives/patch-revision-user-page-index.sql @@ -0,0 +1,5 @@ +-- New index on revision table to allow searches for all edits by a given user +-- to a given page. Added 2007-08-28 + +ALTER TABLE /*$wgDBprefix*/revision + ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp); -- 2.20.1