| Index: trunk/phase3/maintenance/archives/patch-log_user_text.sql |
| — | — | @@ -1,8 +1,8 @@ |
| 2 | 2 | ALTER TABLE /*$wgDBprefix*/logging |
| 3 | 3 | ADD log_user_text varchar(255) binary NOT NULL default '', |
| 4 | | - ADD log_page int unsigned NULL, |
| | 4 | + ADD log_page_id int unsigned NULL, |
| 5 | 5 | CHANGE log_type log_type varbinary(32) NOT NULL, |
| 6 | 6 | CHANGE log_action log_action varbinary(32) NOT NULL; |
| 7 | 7 | |
| 8 | 8 | CREATE INDEX /*i*/user_type_time ON /*_*/logging (log_user, log_type, log_timestamp); |
| 9 | | -CREATE INDEX /*i*/page_type ON /*_*/logging (log_page,log_timestamp); |
| | 9 | +CREATE INDEX /*i*/page_id_time ON /*_*/logging (log_page,log_timestamp); |