projects / Pman.Core / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 7a27a0f)
DataObjects/core.sql
authorAlan Knowles <alan@roojs.com>
Mon, 19 Aug 2013 06:54:15 +0000 (14:54 +0800)
committerAlan Knowles <alan@roojs.com>
Mon, 19 Aug 2013 06:54:15 +0000 (14:54 +0800)
DataObjects/core.sql patch | blob | history

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 (
Pman Core