From 4dbadd8138b87199c472b17474c37c416772da26 Mon Sep 17 00:00:00 2001
From: Eileen McNaughton <emcnaughton@wikimedia.org>
Date: Tue, 28 Sep 2021 17:08:41 +1300
Subject: [PATCH] Set default for civicrm_message_template.is_reserved

---
 CRM/Core/DAO/MessageTemplate.php                  | 3 ++-
 CRM/Upgrade/Incremental/sql/5.43.alpha1.mysql.tpl | 3 +++
 xml/schema/Core/MessageTemplate.xml               | 1 +
 3 files changed, 6 insertions(+), 1 deletion(-)

diff --git a/CRM/Core/DAO/MessageTemplate.php b/CRM/Core/DAO/MessageTemplate.php
index a84d7eed54..fbd7b9ef85 100644
--- a/CRM/Core/DAO/MessageTemplate.php
+++ b/CRM/Core/DAO/MessageTemplate.php
@@ -6,7 +6,7 @@
  *
  * Generated from xml/schema/CRM/Core/MessageTemplate.xml
  * DO NOT EDIT.  Generated by CRM_Core_CodeGen
- * (GenCodeChecksum:10bf11ca59e77fe7be9dfd775e5d5cd0)
+ * (GenCodeChecksum:b06f348c67999ef36677f60e6c62650a)
  */
 
 /**
@@ -265,6 +265,7 @@ class CRM_Core_DAO_MessageTemplate extends CRM_Core_DAO {
           'title' => ts('Message Template Is Reserved?'),
           'description' => ts('is this the reserved message template which we ship for the workflow referenced by workflow_id?'),
           'where' => 'civicrm_msg_template.is_reserved',
+          'default' => '0',
           'table_name' => 'civicrm_msg_template',
           'entity' => 'MessageTemplate',
           'bao' => 'CRM_Core_BAO_MessageTemplate',
diff --git a/CRM/Upgrade/Incremental/sql/5.43.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/5.43.alpha1.mysql.tpl
index 41720c9039..0447e9d2b7 100644
--- a/CRM/Upgrade/Incremental/sql/5.43.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/5.43.alpha1.mysql.tpl
@@ -1 +1,4 @@
 {* file to handle db changes in 5.43.alpha1 during upgrade *}
+UPDATE civicrm_msg_template SET is_reserved = 0 WHERE is_reserved IS NULL;
+ALTER TABLE civicrm_msg_template
+MODIFY COLUMN `is_reserved` tinyint(4) DEFAULT 0 COMMENT 'is this the reserved message template which we ship for the workflow referenced by workflow_id?';
diff --git a/xml/schema/Core/MessageTemplate.xml b/xml/schema/Core/MessageTemplate.xml
index 16ee1f7c7e..c912a6abb0 100644
--- a/xml/schema/Core/MessageTemplate.xml
+++ b/xml/schema/Core/MessageTemplate.xml
@@ -96,6 +96,7 @@
     <name>is_reserved</name>
     <title>Message Template Is Reserved?</title>
     <type>boolean</type>
+    <default>0</default>
     <comment>is this the reserved message template which we ship for the workflow referenced by workflow_id?</comment>
     <add>3.1</add>
   </field>
-- 
2.25.1