r113112 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r113111‎ | r113112 | r113113 >
Date:00:26, 6 March 2012
Author:reedy
Status:ok
Tags:
Comment:
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 (modified) (history)
  • /trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql (modified) (history)

Diff [purge]

Index: trunk/phase3/maintenance/archives/patch-revision-user-page-index.sql
——@@ -1,5 +1,4 @@
22 -- New index on revision table to allow searches for all edits by a given user
33 -- to a given page. Added 2007-08-28
44
5 -ALTER TABLE /*$wgDBprefix*/revision
6 - ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp);
 5+CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp);
Index: trunk/phase3/maintenance/sqlite/archives/patch-revision-user-page-index.sql
——@@ -1,5 +1,4 @@
22 -- New index on revision table to allow searches for all edits by a given user
33 -- to a given page. Added 2007-08-28
44
5 -ALTER TABLE /*$wgDBprefix*/revision
6 - ADD INDEX page_user_timestamp (rev_page,rev_user,rev_timestamp);
 5+CREATE INDEX /*i*/page_user_timestamp ON /*_*/revision (rev_page,rev_user,rev_timestamp);

Past revisions this follows-up on

RevisionCommit summaryAuthorDate
r113110Followup r113109, forward port the rest of r25267 for Bug 10788 - Filter page...reedy00:09, 6 March 2012

Status & tagging log