DataObjects/Core_event_audit.php

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index aa17ec7..d7fb0d3 100644 (file)
--- 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,
@@ -76,7 +76,7 @@ CREATE TABLE  core_event_audit  (
     `old_audit_id` int(11)  NOT NULL,
     `newvalue` BLOB  NOT NULL,
     PRIMARY KEY (`id`),
-    INDEX `lookup`(`event_id`, `name`, `last_audit_id`)
+    INDEX `lookup`(`event_id`, `name`, `old_audit_id`)
 );