summaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2021-01-08 18:14:46 +0100
committerChristian Grothoff <christian@grothoff.org>2021-01-08 18:14:46 +0100
commit13555448b67f41f1dad97a0116b3f82870c58cbd (patch)
treeadfc2d7a04ba235b81f70634b55af907c1544f7f /src/exchangedb/exchange-0001.sql
parent3999999988878776a977aa27bb6e5097fa24c18a (diff)
downloadexchange-13555448b67f41f1dad97a0116b3f82870c58cbd.tar.gz
exchange-13555448b67f41f1dad97a0116b3f82870c58cbd.tar.bz2
exchange-13555448b67f41f1dad97a0116b3f82870c58cbd.zip
change exchange database to use denominations_serial instead of denom_pub_hash as foreign key
Diffstat (limited to 'src/exchangedb/exchange-0001.sql')
-rw-r--r--src/exchangedb/exchange-0001.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql
index 8428a94b..8ee5d0e0 100644
--- a/src/exchangedb/exchange-0001.sql
+++ b/src/exchangedb/exchange-0001.sql
@@ -103,7 +103,7 @@ CREATE TABLE IF NOT EXISTS reserves_in
);
COMMENT ON TABLE reserves_in
IS 'list of transfers of funds into the reserves, one per incoming wire transfer';
-
+-- FIXME: explain 'wire_reference'!
CREATE INDEX IF NOT EXISTS reserves_in_execution_index
ON reserves_in
(exchange_account_section
@@ -151,6 +151,7 @@ COMMENT ON COLUMN reserves_out.h_blind_ev
IS 'Hash of the blinded coin, used as primary key here so that broken clients that use a non-random coin or blinding factor fail to withdraw (otherwise they would fail on deposit when the coin is not unique there).';
COMMENT ON COLUMN reserves_out.denom_pub_hash
IS 'We do not CASCADE ON DELETE here, we may keep the denomination data alive';
+-- FIXME: replace denom_pub_hash with denominations_serial *EVERYWHERE*
CREATE INDEX IF NOT EXISTS reserves_out_reserve_pub_index
ON reserves_out