From 921c862c972b5b1b3875d822bcfa50808e98ac47 Mon Sep 17 00:00:00 2001 From: Sam Reed Date: Tue, 6 Mar 2012 00:09:18 +0000 Subject: [PATCH] Followup r113109, forward port the rest of r25267 for Bug 10788 - Filter page histories by user, or contributions by title --- includes/installer/MysqlUpdater.php | 1 + includes/installer/SqliteUpdater.php | 1 + .../sqlite/archives/patch-revision-user-page-index.sql | 5 +++++ maintenance/tables.sql | 1 + 4 files changed, 8 insertions(+) create mode 100644 maintenance/sqlite/archives/patch-revision-user-page-index.sql diff --git a/includes/installer/MysqlUpdater.php b/includes/installer/MysqlUpdater.php index 1c2937a917..c82cb2237e 100644 --- a/includes/installer/MysqlUpdater.php +++ b/includes/installer/MysqlUpdater.php @@ -195,6 +195,7 @@ class MysqlUpdater extends DatabaseUpdater { // 1.20 array( 'addTable', 'config', 'patch-config.sql' ), + array( 'addIndex', 'revision'. 'page_user_timestamp', 'patch-revision-user-page-index.sql' ), ); } diff --git a/includes/installer/SqliteUpdater.php b/includes/installer/SqliteUpdater.php index 2d9d00ac31..4c7305d83c 100644 --- a/includes/installer/SqliteUpdater.php +++ b/includes/installer/SqliteUpdater.php @@ -74,6 +74,7 @@ class SqliteUpdater extends DatabaseUpdater { // 1.20 array( 'addTable', 'config', 'patch-config.sql' ), + array( 'addIndex', 'revision'. 'page_user_timestamp', 'patch-revision-user-page-index.sql' ), ); } diff --git a/maintenance/sqlite/archives/patch-revision-user-page-index.sql b/maintenance/sqlite/archives/patch-revision-user-page-index.sql new file mode 100644 index 0000000000..9058e4e9fc --- /dev/null +++ b/maintenance/sqlite/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); diff --git a/maintenance/tables.sql b/maintenance/tables.sql index de4de08d8c..60fc7fc1bb 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -326,6 +326,7 @@ CREATE INDEX /*i*/rev_timestamp ON /*_*/revision (rev_timestamp); CREATE INDEX /*i*/page_timestamp ON /*_*/revision (rev_page,rev_timestamp); CREATE INDEX /*i*/user_timestamp ON /*_*/revision (rev_user,rev_timestamp); CREATE INDEX /*i*/usertext_timestamp ON /*_*/revision (rev_user_text,rev_timestamp); +CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp); -- -- Holds text of individual page revisions. -- 2.20.1