| Index: trunk/phase3/maintenance/archives/patch-logging-type-action-index.sql |
| — | — | @@ -1 +1 @@ |
| 2 | | -CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action); |
| | 2 | +CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action, log_timestamp); |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -1226,7 +1226,7 @@ |
| 1227 | 1227 | CREATE INDEX /*i*/times ON /*_*/logging (log_timestamp); |
| 1228 | 1228 | CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); |
| 1229 | 1229 | CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp); |
| 1230 | | -CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action); |
| | 1230 | +CREATE INDEX /*i*/type_action ON /*_*/logging(log_type, log_action, log_timestamp); |
| 1231 | 1231 | |
| 1232 | 1232 | |
| 1233 | 1233 | CREATE TABLE /*_*/log_search ( |