From 46bd339dca4cec6e81d3befc0d8e583df39968b0 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 25 May 2012 18:29:49 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index b5324374..78979197 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -346,8 +346,8 @@ CREATE TABLE core_notify ( id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ); -ALTER TABLE core_notify ADD COLUMN evtype VARCHAR(128) NOT NULL; -ALTER TABLE core_notify ADD COLUMN recur_id INT(11) NOT NULL; +ALTER TABLE core_notify ADD COLUMN evtype VARCHAR(128) NOT NULL default ''; +ALTER TABLE core_notify ADD COLUMN recur_id INT(11) NOT NULL default 0; ALTER TABLE core_notify ADD COLUMN act_when DATETIME ; ALTER TABLE core_notify ADD COLUMN act_start DATETIME ; ALTER TABLE core_notify ADD COLUMN onid int(11) NOT NULL DEFAULT 0; -- 2.39.2