DataObjects/core.sql

[Pman.Core] / DataObjects / core.sql

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 8089f3c..19ae96b 100644 (file)
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -107,8 +107,11 @@ CREATE TABLE  Group_Rights  (
 );
 ALTER TABLE Group_Rights ADD COLUMN    rightname varchar(64)  NOT NULL DEFAULT '';
 ALTER TABLE Group_Rights ADD COLUMN     group_id int(11) NOT NULL DEFAULT 0;
-ALTER TABLE Group_Rights ADD COLUMN   AccessMask varchar(10)  NOT NULL DEFAULT '';
-  
+ALTER TABLE Group_Rights ADD COLUMN   accessmask varchar(10)  NOT NULL DEFAULT '';
+
+#old mysql.
+ALTER TABLE Group_Rights CHANGE COLUMN AccessMask accessmask varchar(10)  NOT NULL DEFAULT '';
+
 
 
 
@@ -148,13 +151,13 @@ CREATE TABLE Person (
   PRIMARY KEY  (id)
 ) ;
 
-ALTER TABLE Person ADD COLUMN  office_id int(11) default '0';
+ALTER TABLE Person ADD COLUMN   office_id int(11) default '0';
 ALTER TABLE Person ADD COLUMN   name varchar(128)  NOT NULL  DEFAULT '';
 ALTER TABLE Person ADD COLUMN   phone varchar(32)  NOT NULL  DEFAULT '';
 ALTER TABLE Person ADD COLUMN   fax varchar(32)  NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   email varchar(128)  NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   company_id int(11) default '0';
-ALTER TABLE Person ADD COLUMN   role varchar(32)  NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN   role varchar(254)  NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   active int(11) NOT NULL  default 1;
 ALTER TABLE Person ADD COLUMN   remarks text;
 ALTER TABLE Person ADD COLUMN   passwd varchar(64) NOT NULL  DEFAULT '';
@@ -162,13 +165,14 @@ 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 ;
+alter table Person change role role varchar(254) NOT NULL DEFAULT '';
 
 
 
@@ -269,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 '';
@@ -291,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);
+ 
 
 
 
@@ -324,7 +329,7 @@ alter table  core_watch ADD COLUMN    ontable varchar(128) NOT NULL DEFAULT '';
 alter table  core_watch ADD COLUMN   onid int(11) NOT NULL DEFAULT 0;
 alter table  core_watch ADD COLUMN   person_id int(11) NOT NULL DEFAULT 0;
 alter table  core_watch ADD COLUMN   event varchar(128) NOT NULL DEFAULT '';
-alter table  core_watch ADD COLUMN   medium varchar(128) NOT NULL DEFAULT '';
+alter table  core_watch ADD COLUMN   medium varchar(64) NOT NULL DEFAULT '';
 alter table  core_watch ADD COLUMN  active int(11) NOT NULL DEFAULT '1';
 
 ALTER TABLE core_watch ADD INDEX qlookup (ontable,onid,person_id,event,medium);
@@ -343,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;