From: Alan Knowles <alan@roojs.com>
Date: Thu, 22 Aug 2013 03:36:50 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=96230a40fc1502aab1e3c09546bcc1dda5e86db9

DataObjects/core.sql
---

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index a17900f8..873dc3a1 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -231,6 +231,7 @@ 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);
+alter table Person add index lookup_owner(owner_id);