aboutsummaryrefslogtreecommitdiff
path: root/src/auditordb/0002-auditor_predicted_result.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-09-26 11:25:31 +0200
committerChristian Grothoff <christian@grothoff.org>2023-09-26 11:25:31 +0200
commit4f255d799a1f9b14e8491a76a9be99dfa44e4385 (patch)
tree110861827ee16975f297b8dd05803f8c6fa53993 /src/auditordb/0002-auditor_predicted_result.sql
parentc89c7eff4945dd56887530705841ef648427b35d (diff)
downloadexchange-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.sql8
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).';