From: Alan Knowles <alan@roojs.com>
Date: Mon, 19 Aug 2013 06:54:15 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c792fd6aea4a94eb4fdea9cd81dd587d60c380df

DataObjects/core.sql
---

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 (