Follow-up r86485: SQL error in patch, and also add the index to tables.sql.

diff --git a/maintenance/archives/patch-user_email_index.sql b/maintenance/archives/patch-user_email_index.sql
index 7218c95..8e0b25e 100644 (file)
--- 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`, `user_name` );
\ No newline at end of file
+ ALTER TABLE /*$wgDBprefix*/user ADD INDEX ( `user_email`(50), `user_name` );
\ No newline at end of file

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 11392f1..93c4156 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -135,6 +135,7 @@ CREATE TABLE /*_*/user (
 
 CREATE UNIQUE INDEX /*i*/user_name ON /*_*/user (user_name);
 CREATE INDEX /*i*/user_email_token ON /*_*/user (user_email_token);
+CREATE INDEX /*i*/user_email ON /*_*/user (user_email(50),user_name);
 
 
 --