| Index: trunk/phase3/includes/installer/MysqlUpdater.php |
| — | — | @@ -171,6 +171,8 @@ |
| 172 | 172 | array( 'doCollationUpdate' ), |
| 173 | 173 | array( 'addTable', 'msg_resource', 'patch-msg_resource.sql' ), |
| 174 | 174 | array( 'addTable', 'module_deps', 'patch-module_deps.sql' ), |
| | 175 | + array( 'dropIndex', 'archive', 'ar_page_revid', 'patch-archive_kill_ar_page_revid.sql' ), |
| | 176 | + array( 'addIndex', 'archive', 'ar_revid', 'patch-archive_ar_revid.sql' ), |
| 175 | 177 | ); |
| 176 | 178 | } |
| 177 | 179 | |
| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -419,7 +419,7 @@ |
| 420 | 420 | |
| 421 | 421 | CREATE INDEX /*i*/name_title_timestamp ON /*_*/archive (ar_namespace,ar_title,ar_timestamp); |
| 422 | 422 | CREATE INDEX /*i*/ar_usertext_timestamp ON /*_*/archive (ar_user_text,ar_timestamp); |
| 423 | | -CREATE INDEX /*i*/ar_page_revid ON /*_*/archive (ar_rev_id); |
| | 423 | +CREATE INDEX /*i*/ar_revid ON /*_*/archive (ar_rev_id); |
| 424 | 424 | |
| 425 | 425 | |
| 426 | 426 | -- |
| Index: trunk/phase3/maintenance/archives/patch-archive_ar_revid.sql |
| — | — | @@ -0,0 +1,4 @@ |
| | 2 | +-- Hopefully temporary index. |
| | 3 | +-- For https://bugzilla.wikimedia.org/show_bug.cgi?id=21279 |
| | 4 | +ALTER TABLE /*$wgDBprefix*/archive |
| | 5 | + ADD INDEX ar_revid ( ar_rev_id ); |
| \ No newline at end of file |
| Property changes on: trunk/phase3/maintenance/archives/patch-archive_ar_revid.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 6 | + native |
| Index: trunk/phase3/maintenance/archives/patch-archive_kill_ar_page_revid.sql |
| — | — | @@ -0,0 +1,4 @@ |
| | 2 | +-- Used for killing the wrong index added during SVN for 1.17 |
| | 3 | +-- Won't affect most people, but it doesn't need to exist |
| | 4 | +ALTER TABLE /*$wgDBprefix*/archive |
| | 5 | + DROP INDEX ar_page_revid; |
| \ No newline at end of file |
| Property changes on: trunk/phase3/maintenance/archives/patch-archive_kill_ar_page_revid.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 6 | + native |