https://www.mediawiki.org/wiki/Special:Code/MediaWiki/113109
Revision: 113109
Author: reedy
Date: 2012-03-06 00:05:48 +0000 (Tue, 06 Mar 2012)
Log Message:
-----------
Pull patch-revision-user-page-index.sql from r25267
Added Paths:
-----------
trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
Copied: trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
(from rev 25267,
trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql)
===================================================================
--- trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
(rev 0)
+++ trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
2012-03-06 00:05:48 UTC (rev 113109)
@@ -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);
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
