X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_person_signup.sql;h=e5fd1e41f305ce7dd135a69c009541258210aa5e;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=e69de29bb2d1d6434b8b29ae775ad8c2e48c5391;hpb=3c730ee33acc7595064ac09c1a65f26fbf02a54d;p=Pman.Core

diff --git a/sql/core_person_signup.sql b/sql/core_person_signup.sql
index e69de29b..e5fd1e41 100644
--- a/sql/core_person_signup.sql
+++ b/sql/core_person_signup.sql
@@ -0,0 +1,34 @@
+
+
+-- used to store signups - before they have been verified.
+-- once the verified link has been pressed, use a add event, copy to a person, and remove record..
+
+CREATE TABLE core_person_signup (
+  id int(11) NOT NULL auto_increment,
+  PRIMARY KEY  (id)
+) ;
+
+
+ALTER TABLE core_person_signup ADD COLUMN   name varchar(128)  NOT NULL  DEFAULT '';
+ALTER TABLE core_person_signup ADD COLUMN   honor varchar(32) NOT NULL DEFAULT '';
+ALTER TABLE core_person_signup ADD COLUMN   firstname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE core_person_signup ADD COLUMN   lastname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE core_person_signup ADD COLUMN   firstname_alt varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE core_person_signup ADD COLUMN   lastname_alt varchar(128) NOT NULL DEFAULT '';
+
+ALTER TABLE core_person_signup ADD COLUMN   email varchar(256)  NOT NULL DEFAULT '';
+ALTER TABLE core_person_signup ADD COLUMN   verify_key varchar(256)  NOT NULL DEFAULT '';
+ALTER TABLE core_person_signup ADD COLUMN   created_dt DATETIME  NOT NULL;
+
+ALTER TABLE core_person_signup ADD COLUMN   company_name TEXT NOT NULL;
+ALTER TABLE core_person_signup ADD COLUMN   person_type TEXT NOT NULL;
+
+ALTER TABLE core_person_signup ADD COLUMN   person_id int(11) NOT NULL  default 0;
+ALTER TABLE core_person_signup ADD COLUMN   person_table TEXT NOT NULL;
+
+ALTER TABLE core_person_signup ADD COLUMN   inviter_id int(11) NOT NULL  default 0;
+
+ALTER TABLE core_person_signup ADD COLUMN   crm_mailing_list_id int(11) NOT NULL  default 0;
+
+ALTER TABLE core_person_signup ADD COLUMN   phone varchar(256)  NOT NULL DEFAULT '';
+ 
\ No newline at end of file