summaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange-0001.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2020-07-08 12:35:50 +0200
committerChristian Grothoff <christian@grothoff.org>2020-07-08 12:35:50 +0200
commit1ca062fc7a303202130f194a15739ea7ce6c2dc2 (patch)
tree841459f9d5e59048a5c3bbf84488e0eb51ad0624 /src/exchangedb/exchange-0001.sql
parent81fec09268d08762e85583650d7bd02fdd7e7de4 (diff)
downloadexchange-1ca062fc7a303202130f194a15739ea7ce6c2dc2.tar.gz
exchange-1ca062fc7a303202130f194a15739ea7ce6c2dc2.tar.bz2
exchange-1ca062fc7a303202130f194a15739ea7ce6c2dc2.zip
introduce known_coin_id, alas not yet used
Diffstat (limited to 'src/exchangedb/exchange-0001.sql')
-rw-r--r--src/exchangedb/exchange-0001.sql3
1 files changed, 2 insertions, 1 deletions
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
);