From: Alan Knowles Date: Fri, 5 Dec 2014 07:38:15 +0000 (+0800) Subject: DataObjects/Core_person_signup.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=4b7e60e4b00639f2a4032acf51e0e81ac57f8388 DataObjects/Core_person_signup.php --- diff --git a/DataObjects/Core_person_signup.php b/DataObjects/Core_person_signup.php index e69de29b..588838e9 100644 --- a/DataObjects/Core_person_signup.php +++ b/DataObjects/Core_person_signup.php @@ -0,0 +1,52 @@ +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; +