From: Alan Knowles Date: Thu, 14 Jul 2016 05:32:12 +0000 (+0800) Subject: sql/events.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=5b587b6d42e61c98545ddfa88cd85d518751af4c sql/events.sql --- diff --git a/sql/events.sql b/sql/events.sql index 222e6e82..f99ba597 100644 --- a/sql/events.sql +++ b/sql/events.sql @@ -25,7 +25,7 @@ ALTER TABLE Events CHANGE COLUMN EventID id INT(11) AUTO_INCREMENT NOT NULL; --# this are for pre-postgres support code.. ALTER TABLE Events CHANGE COLUMN User person_name VARCHAR(128); -ALTER TABLE Events RENAME COLUMN User TO person_name; +-- ALTER TABLE Events RENAME COLUMN User TO person_name; 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);