Followup r93211, add log_timestamp to end of the index

diff --git a/maintenance/archives/patch-logging-type-action-index.sql b/maintenance/archives/patch-logging-type-action-index.sql
index c5b921e..5edc61a 100644 (file)
--- a/maintenance/archives/patch-logging-type-action-index.sql
+++ b/maintenance/archives/patch-logging-type-action-index.sql
@@ -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);

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index fa8d657..2ab431f 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -1226,7 +1226,7 @@ CREATE INDEX /*i*/page_time ON /*_*/logging (log_namespace, log_title, log_times
 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 (