From c96fe6c1bd213f6a619e073f725bbeb2a8c5de50 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 9 Jul 2012 13:47:50 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 5c4d7576..b6d89e62 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -89,9 +89,10 @@ ALTER TABLE Events ADD INDEX lookuppt ( person_table); ALTER TABLE Events ADD INDEX lookup_when( person_id, event_id ); ALTER TABLE Events add index lookup_event_when (event_when); -ALTER TABLE Events add index lookup_action (event_action); -ALTER TABLE Events add index lookup_on_table (event_on_table); +ALTER TABLE Events add index lookup_action (action); +ALTER TABLE Events add index lookup_on_table (on_table); +ALTER TABLE Events add index lookup_action_person (action, person_id); CREATE TABLE core_event_audit ( id int(11) NOT NULL AUTO_INCREMENT, -- 2.39.2