From 4b7e60e4b00639f2a4032acf51e0e81ac57f8388 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Fri, 5 Dec 2014 15:38:15 +0800 Subject: [PATCH] DataObjects/Core_person_signup.php --- DataObjects/Core_person_signup.php | 52 ++++++++++++++++++++++++++++++ 1 file changed, 52 insertions(+) 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; +