From 23b76563dcc2542cff9f447e809462472cfccd88 Mon Sep 17 00:00:00 2001 From: alecpl Date: Tue, 29 Sep 2009 07:59:25 +0000 Subject: - use better index for contacts table --- SQL/mysql.update.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'SQL/mysql.update.sql') diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index 729fd3c66..77bf317e9 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -54,3 +54,6 @@ TRUNCATE `messages`; ALTER TABLE `session` CHANGE `vars` `vars` MEDIUMTEXT NOT NULL; + +ALTER TABLE `contacts` + ADD INDEX `user_contacts_index` (`user_id`,`email`); -- cgit v1.2.3