killbill-memoizeit

Update amount precision in payment subsystem to be consistent …

10/1/2012 7:28:29 PM

with the rest of the system

stephane brossier

Commit: 944d25a

Tree: 804b173

Parents: eba5522

Changes

payment/src/main/resources/com/ning/billing/payment/ddl.sql 12(+6 -6)

Details

payment/src/main/resources/com/ning/billing/payment/ddl.sql 12(+6 -6)

diff --git a/payment/src/main/resources/com/ning/billing/payment/ddl.sql b/payment/src/main/resources/com/ning/billing/payment/ddl.sql
index 1c47a7c..c63b519 100644
--- a/payment/src/main/resources/com/ning/billing/payment/ddl.sql
+++ b/payment/src/main/resources/com/ning/billing/payment/ddl.sql
@@ -7,7 +7,7 @@ CREATE TABLE payments (
     account_id char(36) COLLATE utf8_bin NOT NULL,
     invoice_id char(36) COLLATE utf8_bin NOT NULL,
     payment_method_id char(36) COLLATE utf8_bin NOT NULL,    
-    amount decimal(8,2),
+    amount numeric(10,4),
     currency char(3),    
     effective_date datetime,
     payment_status varchar(50),
@@ -33,7 +33,7 @@ CREATE TABLE payment_history (
     account_id char(36) COLLATE utf8_bin NOT NULL,
     invoice_id char(36) COLLATE utf8_bin NOT NULL,
     payment_method_id char(36) COLLATE utf8_bin NOT NULL,    
-    amount decimal(8,2),
+    amount numeric(10,4),
     currency char(3),    
     effective_date datetime,
     payment_status varchar(50),
@@ -58,7 +58,7 @@ CREATE TABLE payment_attempts (
     gateway_error_code varchar(32),              
     gateway_error_msg varchar(256),
     processing_status varchar(50),
-    requested_amount decimal(8,2),      
+    requested_amount numeric(10,4),
     created_by varchar(50) NOT NULL,
     created_date datetime NOT NULL,
     updated_by varchar(50) NOT NULL,
@@ -80,7 +80,7 @@ CREATE TABLE payment_attempt_history (
     gateway_error_code varchar(32),              
     gateway_error_msg varchar(256),
     processing_status varchar(50),
-    requested_amount decimal(8,2),            
+    requested_amount numeric(10,4),
     created_by varchar(50) NOT NULL,
     created_date datetime NOT NULL,
     updated_by varchar(50) NOT NULL,
@@ -137,7 +137,7 @@ CREATE TABLE refunds (
     id char(36) NOT NULL,
     account_id char(36) COLLATE utf8_bin NOT NULL,
     payment_id char(36) COLLATE utf8_bin NOT NULL,    
-    amount decimal(8,2),
+    amount numeric(10,4),
     currency char(3),   
     is_adjusted tinyint(1),
     refund_status varchar(50), 
@@ -160,7 +160,7 @@ CREATE TABLE refund_history (
     id char(36) NOT NULL,
     account_id char(36) COLLATE utf8_bin NOT NULL,
     payment_id char(36) COLLATE utf8_bin NOT NULL,    
-    amount decimal(8,2),
+    amount numeric(10,4),
     currency char(3),   
     is_adjusted tinyint(1),
     refund_status varchar(50),