r51581 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:< r51580‎ | r51581 | r51582 >
Date:06:11, 8 June 2009
Author:tstarling
Status:deferred
Tags:
Comment:
Renamed indexes, new indexes must be prefixed to avoid conflicts in SQLite's global index namespace. These indexes are not in tables.sql or any USE INDEX yet.
Modified paths:
  • /trunk/phase3/maintenance/archives/patch-log_user_text.sql (modified) (history)

Diff [purge]

Index: trunk/phase3/maintenance/archives/patch-log_user_text.sql
——@@ -4,5 +4,5 @@
55 CHANGE log_type log_type varbinary(32) NOT NULL,
66 CHANGE log_action log_action varbinary(32) NOT NULL;
77
8 -CREATE INDEX /*i*/user_type_time ON /*_*/logging (log_user, log_type, log_timestamp);
9 -CREATE INDEX /*i*/page_id_time ON /*_*/logging (log_page,log_timestamp);
 8+CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp);
 9+CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp);

Status & tagging log