From 3987f9b4af8e58da6e17c9c39152ded5179894c1 Mon Sep 17 00:00:00 2001
From: Dave Greenberg <dave@civicrm.org>
Date: Wed, 2 Dec 2015 15:53:16 -0800
Subject: [PATCH] CRM-16259 - Schema change for financial_trxn table only - add
 is_payment column.

----------------------------------------
* CRM-16259: Create Payment API
  https://issues.civicrm.org/jira/browse/CRM-16259
---
 CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl | 3 +++
 xml/schema/Financial/FinancialTrxn.xml          | 9 +++++++++
 2 files changed, 12 insertions(+)

diff --git a/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl
index fe2771c346..7aaae09768 100644
--- a/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.7.beta1.mysql.tpl
@@ -37,3 +37,6 @@ INSERT INTO civicrm_participant_status_type(name, {localize field='label'}label{
 VALUES ('Transferred', {localize}'{ts escape="sql"}Transferred{/ts}'{/localize}, 'Negative', 1, 1, 0, 16, 2);
 
 {include file='../CRM/Upgrade/4.7.beta1.msg_template/civicrm_msg_template.tpl'}
+
+-- CRM-16259 Added is_payment flag
+ALTER TABLE civicrm_financial_trxn ADD COLUMN is_payment tinyint(4) DEFAULT '0' COMMENT 'Is this entry either a payment or a reversal of a payment?';
diff --git a/xml/schema/Financial/FinancialTrxn.xml b/xml/schema/Financial/FinancialTrxn.xml
index 03fbf024d7..a681beec67 100755
--- a/xml/schema/Financial/FinancialTrxn.xml
+++ b/xml/schema/Financial/FinancialTrxn.xml
@@ -147,6 +147,15 @@
       <type>Select</type>
     </html>
   </field>
+  <field>
+    <name>is_payment</name>
+    <title>Is Payment?</title>
+    <type>boolean</type>
+    <default>0</default>
+    <import>true</import>
+    <comment>Is this entry either a payment or a reversal of a payment?</comment>
+    <add>4.7</add>
+  </field>
   <field>
     <name>payment_processor</name>
     <type>varchar</type>
-- 
2.25.1