https://www.mediawiki.org/wiki/Special:Code/MediaWiki/113112
Revision: 113112
Author: reedy
Date: 2012-03-06 00:26:48 +0000 (Tue, 06 Mar 2012)
Log Message:
-----------
Can someone standardi[sz]e SQL already!?
Might aswell change mysql to same format as the sqlite one is becoming
Ping r113110
Modified Paths:
--------------
trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
Modified: trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
===================================================================
--- trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
2012-03-06 00:10:36 UTC (rev 113111)
+++ trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
2012-03-06 00:26:48 UTC (rev 113112)
@@ -1,5 +1,4 @@
-- 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);
+CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision
(rev_page,rev_user,rev_timestamp);
Modified:
trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
===================================================================
--- trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
2012-03-06 00:10:36 UTC (rev 113111)
+++ trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
2012-03-06 00:26:48 UTC (rev 113112)
@@ -1,5 +1,4 @@
-- 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);
+CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision
(rev_page,rev_user,rev_timestamp);
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
