From 96230a40fc1502aab1e3c09546bcc1dda5e86db9 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 22 Aug 2013 11:36:50 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 1 + 1 file changed, 1 insertion(+) 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); -- 2.39.2