diff options
| author | Christian Grothoff <christian@grothoff.org> | 2022-07-31 21:54:29 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2022-07-31 21:54:29 +0200 |
| commit | 31bfe5234e9f1031306ce7cfae9a8a3fee5aa304 (patch) | |
| tree | 0cda3cc1ef29226156c2774cd1d9f6f1957c495d /src/auditordb/auditor-0001.sql | |
| parent | af6a9a95469f98172c53ca10167210d41803bfb9 (diff) | |
| download | exchange-31bfe5234e9f1031306ce7cfae9a8a3fee5aa304.tar.gz exchange-31bfe5234e9f1031306ce7cfae9a8a3fee5aa304.tar.bz2 exchange-31bfe5234e9f1031306ce7cfae9a8a3fee5aa304.zip | |
-update auditor schema in preparation to fix #4960
Diffstat (limited to 'src/auditordb/auditor-0001.sql')
| -rw-r--r-- | src/auditordb/auditor-0001.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/auditordb/auditor-0001.sql b/src/auditordb/auditor-0001.sql index 233ad6864..483f4f1e3 100644 --- a/src/auditordb/auditor-0001.sql +++ b/src/auditordb/auditor-0001.sql @@ -267,9 +267,11 @@ CREATE TABLE IF NOT EXISTS auditor_predicted_result (master_pub BYTEA NOT NULL CONSTRAINT master_pub_ref REFERENCES auditor_exchanges(master_pub) ON DELETE CASCADE ,balance_val INT8 NOT NULL ,balance_frac INT4 NOT NULL + ,drained_val INT8 NOT NULL + ,drained_frac INT4 NOT NULL ); COMMENT ON TABLE auditor_predicted_result - IS 'Table with the sum of the ledger, auditor_historic_revenue and the auditor_reserve_balance. This is the final amount that the exchange should have in its bank account right now.'; + IS 'Table with the sum of the ledger, auditor_historic_revenue and the auditor_reserve_balance and the drained profits. This is the final amount that the exchange should have in its bank account right now (and the total amount drained as profits to non-escrow accounts).'; -- Finally, commit everything |