[taler-exchange] branch master updated: introduce known_coin_id, alas not yet used

[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 1ca062fc introduce known_coin_id, alas not yet used
1ca062fc is described below

commit 1ca062fc7a303202130f194a15739ea7ce6c2dc2
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Wed Jul 8 12:35:50 2020 +0200

    introduce known_coin_id, alas not yet used
---
 src/exchangedb/exchange-0001.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql
index ad05e779..25b77823 100644
--- a/src/exchangedb/exchange-0001.sql
+++ b/src/exchangedb/exchange-0001.sql
@@ -168,7 +168,8 @@ CREATE INDEX IF NOT EXISTS 
reserves_out_for_get_withdraw_info
 
 
 CREATE TABLE IF NOT EXISTS known_coins
-  (coin_pub BYTEA NOT NULL PRIMARY KEY CHECK (LENGTH(coin_pub)=32)
+  (known_coin_id BIGSERIAL UNIQUE
+  ,coin_pub BYTEA NOT NULL PRIMARY KEY CHECK (LENGTH(coin_pub)=32)
   ,denom_pub_hash BYTEA NOT NULL REFERENCES denominations (denom_pub_hash) ON 
DELETE CASCADE
   ,denom_sig BYTEA NOT NULL
   );

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