From: Alan Knowles <alan@roojs.com>
Date: Wed, 23 May 2012 01:04:27 +0000 (+0800)
Subject:  notify recur changes
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=a86e437d0e331e3e833b6974ded515722ded8cd0

 notify recur changes
---

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..