From: Alan Knowles Date: Mon, 9 Jul 2012 05:31:08 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=31949fe72aca378c49648e1dc728119d32c64d8e DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index fb656ac1..5c4d7576 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -89,7 +89,8 @@ 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); CREATE TABLE core_event_audit (