From aac73719504d56abe027599966c6e9e888d19adb Mon Sep 17 00:00:00 2001
From: Chuck Scott <cscott@gaslightmedia.com>
Date: Mon, 8 Oct 2018 12:30:35 -0400
Subject: [PATCH] Added database field for making registration classes
 sortable.

Planning on moving "Registration Levels & Charges" page away from Backbone.
Code for making the page sortable will be in a branch for development.
---
 index.php                                           |  2 +-
 readme.txt                                          |  3 +++
 ...tabase_V1.0.1.sql => create_database_V1.0.2.sql} |  4 ++--
 setup/databaseScripts/dbVersions.php                |  3 ++-
 ...database_V1.0.1.sql => drop_database_V1.0.2.sql} |  0
 setup/databaseScripts/update_database_V1.0.2.sql    | 13 +++++++++++++
 6 files changed, 21 insertions(+), 4 deletions(-)
 rename setup/databaseScripts/{create_database_V1.0.1.sql => create_database_V1.0.2.sql} (99%)
 rename setup/databaseScripts/{drop_database_V1.0.1.sql => drop_database_V1.0.2.sql} (100%)
 create mode 100755 setup/databaseScripts/update_database_V1.0.2.sql

diff --git a/index.php b/index.php
index 62b8d81..39edc03 100755
--- a/index.php
+++ b/index.php
@@ -42,7 +42,7 @@ if (!defined('ABSPATH')) {
  *  version from this plugin.
  */
 define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_VERSION', '1.1.0');
-define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_DB_VERSION', '1.0.1');
+define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_DB_VERSION', '1.0.2');
 
 // This is the minimum version of the GLM Members DB plugin require for this plugin.
 define('GLM_MEMBERS_REGISTRATIONS_PLUGIN_MIN_MEMBERS_REQUIRED_VERSION', '2.10.27');
diff --git a/readme.txt b/readme.txt
index 2fcc0df..6a9c52a 100755
--- a/readme.txt
+++ b/readme.txt
@@ -25,6 +25,9 @@ e.g.
 1. Activate the plugin through the 'Plugins' menu in WordPress
 
 == Changelog ==
+= PENDING =
+* Added sort order for registration classes (levels)
+
 = 1.1.0 =
 * Formal release for a range of front-end and admin improvement and fixes
 * Added more functionality to admin requests and accounts dashboards.
diff --git a/setup/databaseScripts/create_database_V1.0.1.sql b/setup/databaseScripts/create_database_V1.0.2.sql
similarity index 99%
rename from setup/databaseScripts/create_database_V1.0.1.sql
rename to setup/databaseScripts/create_database_V1.0.2.sql
index c988a4b..420ff1b 100755
--- a/setup/databaseScripts/create_database_V1.0.1.sql
+++ b/setup/databaseScripts/create_database_V1.0.2.sql
@@ -222,7 +222,6 @@ CREATE TABLE {prefix}payment_code (
     code TINYTEXT NULL,                                         -- Text code user must enter to use
     amount FLOAT,                                               -- Amount of discount if not type "Free" - Either $ amount or percent
     expire_date DATE NULL,                                      -- Expiration Date
-
     descr TEXT NULL,
     PRIMARY KEY (id),
     INDEX (ref_dest),
@@ -325,6 +324,7 @@ CREATE TABLE {prefix}reg_class (
     reg_event INT NULL,                                         -- Pointer to reg_event table
     name TINYTEXT NULL,                                         -- Name of this registration type
     descr TEXT NULL,                                            -- Description
+    sort_order INT DEFAULT 999,                                 -- Sort order for display in Front-End
     PRIMARY KEY (id),
     INDEX (reg_event)
 );
@@ -477,7 +477,7 @@ CREATE TABLE {prefix}reg_request (
     bill_state TINYTEXT NULL,
     bill_zip TINYTEXT NULL,
     bill_country TINYTEXT NULL,
-    bill_phone TINYTEXT NULL,
+    bill_phone TINYTEXT NULL,_class
     bill_email TINYTEXT NULL,
     date_submitted DATE NULL,                                   -- Date of final submission (checkout complete)
     pay_method INT NULL,                                        -- See payment_method in plugin.ini
diff --git a/setup/databaseScripts/dbVersions.php b/setup/databaseScripts/dbVersions.php
index 29311ad..f0706e0 100755
--- a/setup/databaseScripts/dbVersions.php
+++ b/setup/databaseScripts/dbVersions.php
@@ -47,7 +47,8 @@ $glmMembersRegistrationsDbVersions = array(
     '0.0.31' => array('version' => '0.0.31', 'tables' => 18, 'date' => '05/15/2018'),
     '0.0.32' => array('version' => '0.0.32', 'tables' => 18, 'date' => '05/22/2018'),
     '1.0.0' => array('version' => '1.0.0', 'tables' => 18, 'date' => '06/04/2018'),
-    '1.0.1' => array('version' => '1.0.1', 'tables' => 18, 'date' => '06/12/2018')
+    '1.0.1' => array('version' => '1.0.1', 'tables' => 18, 'date' => '06/12/2018'),
+    '1.0.2' => array('version' => '1.0.2', 'tables' => 18, 'date' => '10/08/2018')
 );
 
 
diff --git a/setup/databaseScripts/drop_database_V1.0.1.sql b/setup/databaseScripts/drop_database_V1.0.2.sql
similarity index 100%
rename from setup/databaseScripts/drop_database_V1.0.1.sql
rename to setup/databaseScripts/drop_database_V1.0.2.sql
diff --git a/setup/databaseScripts/update_database_V1.0.2.sql b/setup/databaseScripts/update_database_V1.0.2.sql
new file mode 100755
index 0000000..0975ef3
--- /dev/null
+++ b/setup/databaseScripts/update_database_V1.0.2.sql
@@ -0,0 +1,13 @@
+-- Gaslight Media Members Database  - Registratiuons Add-On
+-- File Updated: 2018-10-08
+-- Database Version: 1.0.2
+-- 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
+
+ALTER TABLE {prefix}reg_class ADD COLUMN sort_order INTEGER DEFAULT 999;
+
+----
+
+UPDATE {prefix}reg_class SET sort_order = 999;
-- 
2.17.1