From 2bc5849c34c730826d8bc9f81ede82617d8bb8e1 Mon Sep 17 00:00:00 2001
From: Steve Sutton <steve@gaslightmedia.com>
Date: Wed, 15 Aug 2018 16:05:35 -0400
Subject: [PATCH] Changes for current database

Bring in these by hand.
---
 setup/databaseScripts/create_database_V1.1.37.sql            | 3 ++-
 .../{drop_database_V1.1.36.sql => drop_database_V1.1.37.sql} | 3 ++-
 setup/databaseScripts/steve-v1.1.37                          | 0
 setup/databaseScripts/update_database_V1.1.37.sql            | 5 +++++
 4 files changed, 9 insertions(+), 2 deletions(-)
 rename setup/databaseScripts/{drop_database_V1.1.36.sql => drop_database_V1.1.37.sql} (92%)
 delete mode 100644 setup/databaseScripts/steve-v1.1.37

diff --git a/setup/databaseScripts/create_database_V1.1.37.sql b/setup/databaseScripts/create_database_V1.1.37.sql
index 6d51ff15..9c248db0 100644
--- a/setup/databaseScripts/create_database_V1.1.37.sql
+++ b/setup/databaseScripts/create_database_V1.1.37.sql
@@ -325,6 +325,7 @@ CREATE TABLE {prefix}settings_general (
   enable_multiple_profiles BOOLEAN DEFAULT '0',
   enable_member_reports BOOLEAN DEFAULT '1',
   enable_caching BOOLEAN DEFAULT '1',
+  enable_contact_edit_only BOOLEAN DEFAULT '0',
   memb_info_location BOOLEAN DEFAULT '1',
   memb_info_contact BOOLEAN DEFAULT '1',
   memb_info_categories BOOLEAN DEFAULT '1',
@@ -666,7 +667,7 @@ INSERT INTO {prefix}settings_theme
 ----
 
 -- Member Email Notifications
-CREATE TABLE {perfix}email_notifications (
+CREATE TABLE {prefix}email_notifications (
     id INT NOT NULL AUTO_INCREMENT,
     notification_message TEXT NULL,
     declined_message TEXT NULL,
diff --git a/setup/databaseScripts/drop_database_V1.1.36.sql b/setup/databaseScripts/drop_database_V1.1.37.sql
similarity index 92%
rename from setup/databaseScripts/drop_database_V1.1.36.sql
rename to setup/databaseScripts/drop_database_V1.1.37.sql
index e190e070..5059089b 100644
--- a/setup/databaseScripts/drop_database_V1.1.36.sql
+++ b/setup/databaseScripts/drop_database_V1.1.37.sql
@@ -26,6 +26,7 @@ DROP TABLE IF EXISTS
     {prefix}grouped_amenities,
     {prefix}cache,
     {prefix}file_library_categories,
-    {prefix}file_library
+    {prefix}file_library,
+    {prefix}email_notifications
 ;
 
diff --git a/setup/databaseScripts/steve-v1.1.37 b/setup/databaseScripts/steve-v1.1.37
deleted file mode 100644
index e69de29b..00000000
diff --git a/setup/databaseScripts/update_database_V1.1.37.sql b/setup/databaseScripts/update_database_V1.1.37.sql
index 6343958b..8a8df779 100644
--- a/setup/databaseScripts/update_database_V1.1.37.sql
+++ b/setup/databaseScripts/update_database_V1.1.37.sql
@@ -24,3 +24,8 @@ INSERT INTO {prefix}email_notifications
     ( id, notification_message, declined_message, approved_message )
 VALUES
     ( 1, 'A member has requested a profile update.', 'Your profile update has been declined.', 'Your profile has been approved!' );
+
+----
+
+-- Update Settings General
+ALTER TABLE {prefix}settings_general ADD enable_contact_edit_only BOOLEAN DEFAULT '0';
-- 
2.17.1