diff options
author | Christian Grothoff <christian@grothoff.org> | 2022-02-24 09:06:15 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2022-02-24 09:06:15 +0100 |
commit | e253a5b055dd1e9d335e7736160a5413ee4c157c (patch) | |
tree | 289804802398f5eae571d1a004b80d7927c70446 /src/exchangedb | |
parent | b244e23859a933d98e44dac88bd529f22e378214 (diff) |
-unique constraint is crucial
Diffstat (limited to 'src/exchangedb')
-rw-r--r-- | src/exchangedb/exchange-0001.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/exchangedb/exchange-0001.sql b/src/exchangedb/exchange-0001.sql index 0cef7d0db..477a9b0dc 100644 --- a/src/exchangedb/exchange-0001.sql +++ b/src/exchangedb/exchange-0001.sql @@ -196,7 +196,7 @@ CREATE INDEX IF NOT EXISTS reserves_close_by_reserve_pub_index CREATE TABLE IF NOT EXISTS reserves_out (reserve_out_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY -- UNIQUE - ,h_blind_ev BYTEA CHECK (LENGTH(h_blind_ev)=64) -- UNIQUE + ,h_blind_ev BYTEA CHECK (LENGTH(h_blind_ev)=64) UNIQUE ,denominations_serial INT8 NOT NULL REFERENCES denominations (denominations_serial) ,denom_sig BYTEA NOT NULL ,reserve_uuid INT8 NOT NULL -- REFERENCES reserves (reserve_uuid) ON DELETE CASCADE |