| Index: trunk/phase3/maintenance/archives/patch-user_email_index.sql |
| — | — | @@ -1 +1 @@ |
| 2 | | - ALTER TABLE /*$wgDBprefix*/user ADD INDEX ( `user_email`(50), `user_name` ); |
| \ No newline at end of file |
| | 2 | +CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50),user_name); |
| \ No newline at end of file |
| Index: trunk/phase3/includes/installer/SqliteUpdater.php |
| — | — | @@ -55,6 +55,9 @@ |
| 56 | 56 | array( 'dropIndex', 'archive', 'ar_page_revid', 'patch-archive_kill_ar_page_revid.sql' ), |
| 57 | 57 | array( 'addIndex', 'archive', 'ar_revid', 'patch-archive_ar_revid.sql' ), |
| 58 | 58 | |
| | 59 | + // 1.18 |
| | 60 | + array( 'addIndex', 'user', 'user_email', 'patch-user_email_index.sql' ), |
| | 61 | + |
| 59 | 62 | // 1.19 |
| 60 | 63 | array( 'addTable', 'config', 'patch-config.sql' ), |
| 61 | 64 | ); |