From c0c9c8bfa01e5c84c1c4f6bc5ab49d659f12326b Mon Sep 17 00:00:00 2001
From: eileen <emcnaughton@wikimedia.org>
Date: Sat, 12 May 2018 09:59:26 +1200
Subject: [PATCH] Add DB default of 0 for custom_group.is_multiple - CRM-21853

---
 CRM/Upgrade/Incremental/sql/5.3.alpha1.mysql.tpl | 3 +++
 xml/schema/Core/CustomGroup.xml                  | 2 ++
 2 files changed, 5 insertions(+)

diff --git a/CRM/Upgrade/Incremental/sql/5.3.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.3.alpha1.mysql.tpl
index 8a3d52ecc1..7f5b095e95 100644
--- a/CRM/Upgrade/Incremental/sql/5.3.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/5.3.alpha1.mysql.tpl
@@ -1 +1,4 @@
 {* file to handle db changes in 5.3.alpha1 during upgrade *}
+ALTER TABLE civicrm_custom_group ALTER column is_multiple SET DEFAULT 0;
+UPDATE civicrm_custom_group SET is_multiple = 0 WHERE is_multiple IS NULL;
+ALTER TABLE civicrm_custom_group ALTER column is_active SET DEFAULT 1;
diff --git a/xml/schema/Core/CustomGroup.xml b/xml/schema/Core/CustomGroup.xml
index 49df6dc5c4..719b4a481c 100644
--- a/xml/schema/Core/CustomGroup.xml
+++ b/xml/schema/Core/CustomGroup.xml
@@ -140,6 +140,7 @@
     <type>boolean</type>
     <title>Custom Group Is Active?</title>
     <comment>Is this property active?</comment>
+    <default>1</default>
     <add>1.1</add>
   </field>
   <field>
@@ -154,6 +155,7 @@
     <type>boolean</type>
     <title>Supports Multiple Records</title>
     <comment>Does this group hold multiple values?</comment>
+    <default>0</default>
     <add>2.0</add>
   </field>
   <field>
-- 
2.25.1