From 3eb9da5d3bc3562521862a2836f962a9cda95fcb Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 28 Sep 2011 15:20:00 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index d7fb0d32..e27a52d9 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -316,6 +316,9 @@ CREATE TABLE `core_watch` ( ) ; ALTER TABLE core_watch ADD INDEX qlookup (`ontable`,`onid`,`user_id`,`event`,`medium`); + + + CREATE TABLE core_notify ( `id` int(11) NOT NULL AUTO_INCREMENT, `act_when` DATETIME NOT NULL, @@ -333,6 +336,7 @@ CREATE TABLE core_notify ( ALTER TABLE core_notify CHANGE COLUMN bounced event_id INT(11) NOT NULL DEFAULT 0; 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; # - used by email / tracker to handle alises - we have to be carefull adding to this table... -- 2.39.2