From d9883c8267f5953418278b5bfcf127e1a814fa8c Mon Sep 17 00:00:00 2001 From: Jon goldberg Date: Thu, 14 Jan 2016 00:09:21 -0500 Subject: [PATCH] Upgrade script for CRM-17552 --- CRM/Upgrade/Incremental/sql/4.7.beta8.mysql.tpl | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 CRM/Upgrade/Incremental/sql/4.7.beta8.mysql.tpl diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta8.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta8.mysql.tpl new file mode 100644 index 0000000000..2a9397cc1a --- /dev/null +++ b/CRM/Upgrade/Incremental/sql/4.7.beta8.mysql.tpl @@ -0,0 +1,4 @@ +{* file to handle db changes in 4.7.beta8 during upgrade *} + +-- CRM-17552 +UPDATE civicrm_membership_block cmb JOIN civicrm_price_set_entity cpse ON cmb.entity_table = cpse.entity_table AND cmb.entity_id = cpse.entity_id JOIN civicrm_price_set cps ON cpse.price_set_id = cps.id SET cmb.is_required = 1 WHERE cmb.entity_table = 'civicrm_contribution_page' AND cps.is_quick_config = 0; -- 2.25.1