From 93a9a09dda6da07d3dfeb1757e0e81cf5d37bb39 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Sat, 7 Feb 2015 06:35:26 -0800 Subject: [PATCH] CRM-15931 - civicrm_mailing_group.group_type - Cleanup inconsistent data --- CRM/Upgrade/Incremental/sql/4.6.alpha6.mysql.tpl | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/sql/4.6.alpha6.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.6.alpha6.mysql.tpl index 792a930857..dee21cb640 100644 --- a/CRM/Upgrade/Incremental/sql/4.6.alpha6.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.6.alpha6.mysql.tpl @@ -1,3 +1,8 @@ {* file to handle db changes in 4.6.alpha6 during upgrade *} -UPDATE `civicrm_navigation` SET url = 'civicrm/api' WHERE url = 'civicrm/api/explorer'; \ No newline at end of file +UPDATE `civicrm_navigation` SET url = 'civicrm/api' WHERE url = 'civicrm/api/explorer'; + +-- CRM-15931 +UPDATE civicrm_mailing_group SET group_type = 'Include' WHERE group_type = 'include'; +UPDATE civicrm_mailing_group SET group_type = 'Exclude' WHERE group_type = 'exclude'; +UPDATE civicrm_mailing_group SET group_type = 'Base' WHERE group_type = 'base'; -- 2.25.1