From 3906829c31af2bf0fcd50103de7ba12dde2f02dc Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 28 Sep 2011 12:11:12 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 5fbabf80..aa17ec7e 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -56,19 +56,19 @@ CREATE TABLE `Events` ( PRIMARY KEY (`id`) ) ; - -ALTER TABLE Events CHANGE COLUMN EventID id INT(11) AUTO_INCREMENT NOT NULL; -ALTER TABLE Events CHANGE COLUMN User person_name VARCHAR(128); ALTER TABLE Events ADD COLUMN person_id INT(11); +ALTER TABLE Events ADD COLUMN remarks INT(11); +ALTER TABLE Events CHANGE COLUMN EventID id INT(11) AUTO_INCREMENT NOT NULL; +ALTER TABLE Events CHANGE COLUMN User person_name VARCHAR(128); ALTER TABLE Events CHANGE COLUMN Date event_when DATETIME; -ALTER TABLE Events CHANGE COLUMN Event action VARCHAR(32); -ALTER TABLE Events CHANGE COLUMN Host ipaddr VARCHAR(16); +ALTER TABLE Events CHANGE COLUMN Event action VARCHAR(32); +ALTER TABLE Events CHANGE COLUMN Host ipaddr VARCHAR(16); ALTER TABLE Events CHANGE COLUMN ItemID on_id INT(11); ALTER TABLE Events CHANGE COLUMN Container on_table VARCHAR(64); -ALTER TABLE Events ADD COLUMN remarks INT(11); -ALTER TABLE Events ADD COLUMN remarks INT(11); +ALTER TABLE Events ADD INDEX lookup (remarks INT(11); + CREATE TABLE core_event_audit ( `id` int(11) NOT NULL AUTO_INCREMENT, `event_id` int(11) NOT NULL, -- 2.39.2