From 92e564e07a4589927b2d3ab0ec5a4ce7a96c751b Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Thu, 29 Dec 2016 12:13:36 -0500
Subject: [PATCH] Adding mailing address fields

Adding new fields to the member info table.
---
 index.php                                     |  2 +-
 ...1.1.22.sql => create_database_V1.1.23.sql} |  9 +++++--
 setup/databaseScripts/dbVersions.php          |  3 ++-
 ..._V1.1.22.sql => drop_database_V1.1.23.sql} |  4 +--
 .../update_database_V1.1.23.sql               | 26 +++++++++++++++++++
 5 files changed, 38 insertions(+), 6 deletions(-)
 rename setup/databaseScripts/{create_database_V1.1.22.sql => create_database_V1.1.23.sql} (97%)
 rename setup/databaseScripts/{drop_database_V1.1.22.sql => drop_database_V1.1.23.sql} (90%)
 create mode 100644 setup/databaseScripts/update_database_V1.1.23.sql

diff --git a/index.php b/index.php
index 6da8eb44..3c845e7d 100644
--- a/index.php
+++ b/index.php
@@ -39,7 +39,7 @@
  */
 
 define('GLM_MEMBERS_PLUGIN_VERSION', '2.8.4');
-define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.22');
+define('GLM_MEMBERS_PLUGIN_DB_VERSION', '1.1.23');
 
 // 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.22.sql b/setup/databaseScripts/create_database_V1.1.23.sql
similarity index 97%
rename from setup/databaseScripts/create_database_V1.1.22.sql
rename to setup/databaseScripts/create_database_V1.1.23.sql
index 62a437ec..146297ae 100644
--- a/setup/databaseScripts/create_database_V1.1.22.sql
+++ b/setup/databaseScripts/create_database_V1.1.23.sql
@@ -1,6 +1,6 @@
 -- Gaslight Media Members Database
--- File Created: 12/09/14 15:27:15
--- Database Version: 1.1.20
+-- File Created: 12/29/16 12:06:00
+-- Database Version: 1.1.23
 -- Database Creation Script
 --
 -- To permit each query below to be executed separately,
@@ -217,6 +217,11 @@ CREATE TABLE {prefix}member_info (
   live_cam_title TINYTEXT NULL,             -- Live Cam Title
   live_cam_descr TEXT NULL,                 -- Live Cam Description
   live_cam_type INT NULL,                   -- Live Cam Type - See plugin.ini video type table.
+  mailing_addr1 TINYTEXT NULL,              -- Mailing Address 1
+  mailing_addr2 TINYTEXT NULL,              -- Mailing Address 2
+  mailing_city INT NULL,                    -- Mailing City  (Pointer to City in cities table)
+  mailing_state TINYTEXT NULL,              -- Mailing State (Two character state code - matches states.ini entries)
+  mailing_zip TINYTEXT NULL,                -- Mailing ZIP/Postal code
   notes TEXT NULL,                          -- General notes - Not displayed in front-end
   create_time TIMESTAMP NULL,               -- Create date/time
   modify_time TIMESTAMP NULL,               -- Last update date/time
diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php
index 6a88ebe2..b2e73a9f 100644
--- a/setup/databaseScripts/dbVersions.php
+++ b/setup/databaseScripts/dbVersions.php
@@ -53,7 +53,8 @@ $glmMembersDbVersions = array(
     '1.1.19' => array('version' => '1.1.19', 'tables' => 18, 'date' => '9/20/16'),
     '1.1.20' => array('version' => '1.1.20', 'tables' => 18, 'date' => '10/18/16'),
     '1.1.21' => array('version' => '1.1.21', 'tables' => 18, 'date' => '10/20/16'),
-    '1.1.22' => array('version' => '1.1.22', 'tables' => 18, 'date' => '10/25/16')
+    '1.1.22' => array('version' => '1.1.22', 'tables' => 18, 'date' => '10/25/16'),
+    '1.1.23' => array('version' => '1.1.23', 'tables' => 18, 'date' => '12/29/16')
 );
 
 
diff --git a/setup/databaseScripts/drop_database_V1.1.22.sql b/setup/databaseScripts/drop_database_V1.1.23.sql
similarity index 90%
rename from setup/databaseScripts/drop_database_V1.1.22.sql
rename to setup/databaseScripts/drop_database_V1.1.23.sql
index 935890b5..5c742da1 100644
--- a/setup/databaseScripts/drop_database_V1.1.22.sql
+++ b/setup/databaseScripts/drop_database_V1.1.23.sql
@@ -1,6 +1,6 @@
--- Gaslight Media Members Database 
+-- Gaslight Media Members Database
 -- File Created: 12/09/14 15:27:15
--- Database Version: 1.1.16
+-- Database Version: 1.1.23
 -- Database Deletion Script
 -- Note: Tables with DELETE CASCADE must appear before referenced table
 
diff --git a/setup/databaseScripts/update_database_V1.1.23.sql b/setup/databaseScripts/update_database_V1.1.23.sql
new file mode 100644
index 00000000..5c899ee9
--- /dev/null
+++ b/setup/databaseScripts/update_database_V1.1.23.sql
@@ -0,0 +1,26 @@
+-- Gaslight Media Members Database
+-- File Created: 12/29/16 12:06:00
+-- Database Version: 1.1.23
+-- 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
+-- Sets which character to use to separate phone numbers
+
+ALTER TABLE {prefix}member_info ADD COLUMN mailing_addr1 TINYTEXT NULL;
+
+----
+
+ALTER TABLE {prefix}member_info ADD COLUMN mailing_addr2 TINYTEXT NULL;
+
+----
+
+ALTER TABLE {prefix}member_info ADD COLUMN mailing_city INT NULL;
+
+----
+
+ALTER TABLE {prefix}member_info ADD COLUMN mailing_state TINYTEXT NULL;
+
+----
+
+ALTER TABLE {prefix}member_info ADD COLUMN mailing_zip TINYTEXT NULL;
-- 
2.17.1