From 4ae5098552f851e4af5fa19f447add703e072a97 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 3 Apr 2012 17:29:23 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 21 ++++++--------------- 1 file changed, 6 insertions(+), 15 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index b78c3ba7..f6828104 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -396,25 +396,16 @@ ALTER TABLE core_notify_recur ADD COLUMN max_applied_dt datetime NOT NULL; ALTER TABLE core_notify_recur ADD COLUMN updated_dt datetime NOT NULL; ALTER TABLE core_notify_recur ADD COLUMN last_applied_dt datetime NOT NULL; -ALTER TABLE core_notify_recur ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt); - - -CREATE TABLE core_notify_recur_repeat ( - id int(11) NOT NULL AUTO_INCREMENT, - PRIMARY KEY (id) -) ; -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 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); - - +ALTER TABLE core_notify_recur ADD COLUMN freq varchar(8) NOT NULL; +ALTER TABLE core_notify_recur ADD COLUMN freq_day text NOT NULL; +ALTER TABLE core_notify_recur ADD COLUMN freq_hour text NOT NULL; +ALTER TABLE core_notify_recur ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt); + + -- 2.39.2