From 50d4243130064ba7a9fd1388340b04e5683ff9eb Mon Sep 17 00:00:00 2001
From: Tim Otten <totten@civicrm.org>
Date: Wed, 4 Dec 2013 16:11:12 -0800
Subject: [PATCH] CRM-13913 - civicrm_word_replacement.is_active - Default to 1

----------------------------------------
* CRM-13913: WordReplacements created via API should default to enabled
  http://issues.civicrm.org/jira/browse/CRM-13913
---
 CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl | 6 +++++-
 xml/schema/Core/WordReplacement.xml              | 1 +
 2 files changed, 6 insertions(+), 1 deletion(-)

diff --git a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
index 15f8c61a7b..35594d4076 100644
--- a/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.5.alpha1.mysql.tpl
@@ -57,4 +57,8 @@ ALTER TABLE `civicrm_mapping_field`
 -- CRM-13857
 ALTER TABLE civicrm_group
   ADD COLUMN `modified_id` INT(10) unsigned DEFAULT NULL COMMENT 'FK to contact table, modifier of the group.',
-  ADD CONSTRAINT `FK_civicrm_group_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL;
\ No newline at end of file
+  ADD CONSTRAINT `FK_civicrm_group_modified_id` FOREIGN KEY (`modified_id`) REFERENCES `civicrm_contact`(`id`) ON DELETE SET NULL;
+
+-- CRM-13913
+ALTER TABLE civicrm_word_replacement
+  ALTER COLUMN `is_active` SET DEFAULT 1;
diff --git a/xml/schema/Core/WordReplacement.xml b/xml/schema/Core/WordReplacement.xml
index 296814fd80..06ce67a4bf 100644
--- a/xml/schema/Core/WordReplacement.xml
+++ b/xml/schema/Core/WordReplacement.xml
@@ -37,6 +37,7 @@
     <name>is_active</name>
     <title>Word Replacement is Active</title>
     <type>boolean</type>
+    <default>1</default>
     <comment>Is this entry active?</comment>
     <add>4.4</add>
   </field>
-- 
2.25.1