From d544ffeea7de14525449ca4f7a1a060648930c9e Mon Sep 17 00:00:00 2001
From: Pradeep Nayak <pradeep@pradeep.(none)>
Date: Sat, 4 May 2013 23:49:40 +0530
Subject: [PATCH] --worked on CRA-12501, changed length/values for tax_rate
 from 9,8 to 10,8

----------------------------------------
* CRM-12501: Financial Account Tax > 10 causes error
  http://issues.civicrm.org/jira/browse/CRM-12501
---
 CRM/Upgrade/Incremental/sql/4.3.3.mysql.tpl | 2 ++
 xml/schema/Financial/FinancialAccount.xml   | 2 +-
 2 files changed, 3 insertions(+), 1 deletion(-)
 create mode 100644 CRM/Upgrade/Incremental/sql/4.3.3.mysql.tpl

diff --git a/CRM/Upgrade/Incremental/sql/4.3.3.mysql.tpl b/CRM/Upgrade/Incremental/sql/4.3.3.mysql.tpl
new file mode 100644
index 0000000000..0b75a6dd19
--- /dev/null
+++ b/CRM/Upgrade/Incremental/sql/4.3.3.mysql.tpl
@@ -0,0 +1,2 @@
+-- CRM-12501 
+ALTER TABLE civicrm_financial_account CHANGE `tax_rate` `tax_rate` DECIMAL( 10, 8 ) NULL DEFAULT NULL COMMENT 'The percentage of the total_amount that is due for this tax.';
diff --git a/xml/schema/Financial/FinancialAccount.xml b/xml/schema/Financial/FinancialAccount.xml
index 877a66e077..8c0fc0c681 100644
--- a/xml/schema/Financial/FinancialAccount.xml
+++ b/xml/schema/Financial/FinancialAccount.xml
@@ -116,7 +116,7 @@
   <field>
     <name>tax_rate</name>
     <type>decimal</type>
-    <length>9,8</length>
+    <length>10,8</length>
     <comment>The percentage of the total_amount that is due for this tax.</comment>
     <add>4.3</add>
   </field>
-- 
2.25.1