From a84faf8ac6d8faed0b3bb3eb4018b02e873467db Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 25 Jul 2011 14:54:41 +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 05213c49..6d73ce6a 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -59,14 +59,14 @@ CREATE TABLE `Events` ( ) ; -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 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 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 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 ADD COLUMN remarks INT(11); -- 2.39.2