diff options
| author | Christian Grothoff <christian@grothoff.org> | 2020-07-08 12:35:50 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2020-07-08 12:35:50 +0200 |
| commit | 1ca062fc7a303202130f194a15739ea7ce6c2dc2 (patch) | |
| tree | 841459f9d5e59048a5c3bbf84488e0eb51ad0624 | |
| parent | 81fec09268d08762e85583650d7bd02fdd7e7de4 (diff) | |
introduce known_coin_id, alas not yet used
| -rw-r--r-- | src/exchangedb/exchange-0001.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql index ad05e7797..25b778238 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 ); |