From e4300f0ab4d5d0268c02cb959d3cf5fbb2695ee5 Mon Sep 17 00:00:00 2001 From: Laury GvR Date: Fri, 19 Aug 2016 17:06:30 -0400 Subject: [PATCH] Fixed database update script version number --- index.php | 2 +- ...abase_V1.1.14.sql => create_database_V1.1.15.sql} | 0 setup/databaseScripts/dbVersions.php | 1 + ...atabase_V1.1.14.sql => drop_database_V1.1.15.sql} | 0 setup/databaseScripts/update_database_V1.1.14.sql | 10 +--------- setup/databaseScripts/update_database_V1.1.15.sql | 12 ++++++++++++ 6 files changed, 15 insertions(+), 10 deletions(-) rename setup/databaseScripts/{create_database_V1.1.14.sql => create_database_V1.1.15.sql} (100%) rename setup/databaseScripts/{drop_database_V1.1.14.sql => drop_database_V1.1.15.sql} (100%) create mode 100644 setup/databaseScripts/update_database_V1.1.15.sql diff --git a/index.php b/index.php index 88d4b768..4c750bcc 100644 --- a/index.php +++ b/index.php @@ -39,7 +39,7 @@ */ define('GLM_MEMBERS_PLUGIN_VERSION', '2.5.0'); -define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.14'); +define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.15'); // 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.14.sql b/setup/databaseScripts/create_database_V1.1.15.sql similarity index 100% rename from setup/databaseScripts/create_database_V1.1.14.sql rename to setup/databaseScripts/create_database_V1.1.15.sql diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php index dd543438..cd656df1 100644 --- a/setup/databaseScripts/dbVersions.php +++ b/setup/databaseScripts/dbVersions.php @@ -46,6 +46,7 @@ $glmMembersDbVersions = array( '1.1.12' => array('version' => '1.1.12', 'tables' => 16, 'date' => '8/2/16'), '1.1.13' => array('version' => '1.1.13', 'tables' => 18, 'date' => '8/4/16'), '1.1.14' => array('version' => '1.1.14', 'tables' => 18, 'date' => '8/15/16'), + '1.1.15' => array('version' => '1.1.14', 'tables' => 18, 'date' => '8/19/16') ); diff --git a/setup/databaseScripts/drop_database_V1.1.14.sql b/setup/databaseScripts/drop_database_V1.1.15.sql similarity index 100% rename from setup/databaseScripts/drop_database_V1.1.14.sql rename to setup/databaseScripts/drop_database_V1.1.15.sql diff --git a/setup/databaseScripts/update_database_V1.1.14.sql b/setup/databaseScripts/update_database_V1.1.14.sql index 53617dda..c81ff30e 100644 --- a/setup/databaseScripts/update_database_V1.1.14.sql +++ b/setup/databaseScripts/update_database_V1.1.14.sql @@ -7,12 +7,4 @@ -- all queries must be separated by a line with four dashses -- To set whether a member is featured -ALTER TABLE {prefix}members ADD COLUMN featured BOOLEAN DEFAULT false; - --- - -ALTER TABLE {prefix}settings_general ADD COLUMN list_show_logo_filler BOOLEAN DEFAULT true; - ----- - -ALTER TABLE {prefix}settings_general ADD COLUMN list_header_text TINYTEXT DEFAULT NULL; \ No newline at end of file +ALTER TABLE {prefix}members ADD COLUMN featured BOOLEAN DEFAULT false; \ No newline at end of file diff --git a/setup/databaseScripts/update_database_V1.1.15.sql b/setup/databaseScripts/update_database_V1.1.15.sql new file mode 100644 index 00000000..4650e117 --- /dev/null +++ b/setup/databaseScripts/update_database_V1.1.15.sql @@ -0,0 +1,12 @@ +-- Gaslight Media Members Database +-- File Created: 8/15/16 14:59:42 +-- Database Version: 1.1.15 +-- 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 dashses +ALTER TABLE {prefix}settings_general ADD COLUMN list_show_logo_filler BOOLEAN DEFAULT true; + +---- + +ALTER TABLE {prefix}settings_general ADD COLUMN list_header_text TINYTEXT DEFAULT NULL; \ No newline at end of file -- 2.17.1