From 4efea4e34ebd876951d22c5059d9e2aef4b73b8b Mon Sep 17 00:00:00 2001 From: Edward Date: Tue, 13 Jan 2015 13:01:01 +0800 Subject: [PATCH] sql/Person.sql --- sql/Person.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/Person.sql b/sql/Person.sql index 650ac477..0eded643 100644 --- a/sql/Person.sql +++ b/sql/Person.sql @@ -82,6 +82,8 @@ alter table Person change email email varchar(254) NOT NULL DEFAULT ''; ALTER TABLE Person ADD COLUMN authorize_md5 TEXT NOT NULL DEFAULT ''; +ALTER TABLE Person ADD INDEX lookup_authorize_md5_active(authorize_md5, active); + ALTER TABLE Person ADD INDEX lookup_a(email, active); ALTER TABLE Person ADD INDEX lookup_b(email, active, company_id); ALTER TABLE Person add index lookup_owner(owner_id); -- 2.39.2