From 9a0523b0d61bc7811983776516e9a94e521d1e19 Mon Sep 17 00:00:00 2001 From: Max Semenik Date: Wed, 15 Jun 2011 17:57:00 +0000 Subject: [PATCH] SQLite support for r86485 --- includes/installer/SqliteUpdater.php | 3 +++ maintenance/archives/patch-user_email_index.sql | 2 +- 2 files changed, 4 insertions(+), 1 deletion(-) diff --git a/includes/installer/SqliteUpdater.php b/includes/installer/SqliteUpdater.php index 36bc679961..cd7f717e77 100644 --- a/includes/installer/SqliteUpdater.php +++ b/includes/installer/SqliteUpdater.php @@ -55,6 +55,9 @@ class SqliteUpdater extends DatabaseUpdater { array( 'dropIndex', 'archive', 'ar_page_revid', 'patch-archive_kill_ar_page_revid.sql' ), array( 'addIndex', 'archive', 'ar_revid', 'patch-archive_ar_revid.sql' ), + // 1.18 + array( 'addIndex', 'user', 'user_email', 'patch-user_email_index.sql' ), + // 1.19 array( 'addTable', 'config', 'patch-config.sql' ), ); diff --git a/maintenance/archives/patch-user_email_index.sql b/maintenance/archives/patch-user_email_index.sql index 8e0b25ee42..c770f047b0 100644 --- a/maintenance/archives/patch-user_email_index.sql +++ b/maintenance/archives/patch-user_email_index.sql @@ -1 +1 @@ - ALTER TABLE /*$wgDBprefix*/user ADD INDEX ( `user_email`(50), `user_name` ); \ No newline at end of file +CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50),user_name); \ No newline at end of file -- 2.20.1