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_denomination_pending.sql | |
parent | c89c7eff4945dd56887530705841ef648427b35d (diff) | |
download | exchange-4f255d799a1f9b14e8491a76a9be99dfa44e4385.tar.xz |
-first hack at SQL fixes
Diffstat (limited to 'src/auditordb/0002-auditor_denomination_pending.sql')
-rw-r--r-- | src/auditordb/0002-auditor_denomination_pending.sql | 26 |
1 files changed, 11 insertions, 15 deletions
diff --git a/src/auditordb/0002-auditor_denomination_pending.sql b/src/auditordb/0002-auditor_denomination_pending.sql index e03febfec..ea47dc0da 100644 --- a/src/auditordb/0002-auditor_denomination_pending.sql +++ b/src/auditordb/0002-auditor_denomination_pending.sql @@ -15,24 +15,20 @@ -- CREATE TABLE IF NOT EXISTS auditor_denomination_pending -(denom_pub_hash BYTEA PRIMARY KEY CHECK (LENGTH(denom_pub_hash)=64) - ,denom_balance_val INT8 NOT NULL - ,denom_balance_frac INT4 NOT NULL - ,denom_loss_val INT8 NOT NULL - ,denom_loss_frac INT4 NOT NULL - ,num_issued INT8 NOT NULL - ,denom_risk_val INT8 NOT NULL - ,denom_risk_frac INT4 NOT NULL - ,recoup_loss_val INT8 NOT NULL - ,recoup_loss_frac INT4 NOT NULL - ); + (denom_pub_hash BYTEA PRIMARY KEY CHECK (LENGTH(denom_pub_hash)=64) + ,denom_balance taler_amount NOT NULL + ,denom_loss taler_amount NOT NULL + ,num_issued INT8 NOT NULL + ,denom_risk taler_amount NOT NULL + ,recoup_loss taler_amount NOT NULL +); COMMENT ON TABLE auditor_denomination_pending IS 'outstanding denomination coins that the exchange is aware of and what the respective balances are (outstanding as well as issued overall which implies the maximum value at risk).'; COMMENT ON COLUMN auditor_denomination_pending.num_issued IS 'counts the number of coins issued (withdraw, refresh) of this denomination'; -COMMENT ON COLUMN auditor_denomination_pending.denom_risk_val +COMMENT ON COLUMN auditor_denomination_pending.denom_risk IS 'amount that could theoretically be lost in the future due to recoup operations'; -COMMENT ON COLUMN auditor_denomination_pending.denom_loss_val +COMMENT ON COLUMN auditor_denomination_pending.denom_loss IS 'amount that was lost due to failures by the exchange'; -COMMENT ON COLUMN auditor_denomination_pending.recoup_loss_val - IS 'amount actually lost due to recoup operations after a revocation';
\ No newline at end of file +COMMENT ON COLUMN auditor_denomination_pending.recoup_loss + IS 'amount actually lost due to recoup operations after a revocation'; |