X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2Fcore.sql;h=c28b8a400a42a6c68d70f8b76d65a9e8b134ee8a;hp=9914bfbd9f808029276d19728cbbe9dd315d62ab;hb=ae10c7e63d065afe746018bc3e1f9ef175ae4cb9;hpb=817074368e91d2c7a42a5cf8aed7fe368d54dda9

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 9914bfbd..c28b8a40 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -61,6 +61,8 @@ ALTER TABLE Events ADD COLUMN   ipaddr varchar(16)  default NULL;
 ALTER TABLE Events ADD COLUMN   on_id int(11) default NULL;
 ALTER TABLE Events ADD COLUMN   on_table varchar(64)  default NULL;
 ALTER TABLE Events ADD COLUMN   person_id int(11) default NULL;
+ALTER TABLE Events ADD COLUMN   person_table varchar(64) default NULL;
+
 ALTER TABLE Events ADD COLUMN   remarks text ;
  
 
@@ -275,7 +277,7 @@ ALTER TABLE i18n ADD INDEX lookup (ltype, lkey, inlang);
     
 CREATE TABLE  core_locking (
   id int(11)  NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (int)
+  PRIMARY KEY (id)
 );
 ALTER TABLE  core_locking ADD COLUMN   on_table varchar(64)  NOT NULL DEFAULT '';
 ALTER TABLE  core_locking ADD COLUMN    on_id int(11)  NOT NULL DEFAULT 0;
@@ -378,3 +380,31 @@ ALTER TABLE core_person_alias ADD COLUMN   person_id varchar(128) DEFAULT NULL;
 ALTER TABLE core_person_alias ADD COLUMN  alias varchar(254) NOT NULL DEFAULT '';
   
 ALTER TABLE core_person_alias ADD INDEX alias (alias);
+
+
+
+CREATE TABLE core_notify_recur (
+  id int(11)  NOT NULL AUTO_INCREMENT,
+
+  PRIMARY KEY (id)
+) ;
+ 
+
+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 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 INDEX lookup(person_id, dtstart, dtend, tz, max_applied_dt, updated_dt, last_applied_dt);
+ 
+
+ 
+