From aff4144bf4223125a705689b3210fba71c2f8b9e Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 2 Jan 2019 14:21:27 -0500 Subject: [PATCH] DB updates Adding new fields for the management/setting of the new member signup form. --- index.php | 2 +- ...1.1.44.sql => create_database_V1.1.45.sql} | 8 ++++- setup/databaseScripts/dbVersions.php | 1 + ..._V1.1.42.sql => drop_database_V1.1.45.sql} | 2 +- .../update_database_V1.1.45.sql | 35 +++++++++++++++++++ 5 files changed, 45 insertions(+), 3 deletions(-) rename setup/databaseScripts/{create_database_V1.1.44.sql => create_database_V1.1.45.sql} (98%) rename setup/databaseScripts/{drop_database_V1.1.42.sql => drop_database_V1.1.45.sql} (96%) create mode 100755 setup/databaseScripts/update_database_V1.1.45.sql diff --git a/index.php b/index.php index 8ecd0c33..8b5ee666 100755 --- a/index.php +++ b/index.php @@ -48,7 +48,7 @@ if (!defined('ABSPATH')) { */ define('GLM_MEMBERS_PLUGIN_VERSION', '2.10.46'); -define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.44'); +define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.45'); // Check if plugin version is not current in WordPress option and if needed updated it if (GLM_MEMBERS_PLUGIN_VERSION != get_option('glmMembersDatabasePluginVersion')) { diff --git a/setup/databaseScripts/create_database_V1.1.44.sql b/setup/databaseScripts/create_database_V1.1.45.sql similarity index 98% rename from setup/databaseScripts/create_database_V1.1.44.sql rename to setup/databaseScripts/create_database_V1.1.45.sql index 91d769c6..5983163e 100755 --- a/setup/databaseScripts/create_database_V1.1.44.sql +++ b/setup/databaseScripts/create_database_V1.1.45.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database -- File Created: 12/29/16 12:06:00 --- Database Version: 1.1.41 +-- Database Version: 1.1.45 -- Database Creation Script -- -- To permit each query below to be executed separately, @@ -462,6 +462,12 @@ CREATE TABLE {prefix}settings_general ( recaptcha_secret_key TINYTEXT DEFAULT '', -- reCAPTCHA secret key recaptcha_header_code TEXT DEFAULT '', -- reCAPTCHA code for page header recaptcha_form_code TEXT DEFAULT '', -- reCAPTCHA code for captcha form field + new_member_intro TEXT NULL, -- New Member intro + new_member_thankyou TEXT NULL, -- New Member thank you + new_member_type_default INTEGER DEFAULT '0', -- New Member member type default + new_member_notice_to TINYTEXT NULL, -- New Member notice To: + new_member_notice_from TINYTEXT NULL, -- weather + new_member_notice_message TEXT NULL, -- New Member notice Message PRIMARY KEY (id) ); diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php index e88c1d5f..9e8f79be 100755 --- a/setup/databaseScripts/dbVersions.php +++ b/setup/databaseScripts/dbVersions.php @@ -76,6 +76,7 @@ $glmMembersDbVersions = array( '1.1.42' => array('version' => '1.1.42', 'tables' => 23, 'date' => '10/29/18'), '1.1.43' => array('version' => '1.1.43', 'tables' => 23, 'date' => '11/07/18'), '1.1.44' => array('version' => '1.1.44', 'tables' => 23, 'date' => '11/08/18'), + '1.1.45' => array('version' => '1.1.45', 'tables' => 23, 'date' => '01/02/19'), ); diff --git a/setup/databaseScripts/drop_database_V1.1.42.sql b/setup/databaseScripts/drop_database_V1.1.45.sql similarity index 96% rename from setup/databaseScripts/drop_database_V1.1.42.sql rename to setup/databaseScripts/drop_database_V1.1.45.sql index 82992d76..479bd5ac 100755 --- a/setup/databaseScripts/drop_database_V1.1.42.sql +++ b/setup/databaseScripts/drop_database_V1.1.45.sql @@ -1,6 +1,6 @@ -- Gaslight Media Members Database -- File Created: 12/09/14 15:27:15 --- Database Version: 1.1.38 +-- Database Version: 1.1.45 -- Database Deletion Script -- Note: Tables with DELETE CASCADE must appear before referenced table diff --git a/setup/databaseScripts/update_database_V1.1.45.sql b/setup/databaseScripts/update_database_V1.1.45.sql new file mode 100755 index 00000000..1bb6fb2e --- /dev/null +++ b/setup/databaseScripts/update_database_V1.1.45.sql @@ -0,0 +1,35 @@ +-- Gaslight Media Members Database +-- File Created: 2019-01-02 +-- Database Version: 1.1.45 +-- Database Update From Previous Version Script +-- +-- To permit each query below to be executed separately, +-- all queries must be separated by a line with four dashes + +-- Add new_member_intro to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN new_member_intro TEXT NULL; -- New Member intro + +---- + +-- Add new_member_thankyou to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN new_member_thankyou TEXT NULL; -- New Member thank you + +---- + +-- Add new_member_type_default to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN new_member_type_default INTEGER DEFAULT '0'; -- New Member member type default + +---- + +-- Add new_member_notice_to to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN new_member_notice_to TINYTEXT NULL; -- New Member notice To: + +---- + +-- Add new_member_notice_from to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN new_member_notice_from TINYTEXT NULL; -- New Member notice From: + +---- + +-- Add new_member_notice_message to settings_general table +ALTER TABLE {prefix}settings_general ADD COLUMN new_member_notice_message TEXT NULL; -- New Member notice Message -- 2.17.1