From 476d9aeb57cf343b5a0c0f71deaea19247025171 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 16 May 2012 17:57:18 +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 c28b8a40..78b9c952 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -83,7 +83,7 @@ ALTER TABLE Events ADD INDEX lookup (on_id, on_table, person_id, event_when); ALTER TABLE Events ADD INDEX lookupf (on_id, action, on_table, person_id, event_when); - +ALTER TABLE Events ADD INDEX lookuppt ( person_table); CREATE TABLE core_event_audit ( @@ -393,11 +393,11 @@ CREATE TABLE core_notify_recur ( ALTER TABLE core_notify_recur ADD COLUMN person_id int(11) NOT NULL; ALTER TABLE core_notify_recur ADD COLUMN dtstart datetime NOT NULL; ALTER TABLE core_notify_recur ADD COLUMN dtend datetime NOT NULL; -ALTER TABLE core_notify_recur ADD COLUMN tz decimal(4,2) NOT NULL;, + 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 COLUMN tz varchar(64) NOT NULL; ALTER TABLE core_notify_recur ADD COLUMN freq varchar(8) NOT NULL; ALTER TABLE core_notify_recur ADD COLUMN freq_day text NOT NULL; @@ -405,6 +405,6 @@ 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); - +ALTER TABLE core_notify_recur CHANGE COLUMN tz tz varchar(64) NOT NULL; -- 2.39.2