http://www.mediawiki.org/wiki/Special:Code/MediaWiki/94239
Revision: 94239
Author: reedy
Date: 2011-08-11 12:49:30 +0000 (Thu, 11 Aug 2011)
Log Message:
-----------
Followup r93211, add log_timestamp to end of the index
Modified Paths:
--------------
trunk/phase3/maintenance/archives/patch-logging-type-action-index.sql
trunk/phase3/maintenance/tables.sql
Modified: trunk/phase3/maintenance/archives/patch-logging-type-action-index.sql
===================================================================
--- trunk/phase3/maintenance/archives/patch-logging-type-action-index.sql
2011-08-11 12:42:31 UTC (rev 94238)
+++ trunk/phase3/maintenance/archives/patch-logging-type-action-index.sql
2011-08-11 12:49:30 UTC (rev 94239)
@@ -1 +1 @@
-CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action);
+CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action,
log_timestamp);
Modified: trunk/phase3/maintenance/tables.sql
===================================================================
--- trunk/phase3/maintenance/tables.sql 2011-08-11 12:42:31 UTC (rev 94238)
+++ trunk/phase3/maintenance/tables.sql 2011-08-11 12:49:30 UTC (rev 94239)
@@ -1226,7 +1226,7 @@
CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp);
CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type,
log_timestamp);
CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp);
-CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action);
+CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action,
log_timestamp);
CREATE TABLE /*_*/log_search (
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
