3 -- used to store signups - before they have been verified.
4 -- once the verified link has been pressed, use a add event, copy to a person, and remove record..
6 CREATE TABLE core_person_signup (
7 id int(11) NOT NULL auto_increment,
12 ALTER TABLE core_person_signup ADD COLUMN name varchar(128) NOT NULL DEFAULT '';
13 ALTER TABLE core_person_signup ADD COLUMN honor varchar(32) NOT NULL DEFAULT '';
14 ALTER TABLE core_person_signup ADD COLUMN firstname varchar(128) NOT NULL DEFAULT '';
15 ALTER TABLE core_person_signup ADD COLUMN lastname varchar(128) NOT NULL DEFAULT '';
16 ALTER TABLE core_person_signup ADD COLUMN firstname_alt varchar(128) NOT NULL DEFAULT '';
17 ALTER TABLE core_person_signup ADD COLUMN lastname_alt varchar(128) NOT NULL DEFAULT '';
19 ALTER TABLE core_person_signup ADD COLUMN email varchar(256) NOT NULL DEFAULT '';
20 ALTER TABLE core_person_signup ADD COLUMN verify_key varchar(256) NOT NULL DEFAULT '';
21 ALTER TABLE core_person_signup ADD COLUMN created_dt DATETIME NOT NULL;
23 ALTER TABLE core_person_signup ADD COLUMN company_name TEXT NOT NULL;
24 ALTER TABLE core_person_signup ADD COLUMN person_type TEXT NOT NULL;
26 ALTER TABLE core_person_signup ADD COLUMN person_id int(11) NOT NULL default 0;
27 ALTER TABLE core_person_signup ADD COLUMN person_table TEXT NOT NULL;
29 ALTER TABLE core_person_signup ADD COLUMN inviter_id int(11) NOT NULL default 0;
31 ALTER TABLE core_person_signup ADD COLUMN crm_mailing_list_id int(11) NOT NULL default 0;
33 ALTER TABLE core_person_signup ADD COLUMN phone varchar(256) NOT NULL DEFAULT '';