From a86e437d0e331e3e833b6974ded515722ded8cd0 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 23 May 2012 09:04:27 +0800 Subject: [PATCH] notify recur changes --- DataObjects/Core_notify_recur.php | 15 +++++++++++++-- DataObjects/core.sql | 7 ++++++- 2 files changed, 19 insertions(+), 3 deletions(-) diff --git a/DataObjects/Core_notify_recur.php b/DataObjects/Core_notify_recur.php index 77ff4e16..3b42fcca 100644 --- a/DataObjects/Core_notify_recur.php +++ b/DataObjects/Core_notify_recur.php @@ -12,15 +12,26 @@ class Pman_Core_DataObjects_Core_notify_recur extends DB_DataObject public $__table = 'core_notify_recur'; // table name public $id; // int(11) not_null primary_key auto_increment public $person_id; // int(11) not_null + public $dtstart; // datetime(19) not_null binary public $dtend; // datetime(19) not_null binary public $tz; // real(6) not_null + public $updated_dt; // datetime(19) not_null binary + public $last_applied_dt; // datetime(19) not_null binary - +// public $max_applied_dtl public $freq; // varchar(8) NOT NULL; public $freq_day; // text NOT NULL; - public $freq_hour; // text + public $freq_hour; // text + + public $onid; // int(11) not_null + public $ontable; // string(128) not_null + public $last_event_id; // int(11) + public $method; // string(128) not_null + + + ###END_AUTOCODE diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 0ee47331..66632536 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -393,7 +393,6 @@ 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 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; @@ -403,6 +402,12 @@ 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 COLUMN onid int(11) not_null default 0; +ALTER TABLE core_notify_recur ADD COLUMN ontable varchar(128) not_null default ''; +ALTER TABLE core_notify_recur ADD COLUMN last_event_id int(11) default 0; +ALTER TABLE core_notify_recur ADD COLUMN method varchar(128) default ''; + + ALTER TABLE core_notify_recur ADD INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt); -- old design.. -- 2.39.2