From 495ec45a8a08d4ce9defc51da690f80f3369185d Mon Sep 17 00:00:00 2001 From: Happy-melon Date: Wed, 20 Apr 2011 19:02:51 +0000 Subject: [PATCH] Follow-up r86485: SQL error in patch, and also add the index to tables.sql. --- maintenance/archives/patch-user_email_index.sql | 2 +- maintenance/tables.sql | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/maintenance/archives/patch-user_email_index.sql b/maintenance/archives/patch-user_email_index.sql index 7218c958f8..8e0b25ee42 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`, `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 11392f1855..93c41565bb 100644 --- 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); -- -- 2.20.1