diff options
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'; |