From 9c51720cbfb86c89bc1f1872432c4f6a66fba5bd Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Mon, 21 Jun 2021 00:17:16 +0200
Subject: fixing parallel fakebank to ensure transactions are ordered, fixing
 indices/constraint preservation after DB update to 0002

---
 src/exchangedb/exchange-0001.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'src/exchangedb/exchange-0001.sql')

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);
-- 
cgit v1.2.3

