From 4b02d706504919b033ce6ceb0fd7edf89dcb7bbe Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 30 Mar 2011 14:17:47 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 15 ++++++++------- 1 file changed, 8 insertions(+), 7 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index a7fd793a..0725f937 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -312,19 +312,20 @@ CREATE TABLE `core_watch` ( ) ; ALTER TABLE core_watch ADD INDEX qlookup (`ontable`,`onid`,`user_id`,`event`,`medium`); -CREATE TABLE core_notify ( +CREATE TABLE core_notify ( `id` int(11) NOT NULL AUTO_INCREMENT, - `act_when` datetime NOT NULL, - `onid` int(11) NOT NULL, - `ontable` int(11) NOT NULL, - `person_id` int(11) NOT NULL, - `msgid` varchar(128) NOT NULL, + `act_when` DATETIME NOT NULL, + `onid` int(11) NOT NULL DEFAULT 0, + `ontable` varchar(128) NOT NULL DEFAULT '', + `person_id` int(11) NOT NULL DEFAULT 0, + `msgid` varchar(128) NOT NULL DEFAULT '', + `sent` DATETIME NOT NULL, + `bounced` int(4) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), INDEX `lookup`(`act_when`, `msgid`) ); - # - used by email / tracker to handle alises - we have to be carefull adding to this table... -- 2.39.2