exchange

Base system with REST service to issue digital coins, run by the payment service provider
Log | Files | Refs | Submodules | README | LICENSE
commit 1ca062fc7a303202130f194a15739ea7ce6c2dc2
parent 81fec09268d08762e85583650d7bd02fdd7e7de4
Author: Christian Grothoff <christian@grothoff.org>
Date:   Wed,  8 Jul 2020 12:35:50 +0200

introduce known_coin_id, alas not yet used

Diffstat:

Msrc/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
@@ -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
   );