sql/Person.sql

[Pman.Core] / sql / Person.sql

diff --git a/sql/Person.sql b/sql/Person.sql
index 650ac47..8805ee2 100644 (file)
--- a/sql/Person.sql
+++ b/sql/Person.sql
@@ -33,9 +33,16 @@ ALTER TABLE Person ADD COLUMN   fax varchar(32)  NOT NULL DEFAULT '';
 ALTER TABLE Person ADD COLUMN   alt_email VARCHAR(256) NULL ;
 
 
--- links to other tables.
-ALTER TABLE Person ADD COLUMN   office_id int(11) default '0';
-ALTER TABLE Person ADD COLUMN   company_id int(11) default '0';
+-- links to other tables. ??? in postgress these might need to be allow null... but we need them as NOT NULL ?
+-- otherwise empty values will not apply to database.. (mysql)
+
+ALTER TABLE Person ADD COLUMN   office_id int(11) NOT NULL  default '0';
+ALTER TABLE Person ADD COLUMN   company_id int(11) NOT NULL  default '0';
+ALTER TABLE Person CHANGE COLUMN   office_id office_id int(11) NOT NULL  default '0';
+ALTER TABLE Person CHANGE COLUMN   company_id company_id int(11) NOT NULL  default '0';
+
+
+
 ALTER TABLE Person ADD COLUMN   owner_id int(11) NOT NULL DEFAULT 0;
 ALTER TABLE Person ADD COLUMN   active int(11) NOT NULL  default 1;
 ALTER TABLE Person ADD COLUMN   project_id int(11) default 0;
@@ -80,9 +87,15 @@ alter table Person change column active active int(11) NOT NULL DEFAULT 1 ;
 alter table Person change role role varchar(254) NOT NULL DEFAULT '';
 alter table Person change email email varchar(254) NOT NULL DEFAULT '';
 
-ALTER TABLE Person ADD COLUMN authorize_md5 TEXT NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN authorize_md5 varchar(254)  NOT NULL DEFAULT '';
+
+ALTER TABLE Person ADD INDEX lookup_authorize_md5_active(authorize_md5, active);
 
 ALTER TABLE Person ADD INDEX lookup_a(email, active);
 ALTER TABLE Person ADD INDEX lookup_b(email, active, company_id);
 ALTER TABLE Person add index lookup_owner(owner_id);
  
+ 
+--  finally - always innodb
+  
+ALTER TABLE Person ADD COLUMN post_code VARCHAR(256) NOT NULL DEFAULT '';
\ No newline at end of file