From e0b02ac05de31dda6a1ee6a237cb39165f1ae51d Mon Sep 17 00:00:00 2001
From: Monish Deb <monish.deb@jmaconsulting.biz>
Date: Thu, 7 Apr 2022 18:12:17 -0700
Subject: [PATCH] Schema - Fix boolean fields in 'Pledge'

---
 CRM/Pledge/DAO/PledgeBlock.php                            | 5 +++--
 CRM/Upgrade/Incremental/php/FiveFortyNine/Pledge.bool.php | 6 ++++++
 xml/schema/Pledge/PledgeBlock.xml                         | 1 +
 3 files changed, 10 insertions(+), 2 deletions(-)
 create mode 100644 CRM/Upgrade/Incremental/php/FiveFortyNine/Pledge.bool.php

diff --git a/CRM/Pledge/DAO/PledgeBlock.php b/CRM/Pledge/DAO/PledgeBlock.php
index 020203b280..72d227201b 100644
--- a/CRM/Pledge/DAO/PledgeBlock.php
+++ b/CRM/Pledge/DAO/PledgeBlock.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/Pledge/PledgeBlock.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:a3bd49cda507ac9872922e16ff37a645)
+ * (GenCodeChecksum:5c573642b549c72e343477a782ed62dc)
  */
 
 /**
@@ -70,7 +70,7 @@ class CRM_Pledge_DAO_PledgeBlock extends CRM_Core_DAO {
   /**
    * Is frequency interval exposed on the contribution form.
    *
-   * @var bool|string|null
+   * @var bool|string
    *   (SQL type: tinyint)
    *   Note that values will be retrieved from the database as a string.
    */
@@ -235,6 +235,7 @@ class CRM_Pledge_DAO_PledgeBlock extends CRM_Core_DAO {
           'type' => CRM_Utils_Type::T_BOOLEAN,
           'title' => ts('Expose Frequency Interval?'),
           'description' => ts('Is frequency interval exposed on the contribution form.'),
+          'required' => TRUE,
           'where' => 'civicrm_pledge_block.is_pledge_interval',
           'default' => '0',
           'table_name' => 'civicrm_pledge_block',
diff --git a/CRM/Upgrade/Incremental/php/FiveFortyNine/Pledge.bool.php b/CRM/Upgrade/Incremental/php/FiveFortyNine/Pledge.bool.php
new file mode 100644
index 0000000000..563bea9a4b
--- /dev/null
+++ b/CRM/Upgrade/Incremental/php/FiveFortyNine/Pledge.bool.php
@@ -0,0 +1,6 @@
+<?php
+return [
+  'civicrm_pledge_block' => [
+    'is_pledge_interval' => "DEFAULT 0 COMMENT 'Is frequency interval exposed on the contribution form.'",
+  ],
+];
diff --git a/xml/schema/Pledge/PledgeBlock.xml b/xml/schema/Pledge/PledgeBlock.xml
index bee126c423..bd368741b3 100644
--- a/xml/schema/Pledge/PledgeBlock.xml
+++ b/xml/schema/Pledge/PledgeBlock.xml
@@ -62,6 +62,7 @@
     <title>Expose Frequency Interval?</title>
     <type>boolean</type>
     <default>0</default>
+    <required>true</required>
     <comment>Is frequency interval exposed on the contribution form.</comment>
     <add>2.1</add>
   </field>
-- 
2.25.1