From a13312d60fcd1db5dc1813424812fdbfc0d1015c Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 13 Nov 2013 12:40:14 +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 d506c927..2b5fd6bd 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -105,6 +105,7 @@ ALTER TABLE Events add index lookup_on_table (on_table); ALTER TABLE Events add index lookup_action_person (action, person_id); + alter table Events add index lookup_actions ( person_id, person_table, action); CREATE TABLE core_event_audit ( id int(11) NOT NULL AUTO_INCREMENT, -- 2.39.2