diff options
| author | Christian Grothoff <christian@grothoff.org> | 2021-11-27 22:58:50 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2021-11-27 22:58:50 +0100 |
| commit | 2d1a618d3dfb3dd0b85013b3e70debe308b88e72 (patch) | |
| tree | b0c472620eac7af320d52159291f6dabbb6aecd9 /src/exchangedb/exchange-0001.sql | |
| parent | fc04b91c9422aa1be14ec231b4ce8f0bbdace1d1 (diff) | |
| download | exchange-2d1a618d3dfb3dd0b85013b3e70debe308b88e72.tar.gz exchange-2d1a618d3dfb3dd0b85013b3e70debe308b88e72.tar.bz2 exchange-2d1a618d3dfb3dd0b85013b3e70debe308b88e72.zip | |
sql fix
Diffstat (limited to 'src/exchangedb/exchange-0001.sql')
| -rw-r--r-- | src/exchangedb/exchange-0001.sql | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql index 7ad0676cc..4a6c9afb5 100644 --- a/src/exchangedb/exchange-0001.sql +++ b/src/exchangedb/exchange-0001.sql @@ -285,6 +285,9 @@ COMMENT ON COLUMN known_coins.denom_sig CREATE INDEX IF NOT EXISTS known_coins_by_denomination ON known_coins (denominations_serial); +CREATE INDEX IF NOT EXISTS known_coins_by_hashed_coin_pub + ON known_coins + USING HASH (coin_pub); CREATE TABLE IF NOT EXISTS refresh_commitments @@ -302,6 +305,9 @@ COMMENT ON TABLE refresh_commitments CREATE INDEX IF NOT EXISTS refresh_commitments_old_coin_id_index ON refresh_commitments (old_known_coin_id); +CREATE INDEX IF NOT EXISTS known_coins_by_hashed_rc + ON refresh_commitments + USING HASH (rc); CREATE TABLE IF NOT EXISTS refresh_revealed_coins @@ -422,7 +428,6 @@ CREATE INDEX IF NOT EXISTS deposits_get_ready_index ,refund_deadline ,tiny ,done - ,kyc_ok ,extension_blocked ); COMMENT ON INDEX deposits_coin_pub_merchant_contract_index |