From c792fd6aea4a94eb4fdea9cd81dd587d60c380df Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 19 Aug 2013 14:54:15 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 3 +++ 1 file changed, 3 insertions(+) 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 ( -- 2.39.2