CRM-19427 - set deductible amount at price field option level

[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 4.7.13.mysql.tpl

diff --git a/CRM/Upgrade/Incremental/sql/4.7.13.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.7.13.mysql.tpl
index 83157e91950c2e4c4f3a06ceb4a0c4be350bacf6..7e2bb5b6ab9acdbf06a15e62d67d9b748fc9bc5a 100644 (file)
--- a/CRM/Upgrade/Incremental/sql/4.7.13.mysql.tpl
+++ b/CRM/Upgrade/Incremental/sql/4.7.13.mysql.tpl
@@ -1 +1,6 @@
 {* file to handle db changes in 4.7.13 during upgrade *}
+
+-- CRM-19427
+ALTER TABLE  `civicrm_price_field_value` CHANGE  `deductible_amount`  `non_deductible_amount` DECIMAL( 20, 2 ) NOT NULL DEFAULT  '0.00' COMMENT 'Portion of total amount which is NOT tax deductible.';
+
+ALTER TABLE  `civicrm_line_item` CHANGE  `deductible_amount`  `non_deductible_amount` DECIMAL( 20, 2 ) NOT NULL DEFAULT  '0.00' COMMENT 'Portion of total amount which is NOT tax deductible.';