From fb89c3411d7f4f6d464b78e0b7b1598b268c45b4 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Wed, 15 Jun 2016 15:25:54 +0530 Subject: [PATCH] CRM-16189, added revenue_recognition_date field for on install and upgrade ---------------------------------------- * CRM-16189: Improve support for Accrual Method bookkeeping https://issues.civicrm.org/jira/browse/CRM-16189 Conflicts: CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl --- CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl | 3 +++ xml/schema/Contribute/Contribution.xml | 12 ++++++++++++ 2 files changed, 15 insertions(+) diff --git a/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl index 292f732f72..3d6645f9c6 100644 --- a/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl +++ b/CRM/Upgrade/Incremental/sql/4.7.9.mysql.tpl @@ -19,3 +19,6 @@ WHERE name = 'getting-started'; ALTER TABLE civicrm_financial_account ADD `opening_balance` decimal(20,2) DEFAULT '0.00' COMMENT 'Contains the opening balance for this financial account', ADD `current_period_opening_balance` decimal(20,2) DEFAULT '0.00' COMMENT 'Contains the opening balance for the current period for this financial account'; + +ALTER TABLE civicrm_contribution +ADD `revenue_recognition_date` datetime DEFAULT NULL COMMENT 'Stores the date when revenue should be recognized.'; diff --git a/xml/schema/Contribute/Contribution.xml b/xml/schema/Contribute/Contribution.xml index 0b325e274d..c30d2f10e3 100644 --- a/xml/schema/Contribute/Contribution.xml +++ b/xml/schema/Contribute/Contribution.xml @@ -499,4 +499,16 @@ id SET NULL + + revenue_recognition_date + datetime + true + /revenue(.?date)?/i + /^\d{4}-?\d{2}-?\d{2} ?(\d{2}:?\d{2}:?(\d{2})?)?$/ + Stores the date when revenue should be recognized. + + Select Date + + 4.7 + -- 2.25.1