PHP7 fix

[Pman.Core] / sql / core_person_signup.sql

diff --git a/sql/core_person_signup.sql b/sql/core_person_signup.sql
index 68ce13e..e5fd1e4 100644 (file)
--- a/sql/core_person_signup.sql
+++ b/sql/core_person_signup.sql
@@ -20,12 +20,15 @@ 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  default '';
-ALTER TABLE core_person_signup ADD COLUMN   person_type TEXT NOT NULL  default '';
+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  default '';
+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 ENGINE=InnoDB;
\ No newline at end of file
+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