From b5ec2cf47459636f792381190925ca55e88a9361 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 3 Apr 2012 17:22:10 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index cccd5869..20b74fc3 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -389,15 +389,15 @@ CREATE TABLE core_notify_recur ( ALTER TABLE core_notify_recur ADD COLUMN -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 INDEX `lookup`(`person_id`, `dtstart`, `dtend`, `tz`, `max_applied_dt`, `updated_dt`, `last_applied_dt`); +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 INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt); -- 2.39.2