diff options
| author | Christian Grothoff <christian@grothoff.org> | 2021-06-21 00:17:16 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2021-06-21 00:17:16 +0200 |
| commit | 9c51720cbfb86c89bc1f1872432c4f6a66fba5bd (patch) | |
| tree | 56eede9e232962013b09afa2efc3c1cb37f41e0f /src/exchangedb/exchange-0001.sql | |
| parent | 108bf57d048a135cb71f9453540c9d6579ae2028 (diff) | |
| download | exchange-9c51720cbfb86c89bc1f1872432c4f6a66fba5bd.tar.gz exchange-9c51720cbfb86c89bc1f1872432c4f6a66fba5bd.tar.bz2 exchange-9c51720cbfb86c89bc1f1872432c4f6a66fba5bd.zip | |
fixing parallel fakebank to ensure transactions are ordered, fixing indices/constraint preservation after DB update to 0002
Diffstat (limited to 'src/exchangedb/exchange-0001.sql')
| -rw-r--r-- | src/exchangedb/exchange-0001.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql index 1f7e005ea..55d3d07dc 100644 --- a/src/exchangedb/exchange-0001.sql +++ b/src/exchangedb/exchange-0001.sql @@ -389,6 +389,9 @@ COMMENT ON TABLE recoup COMMENT ON COLUMN recoup.coin_pub IS 'Do not CASCADE ON DROP on the coin_pub, as we may keep the coin alive!'; +-- Note: this first index is redundant; +-- It is implicitly removed by the exchange-0002.sql +-- schema changes. CREATE INDEX IF NOT EXISTS recoup_by_coin_index ON recoup (coin_pub); @@ -415,6 +418,8 @@ CREATE TABLE IF NOT EXISTS recoup_refresh COMMENT ON COLUMN recoup_refresh.coin_pub IS 'Do not CASCADE ON DROP on the coin_pub, as we may keep the coin alive!'; +-- Note: this index is redundant; implicitly removed +-- by the exchange-0002.sql update! CREATE INDEX IF NOT EXISTS recoup_refresh_by_coin_index ON recoup_refresh (coin_pub); |