[taler-exchange] branch master updated: add missing index

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository exchange.

The following commit(s) were added to refs/heads/master by this push:
     new 0fc621f1 add missing index
0fc621f1 is described below

commit 0fc621f1250145b636132b2ccc25460763012161
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Thu Nov 11 13:14:25 2021 +0100

    add missing index
---
 src/exchangedb/exchange-0002.sql | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/src/exchangedb/exchange-0002.sql b/src/exchangedb/exchange-0002.sql
index 175ffb39..b312e2d5 100644
--- a/src/exchangedb/exchange-0002.sql
+++ b/src/exchangedb/exchange-0002.sql
@@ -323,6 +323,10 @@ ALTER TABLE refresh_revealed_coins
 COMMENT ON COLUMN refresh_revealed_coins.melt_serial_id
   IS 'Identifies the refresh commitment (rc) of the operation.';
 
+CREATE INDEX IF NOT EXISTS refresh_revealed_coins_pk_idx
+  ON refresh_revealed_coins
+  (melt_serial_id, freshcoin_index);
+
 
 -- Change 'merchant_pub' and 'h_contract_terms' and 'known_coin_id' in 
'refunds' table
 -- to 'deposit_serial_id' instead!

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.