From: Alan Knowles Date: Wed, 16 May 2012 09:57:27 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=3077fb4d7ac9666aced176bdbe4b6011e3debd4e DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 78b9c952..0ee47331 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -404,7 +404,8 @@ 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); - + +-- old design.. ALTER TABLE core_notify_recur CHANGE COLUMN tz tz varchar(64) NOT NULL;