From 9174573a482f9f1005ea7ea3cc133c27b8bfbaaf Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 9 Jul 2012 13:20:07 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 27e871d2..754065cb 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -85,6 +85,10 @@ ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_ ALTER TABLE Events ADD INDEX lookuppt ( person_table); +ALTER TABLE Events ADD INDEX lookup_when( person_id, event_id ); + + + CREATE TABLE core_event_audit ( id int(11) NOT NULL AUTO_INCREMENT, -- 2.39.2