X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=0ee4733130143d4d6994d2c44d70041b17f3538a;hp=78b9c95289e1695961aad5d0b2110ec0bdaa0ad0;hb=3077fb4d7ac9666aced176bdbe4b6011e3debd4e;hpb=476d9aeb57cf343b5a0c0f71deaea19247025171 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;