sql/Person.sql

diff --git a/sql/Person.sql b/sql/Person.sql
index 650ac47..0eded64 100644 (file)
--- 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);