DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 8c5b4dc..19ae96b 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -165,10 +165,10 @@ ALTER TABLE Person ADD COLUMN   owner_id int(11) NOT NULL DEFAULT 0;
 ALTER TABLE Person ADD COLUMN   lang varchar(8) default 'en';
 ALTER TABLE Person ADD COLUMN   no_reset_sent int(11) default '0';
 
-ALTER TABLE Person ADD COLUMN action_type VARCHAR(32) DEFAULT '';
-ALTER TABLE Person ADD COLUMN project_id int(11) default 0;
-ALTER TABLE Person ADD COLUMN deleted_by INT(11) NOT NULL default 0 ;
-ALTER TABLE Person ADD COLUMN deleted_dt DATETIME ;
+ALTER TABLE Person ADD COLUMN   action_type VARCHAR(32) DEFAULT '';
+ALTER TABLE Person ADD COLUMN   project_id int(11) default 0;
+ALTER TABLE Person ADD COLUMN   deleted_by INT(11) NOT NULL default 0 ;
+ALTER TABLE Person ADD COLUMN   deleted_dt DATETIME ;
 
 # old mysql
 alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;
@@ -273,7 +273,7 @@ ALTER TABLE i18n ADD INDEX lookup (ltype, lkey, inlang);
         
     
 CREATE TABLE  core_locking (
-  int int(11)  NOT NULL AUTO_INCREMENT,
+  id int(11)  NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (int)
 );
 ALTER TABLE  core_locking ADD COLUMN   on_table varchar(64)  NOT NULL DEFAULT '';
@@ -295,9 +295,10 @@ alter table  core_enum ADD COLUMN etype varchar(32)  NOT NULL DEFAULT '';
 alter table  core_enum ADD COLUMN  name varchar(255)  NOT NULL DEFAULT '';
 alter table  core_enum ADD COLUMN   active int(2)  NOT NULL DEFAULT 1;
 alter table  core_enum ADD COLUMN  seqid int(11)  NOT NULL DEFAULT 0;
+alter table  core_enum ADD COLUMN  seqmax int(11)  NOT NULL DEFAULT 0;
 
- alter table  core_enum ADD  INDEX lookup(seqid, active, name, etype);
-
+alter table  core_enum ADD  INDEX lookup(seqid, active, name, etype);
+ 
 
 
 
@@ -347,12 +348,16 @@ ALTER TABLE core_notify ADD COLUMN  onid int(11)  NOT NULL DEFAULT 0;
 ALTER TABLE core_notify ADD COLUMN  ontable varchar(128)  NOT NULL DEFAULT '';
 ALTER TABLE core_notify ADD COLUMN  person_id int(11)  NOT NULL DEFAULT 0;
 ALTER TABLE core_notify ADD COLUMN  msgid varchar(128)  NOT NULL  DEFAULT '';
+
 ALTER TABLE core_notify ADD COLUMN  sent DATETIME ;
 ALTER TABLE core_notify ADD COLUMN  event_id int(11)  NOT NULL DEFAULT 0;
 ALTER TABLE core_notify ADD COLUMN  watch_id INT(11) NOT NULL DEFAULT 0;
 ALTER TABLE core_notify ADD COLUMN  trigger_person_id INT(11) NOT NULL DEFAULT 0;
 ALTER TABLE core_notify ADD COLUMN  trigger_event_id INT(11) NOT NULL DEFAULT 0;
 ALTER TABLE core_notify ADD   INDEX lookup(act_when, msgid);
+ALTER TABLE core_notify ADD COLUMN  to_email varchar(255)  NOT NULL  DEFAULT '';
+ALTER TABLE core_notify ADD   INDEX lookup_a(onid, ontable, person_id, act_when, msgid, to_email);
+
 #old mysql..
 ALTER TABLE core_notify CHANGE COLUMN bounced event_id INT(11) NOT NULL DEFAULT 0;