diff options
author | Christian Grothoff <christian@grothoff.org> | 2021-01-08 18:14:46 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2021-01-08 18:14:46 +0100 |
commit | 13555448b67f41f1dad97a0116b3f82870c58cbd (patch) | |
tree | adfc2d7a04ba235b81f70634b55af907c1544f7f /src/exchangedb/exchange-0001.sql | |
parent | 3999999988878776a977aa27bb6e5097fa24c18a (diff) | |
download | exchange-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.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql index 8428a94b4..8ee5d0e06 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 |