Commit | Line | Data |
---|---|---|
4a08cb39 | 1 | {* file to handle db changes in 4.7.beta4 during upgrade *} |
c9c62b8b PN |
2 | |
3 | -- Add flag for existing payments | |
4 | ||
5 | UPDATE civicrm_financial_trxn ft INNER JOIN | |
6 | (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' | |
7 | INNER JOIN civicrm_option_group g ON v.option_group_id = g.id WHERE g.name = 'account_relationship' GROUP BY financial_account_id) | |
8 | AS asset_fa ON ft.to_financial_account_id = asset_fa.financial_account_id SET ft.is_payment = TRUE; |