https://www.mediawiki.org/wiki/Special:Code/MediaWiki/113110
Revision: 113110
Author: reedy
Date: 2012-03-06 00:09:18 +0000 (Tue, 06 Mar 2012)
Log Message:
-----------
Followup r113109, forward port the rest of r25267 for Bug 10788 - Filter page
histories by user, or contributions by title
Modified Paths:
--------------
trunk/phase3/includes/installer/MysqlUpdater.php
trunk/phase3/includes/installer/SqliteUpdater.php
trunk/phase3/maintenance/tables.sql
Added Paths:
-----------
trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
Modified: trunk/phase3/includes/installer/MysqlUpdater.php
===================================================================
--- trunk/phase3/includes/installer/MysqlUpdater.php 2012-03-06 00:05:48 UTC
(rev 113109)
+++ trunk/phase3/includes/installer/MysqlUpdater.php 2012-03-06 00:09:18 UTC
(rev 113110)
@@ -195,6 +195,7 @@
// 1.20
array( 'addTable', 'config',
'patch-config.sql' ),
+ array( 'addIndex', 'revision'. 'page_user_timestamp',
'patch-revision-user-page-index.sql' ),
);
}
Modified: trunk/phase3/includes/installer/SqliteUpdater.php
===================================================================
--- trunk/phase3/includes/installer/SqliteUpdater.php 2012-03-06 00:05:48 UTC
(rev 113109)
+++ trunk/phase3/includes/installer/SqliteUpdater.php 2012-03-06 00:09:18 UTC
(rev 113110)
@@ -74,6 +74,7 @@
// 1.20
array( 'addTable', 'config',
'patch-config.sql' ),
+ array( 'addIndex', 'revision'. 'page_user_timestamp',
'patch-revision-user-page-index.sql' ),
);
}
Copied:
trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
(from rev 113109,
trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql)
===================================================================
--- trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
(rev 0)
+++ trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
2012-03-06 00:09:18 UTC (rev 113110)
@@ -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);
Modified: trunk/phase3/maintenance/tables.sql
===================================================================
--- trunk/phase3/maintenance/tables.sql 2012-03-06 00:05:48 UTC (rev 113109)
+++ trunk/phase3/maintenance/tables.sql 2012-03-06 00:09:18 UTC (rev 113110)
@@ -326,6 +326,7 @@
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.
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
