From: Alan Knowles Date: Thu, 29 Sep 2011 11:37:48 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=8c92f78178986dcbca71325e29dbb648afb8a3dc DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index e27a52d9..f3e8994f 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -337,6 +337,8 @@ ALTER TABLE core_notify CHANGE COLUMN bounced event_id INT(11) NOT NULL DEFAULT ALTER TABLE core_notify ADD COLUMN act_start DATETIME NOT NULL; ALTER TABLE core_notify ADD COLUMN watch_id INT(11) NOT NULL DEFAULT 0; +ALTER TABLE core_notify ADD COLUMN trigger_person_id INT(11) NOT NULL DEFAULT 0; +ALTER TABLE core_notify ADD COLUMN trigger_event_id INT(11) NOT NULL DEFAULT 0; # - used by email / tracker to handle alises - we have to be carefull adding to this table...