X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=3d41456e84b3b97858202adc84d5dd37fc1e5a7e;hp=7de39cf9e112cdd0a6a12139d4626a3db90a498f;hb=c792fd6aea4a94eb4fdea9cd81dd587d60c380df;hpb=7a27a0f9732ff309fda3c0ad3fa20c1118460140

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 7de39cf9..3d41456e 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -229,6 +229,9 @@ alter table Person change email email varchar(254) NOT NULL DEFAULT '';
 
 
 
+ALTER TABLE Person ADD INDEX lookup_a(email, active);
+ALTER TABLE Person ADD INDEX lookup_b(email, active, company_id);
+
 
 
 CREATE TABLE Projects (