From: KH Lau Date: Fri, 27 Oct 2017 06:42:56 +0000 (+0800) Subject: sql/events.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=cc8a5d9f81de38fc823f14e8a3a162ea3f09ef24 sql/events.sql --- diff --git a/sql/events.sql b/sql/events.sql index 827549ba..273d07fa 100644 --- a/sql/events.sql +++ b/sql/events.sql @@ -17,7 +17,7 @@ ALTER TABLE Events ADD COLUMN on_table varchar(64) NOT NULL default ''; ALTER TABLE Events ADD COLUMN person_id int(11) NOT NULL default 0; ALTER TABLE Events ADD COLUMN person_table varchar(64) NOT NULL default ''; ALTER TABLE Events ADD COLUMN dupe_id INT(11) NOT NULL DEFAULT 0; - +ALTER TABLE Events ADD COLUMN who VARCHAR(128) NOT NULL DEFAULT '' ; ALTER TABLE Events ADD COLUMN remarks text ; @@ -39,4 +39,4 @@ ALTER TABLE Events CHANGE COLUMN action action varchar(64) default NULL; ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_when, person_table); - \ No newline at end of file +