From dfe37c2eed5073aa03c37b9345b39bdde1c8235f Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 28 Mar 2018 15:06:57 -0400 Subject: [PATCH] Update the create db script. Getting errors when install on new site. Fixing bugs. Needed fields weren't added to the create script only the update script. --- setup/databaseScripts/create_database_V0.0.25.sql | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/setup/databaseScripts/create_database_V0.0.25.sql b/setup/databaseScripts/create_database_V0.0.25.sql index 5e078c5..d0ab8f8 100644 --- a/setup/databaseScripts/create_database_V0.0.25.sql +++ b/setup/databaseScripts/create_database_V0.0.25.sql @@ -131,6 +131,10 @@ CREATE TABLE {prefix}settings_terms ( reg_term_registered_user_cap TINYTEXT NULL, reg_term_registered_user_plur TINYTEXT NULL, reg_term_registered_user_plur_cap TINYTEXT NULL, + reg_term_event TINYTEXT NULL, + reg_term_event_cap TINYTEXT NULL, + reg_term_event_plur TINYTEXT NULL, + reg_term_event_plur_cap TINYTEXT NULL, reg_term_id TINYTEXT NULL, reg_term_id_cap TINYTEXT NULL, reg_term_id_plur TINYTEXT NULL, @@ -455,7 +459,7 @@ CREATE TABLE {prefix}reg_request ( total_discounts DOUBLE PRECISION NULL, -- Total of all comps and discounts registrants SMALLINT NULL, -- Total number of registrants in this cart cc_type TINYINT NULL, -- Credit Card type (if used) - See credit_card in plugin.ini - cc_name TINYTEXT NULL, -- Name on Credit Card or Name on Check + cc_name TINYTEXT NULL, -- Name on Credit Card or Name on Check cc_numb TINYTEXT NULL, -- Credit Card Number or Check Number cc_exp TINYTEXT NULL, cc_cvv TINYTEXT NULL, @@ -712,6 +716,10 @@ INSERT INTO {prefix}settings_terms 'User', -- reg_term_registered_user_cap 'users', -- reg_term_registered_user_plur 'Users', -- reg_term_registered_user_plur_cap + 'event', -- reg_term_event + 'Event', -- reg_term_event_cap + 'events', -- reg_term_event_plur + 'Events', -- reg_term_event_plur_cap 'ID', -- reg_term_id 'ID', -- reg_term_id_cap 'IDs', -- reg_term_id_plur -- 2.17.1