From 703ccb6228f9d77203b4279ee15b046c944ec512 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 3 Apr 2012 17:23:45 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 24 ++---------------------- 1 file changed, 2 insertions(+), 22 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 1f6abdbd..6a806454 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -410,30 +410,10 @@ ALTER TABLE core_notify_recur_repeat ADD COLUMN ALTER TABLE core_notify_recur_repeat ADD COLUMN recur_id int(11) NOT NULL; ALTER TABLE core_notify_recur_repeat ADD COLUMN freq varchar(8) NOT NULL; -ALTER TABLE core_notify_recur_repeat ADD COLUMN dtend datetime NOT NULL; -ALTER TABLE core_notify_recur_repeat ADD COLUMN tz decimal(4,2) NOT NULL;, -ALTER TABLE core_notify_recur_repeat ADD COLUMN max_applied_dt datetime NOT NULL; -ALTER TABLE core_notify_recur_repeat ADD COLUMN updated_dt datetime NOT NULL; -ALTER TABLE core_notify_recur_repeat ADD COLUMN last_applied_dt datetime NOT NULL; +ALTER TABLE core_notify_recur_repeat ADD COLUMN freq_day text NOT NULL; +ALTER TABLE core_notify_recur_repeat ADD COLUMN freq_hour text NOT NULL;, ALTER TABLE core_notify_recur_repeat ADD INDEX lookup(recur_id); - - Repeat table - * core_notify_recur_repeat - * id - * recur_id << parent.. - * freq = DAILY | YEARLY | MONTHLY - * - * THESE ARE EXCLUSIVE.. - * freq_day = 1,2,3,4,5" - day number.. or dayofmonth USES TIME FROM DTSTART (unless hours are speced.) - * >> must.. - * freq_hourly = 'what hours' << OR IF EMPTY USES TIME FROM DTSTART - * - * - * Actualy time.. - * - * - * -- 2.39.2