| Index: trunk/phase3/maintenance/oracle/archives/patch_16_17_schema_changes.sql |
| — | — | @@ -2,7 +2,7 @@ |
| 3 | 3 | |
| 4 | 4 | ALTER TABLE &mw_prefix.archive MODIFY ar_user DEFAULT 0 NOT NULL; |
| 5 | 5 | ALTER TABLE &mw_prefix.archive MODIFY ar_deleted CHAR(1); |
| 6 | | -CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_namespace, ar_title, ar_rev_id); |
| | 6 | +CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_rev_id); |
| 7 | 7 | |
| 8 | 8 | ALTER TABLE &mw_prefix.page MODIFY page_is_redirect default '0'; |
| 9 | 9 | ALTER TABLE &mw_prefix.page MODIFY page_is_new default '0'; |
| Index: trunk/phase3/maintenance/oracle/tables.sql |
| — | — | @@ -131,7 +131,7 @@ |
| 132 | 132 | ALTER TABLE &mw_prefix.archive ADD CONSTRAINT &mw_prefix.archive_fk1 FOREIGN KEY (ar_user) REFERENCES &mw_prefix.mwuser(user_id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED; |
| 133 | 133 | CREATE INDEX &mw_prefix.archive_i01 ON &mw_prefix.archive (ar_namespace,ar_title,ar_timestamp); |
| 134 | 134 | CREATE INDEX &mw_prefix.archive_i02 ON &mw_prefix.archive (ar_user_text,ar_timestamp); |
| 135 | | -CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_namespace, ar_title, ar_rev_id); |
| | 135 | +CREATE INDEX &mw_prefix.archive_i03 ON &mw_prefix.archive (ar_rev_id); |
| 136 | 136 | |
| 137 | 137 | CREATE TABLE &mw_prefix.pagelinks ( |
| 138 | 138 | pl_from NUMBER NOT NULL, |