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

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 009f0b2d..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 ;
  
 
@@ -79,6 +81,7 @@ ALTER TABLE Events CHANGE COLUMN Container on_table VARCHAR(64);
 
 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);
 
 
 
@@ -274,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;
@@ -282,7 +285,8 @@ ALTER TABLE  core_locking ADD COLUMN  person_id int(11)  NOT NULL DEFAULT 0;
 ALTER TABLE  core_locking ADD COLUMN  created datetime ;
 
 alter table  core_locking ADD  INDEX lookup(on_table, on_id, person_id, created);
-alter table core_locking change column `int` id int(11) auto_increment not null;
+# -- oops... - wrong name of pid.
+alter table  core_locking change column `int` id int(11) auto_increment not null;
 
 # -- a generic enumeraction
 
@@ -376,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);
+ 
+
+ 
+