DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 7de39cf..3d41456 100644 (file)
--- 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 (