--- /dev/null
+
+CREATE TABLE Person (
+ id int(11) NOT NULL auto_increment,
+ PRIMARY KEY (id)
+) ;
+
+
+ALTER TABLE Person ADD COLUMN name varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN honor varchar(32) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN firstname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN lastname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN firstname_alt varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN lastname_alt varchar(128) NOT NULL DEFAULT '';
+
+-- chose title is like a nickname
+
+ALTER TABLE Person ADD COLUMN chosen_title TEXT NOT NULL;
+
+
+ALTER TABLE Person ADD COLUMN role varchar(254) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN remarks text NOT NULL;
+ALTER TABLE Person ADD COLUMN lang varchar(8) default 'en';
+ALTER TABLE Person ADD COLUMN country varchar(8) default '';
+
+SET SQL_MODE='ALLOW_INVALID_DATES';
+ALTER TABLE Person ADD COLUMN birth_date DATE NOT NULL DEFAULT '0000-00-00';
+
+-- main contact details
+ALTER TABLE Person ADD COLUMN email varchar(256) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN phone varchar(32) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN phone_mobile varchar(32) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN phone_direct varchar(32) NOT NULL DEFAULT '';
+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. ??? 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;
+
+ALTER TABLE Person ADD COLUMN passwd varchar(64) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN no_reset_sent 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 ;
+
+
+-- social
+ALTER TABLE Person ADD COLUMN name_facebook VARCHAR(128) NULL;
+ALTER TABLE Person ADD COLUMN url_blog VARCHAR(256) NULL ;
+ALTER TABLE Person ADD COLUMN url_twitter VARCHAR(256) NULL ;
+ALTER TABLE Person ADD COLUMN linkedin_id VARCHAR(256) NULL ;
+ALTER TABLE Person ADD COLUMN url_linkedin VARCHAR(256) NULL ;
+ALTER TABLE Person ADD COLUMN url_google_plus TEXT NOT NULL;
+ALTER TABLE Person ADD COLUMN url_blog2 TEXT NOT NULL;
+ALTER TABLE Person ADD COLUMN url_blog3 TEXT NOT NULL;
+
+
+
+-- these are specific to modules - should have been put in there really..
+-- CRM ? is store the person interest countries...
+ALTER TABLE Person ADD COLUMN countries VARCHAR(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN action_type VARCHAR(32) DEFAULT '';
+
+-- this is store the person location
+
+-- ?? WTF - this is specific to another project?
+ALTER TABLE Person ADD COLUMN point_score INT(11) NOT NULL DEFAULT 0;
+
+-- indexes
+
+
+
+-- 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 '';
+alter table Person change email email varchar(254) NOT NULL DEFAULT '';
+
+ALTER TABLE Person ADD COLUMN authorize_md5 varchar(254) NOT NULL DEFAULT '';
+ALTER TABLE Person CHANGE COLUMN authorize_md5 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