From c9c62b8b55adc79eac34ad5ef37d577124be4b65 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Wed, 16 Dec 2015 18:43:08 +0530 Subject: [PATCH] --CRM-16259, added upgrade code to set is_payment flag --- CRM/Upgrade/Incremental/sql/4.7.beta4.mysql.tpl | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta4.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta4.mysql.tpl index 2ef2e9e4c3..04b977cd4a 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.beta4.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.beta4.mysql.tpl @@ -1 +1,8 @@ {* file to handle db changes in 4.7.beta4 during upgrade *} + +-- Add flag for existing payments + +UPDATE civicrm_financial_trxn ft INNER JOIN + (SELECT financial_account_id FROM civicrm_entity_financial_account efa INNER JOIN civicrm_option_value v ON efa.account_relationship = v.value AND v.name = 'Asset Account is' + INNER JOIN civicrm_option_group g ON v.option_group_id = g.id WHERE g.name = 'account_relationship' GROUP BY financial_account_id) + AS asset_fa ON ft.to_financial_account_id = asset_fa.financial_account_id SET ft.is_payment = TRUE; -- 2.25.1