From 973c6cc567ac687b70a858412ddd2a5a9d1901d7 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 28 Sep 2011 12:11:58 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index aa17ec7e..94392e5c 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -67,7 +67,7 @@ ALTER TABLE Events CHANGE COLUMN ItemID on_id INT(11); ALTER TABLE Events CHANGE COLUMN Container on_table VARCHAR(64); -ALTER TABLE Events ADD INDEX lookup (remarks INT(11); +ALTER TABLE Events ADD INDEX lookup (on_id, on_table, person_id, event_when); CREATE TABLE core_event_audit ( `id` int(11) NOT NULL AUTO_INCREMENT, -- 2.39.2