From: Alan Knowles Date: Wed, 28 Sep 2011 04:09:55 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=dd132ab9515af29e62ae4370284d1928d1da031b DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index b45fd026..ddac6e68 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -68,13 +68,13 @@ ALTER TABLE Events CHANGE COLUMN Container on_table VARCHAR(64); ALTER TABLE Events ADD COLUMN remarks INT(11); CREATE TABLE core_event_audit ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `event_id` int(11) NOT NULL, - `name` varchar(128) NOT NULL, - `old_audit_id` int(11) NOT NULL, - `newvalue` BLOB NOT NULL, - PRIMARY KEY (`id`), - INDEX `lookup`(`event_id`, `name`, `last_audit_id`) + `id` int(11) NOT NULL AUTO_INCREMENT, + `event_id` int(11) NOT NULL, + `name` varchar(128) NOT NULL, + `old_audit_id` int(11) NOT NULL, + `newvalue` BLOB NOT NULL, + PRIMARY KEY (`id`), + INDEX `lookup`(`event_id`, `name`, `last_audit_id`) );