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_predicted_result.sql | |
parent | c89c7eff4945dd56887530705841ef648427b35d (diff) | |
download | exchange-4f255d799a1f9b14e8491a76a9be99dfa44e4385.tar.xz |
-first hack at SQL fixes
Diffstat (limited to 'src/auditordb/0002-auditor_predicted_result.sql')
-rw-r--r-- | src/auditordb/0002-auditor_predicted_result.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/auditordb/0002-auditor_predicted_result.sql b/src/auditordb/0002-auditor_predicted_result.sql index cc39afb1c..5792313c6 100644 --- a/src/auditordb/0002-auditor_predicted_result.sql +++ b/src/auditordb/0002-auditor_predicted_result.sql @@ -14,11 +14,11 @@ -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> -- + +-- FIXME: should be folded into the new general balances table! CREATE TABLE IF NOT EXISTS auditor_predicted_result - ,balance_val INT8 NOT NULL - ,balance_frac INT4 NOT NULL - ,drained_val INT8 NOT NULL - ,drained_frac INT4 NOT NULL + (balance taler_amount NOT NULL + ,drained taler_amount NOT NULL ); COMMENT ON TABLE auditor_predicted_result 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).'; |