| Index: trunk/phase3/maintenance/archives/patch-archive_ar_revid.sql |
| — | — | @@ -1,4 +1,3 @@ |
| 2 | 2 | -- Hopefully temporary index. |
| 3 | 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 |
| | 4 | +CREATE INDEX /*i*/ar_revid ON /*$wgDBprefix*/archive ( ar_rev_id ); |
| \ No newline at end of file |
| Index: trunk/phase3/maintenance/sqlite/archives/patch-archive_kill_ar_page_revid.sql |
| — | — | @@ -0,0 +1,3 @@ |
| | 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 | +DROP INDEX IF EXISTS ar_page_revid; |
| \ No newline at end of file |
| Index: trunk/phase3/includes/installer/SqliteUpdater.php |
| — | — | @@ -52,6 +52,8 @@ |
| 53 | 53 | array( 'doCollationUpdate' ), |
| 54 | 54 | array( 'addTable', 'msg_resource', 'patch-msg_resource.sql' ), |
| 55 | 55 | array( 'addTable', 'module_deps', 'patch-module_deps.sql' ), |
| | 56 | + array( 'dropIndex', 'archive', 'ar_page_revid', 'patch-archive_kill_ar_page_revid.sql' ), |
| | 57 | + array( 'addIndex', 'archive', 'ar_revid', 'patch-archive_ar_revid.sql' ), |
| 56 | 58 | |
| 57 | 59 | // 1.19 |
| 58 | 60 | array( 'addTable', 'config', 'patch-config.sql' ), |