commit e253a5b055dd1e9d335e7736160a5413ee4c157c
parent b244e23859a933d98e44dac88bd529f22e378214
Author: Christian Grothoff <christian@grothoff.org>
Date: Thu, 24 Feb 2022 09:06:15 +0100
-unique constraint is crucial
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git 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