-first hack at SQL fixes

1 files changed, 8 insertions, 15 deletions

diff --git a/src/auditordb/0002-auditor_reserve_balance.sql b/src/auditordb/0002-auditor_reserve_balance.sql
index 8267a3a28..46c18ec9d 100644
--- a/src/auditordb/0002-auditor_reserve_balance.sql
+++ b/src/auditordb/0002-auditor_reserve_balance.sql
@@ -15,20 +15,13 @@
 --
 
 CREATE TABLE IF NOT EXISTS auditor_reserve_balance
-    ,reserve_balance_val INT8 NOT NULL
-    ,reserve_balance_frac INT4 NOT NULL
-    ,reserve_loss_val INT8 NOT NULL
-    ,reserve_loss_frac INT4 NOT NULL
-    ,withdraw_fee_balance_val INT8 NOT NULL
-    ,withdraw_fee_balance_frac INT4 NOT NULL
-    ,close_fee_balance_val INT8 NOT NULL
-    ,close_fee_balance_frac INT4 NOT NULL
-    ,purse_fee_balance_val INT8 NOT NULL
-    ,purse_fee_balance_frac INT4 NOT NULL
-    ,open_fee_balance_val INT8 NOT NULL
-    ,open_fee_balance_frac INT4 NOT NULL
-    ,history_fee_balance_val INT8 NOT NULL
-    ,history_fee_balance_frac INT4 NOT NULL
+    ,reserve_balance taler_amount NOT NULL
+    ,reserve_loss taler_amount NOT NULL
+    ,withdraw_fee_balance taler_amount NOT NULL
+    ,close_fee_balance taler_amount NOT NULL
+    ,purse_fee_balance taler_amount NOT NULL
+    ,open_fee_balance taler_amount NOT NULL
+    ,history_fee_balance taler_amount NOT NULL
     );
 COMMENT ON TABLE auditor_reserve_balance
-  IS 'sum of the balances of all customer reserves';
\ No newline at end of file
+  IS 'sum of the balances of all customer reserves';