From 01469eb3e28c726d941f03eaf6dce3f823b43fe0 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Wed, 22 Nov 2017 12:01:15 -0500
Subject: [PATCH] Update field data type for payment_types.qcode

make it tinytext and not required.
---
 setup/databaseScripts/create_database_V0.0.1.sql | 2 +-
 views/admin/settings/paymentTypes.html           | 8 ++++----
 2 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/setup/databaseScripts/create_database_V0.0.1.sql b/setup/databaseScripts/create_database_V0.0.1.sql
index 09ae3a9..c73a34d 100644
--- a/setup/databaseScripts/create_database_V0.0.1.sql
+++ b/setup/databaseScripts/create_database_V0.0.1.sql
@@ -36,7 +36,7 @@ CREATE TABLE {prefix}transactions (
 CREATE TABLE {prefix}payment_types (
     id INT NOT NULL AUTO_INCREMENT,
     name TINYTEXT NOT NULL,
-    qcode INT NULL,
+    qcode TINYTEXT NULL,
     category TEXT NOT NULL,
     amount DECIMAL(8, 2),
     notes TINYTEXT NULL,
diff --git a/views/admin/settings/paymentTypes.html b/views/admin/settings/paymentTypes.html
index a7a8e82..6644db2 100644
--- a/views/admin/settings/paymentTypes.html
+++ b/views/admin/settings/paymentTypes.html
@@ -14,9 +14,9 @@
                     </td>
                 </tr>
                 <tr>
-                    <th class="glm-required">Code:</th>
+                    <th>Code:</th>
                     <td>
-                        <input type="text" name="qcode" class="glm-form-text-input" required>
+                        <input type="text" name="qcode" class="glm-form-text-input">
                     </td>
                 </tr>
                 <tr>
@@ -74,9 +74,9 @@
                     </td>
                 </tr>
                 <tr>
-                    <th class="glm-required">Code:</th>
+                    <th>Code:</th>
                     <td>
-                        <input id="editPaymentTypeQCode" type="text" name="qcode" class="glm-form-text-input" required>
+                        <input id="editPaymentTypeQCode" type="text" name="qcode" class="glm-form-text-input">
                     </td>
                 </tr>
                 <tr>
-- 
2.17.1