From a87e29b21b22c5ce9bd9e686113fdb82146ec30d Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 25 May 2012 18:29:42 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 0952573f..b5324374 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -346,10 +346,10 @@ CREATE TABLE core_notify ( id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ); - -ALTER TABLE core_notify ADD COLUMN recur_id INT(11) NOT NULL; -ALTER TABLE core_notify ADD COLUMN act_when DATETIME ; -ALTER TABLE core_notify ADD COLUMN act_start DATETIME ; +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 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; ALTER TABLE core_notify ADD COLUMN ontable varchar(128) NOT NULL DEFAULT ''; ALTER TABLE core_notify ADD COLUMN person_id int(11) NOT NULL DEFAULT 0; -- 2.39.2