From: Edward <edward@roojs.com>
Date: Tue, 13 Jan 2015 05:01:01 +0000 (+0800)
Subject: sql/Person.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=4efea4e34ebd876951d22c5059d9e2aef4b73b8b

sql/Person.sql
---

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);