diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-09-26 11:25:31 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-09-26 11:25:31 +0200 |
commit | 4f255d799a1f9b14e8491a76a9be99dfa44e4385 (patch) | |
tree | 110861827ee16975f297b8dd05803f8c6fa53993 /src/auditordb/0002-auditor_reserve_balance.sql | |
parent | c89c7eff4945dd56887530705841ef648427b35d (diff) | |
download | exchange-4f255d799a1f9b14e8491a76a9be99dfa44e4385.tar.xz |
-first hack at SQL fixes
Diffstat (limited to 'src/auditordb/0002-auditor_reserve_balance.sql')
-rw-r--r-- | src/auditordb/0002-auditor_reserve_balance.sql | 23 |
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'; |