From 8f18e84c43797d7e1e149455e1409b6f861290c8 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 25 Jul 2011 14:53:57 +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 4e5e4a07..05213c49 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -59,14 +59,14 @@ CREATE TABLE `Events` ( ) ; -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 ALTER COLUMN EventID id INT(11) AUTO_INCREMENT NOT NULL; +ALTER TABLE Events ALTER COLUMN User person_name VARCHAR(128); ALTER TABLE Events ADD COLUMN person_id INT(11); -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 ItemID on_id INT(11); -ALTER TABLE Events CHANGE COLUMN Container on_table VARCHAR(64); +ALTER TABLE Events ALTER COLUMN Date event_when DATETIME; +ALTER TABLE Events ALTER COLUMN Event action VARCHAR(32); +ALTER TABLE Events ALTER COLUMN Host ipaddr VARCHAR(16); +ALTER TABLE Events ALTER COLUMN ItemID on_id INT(11); +ALTER TABLE Events ALTER COLUMN Container on_table VARCHAR(64); ALTER TABLE Events ADD COLUMN remarks INT(11); -- 2.39.2