diff options
| author | Christian Grothoff <christian@grothoff.org> | 2021-02-19 00:20:57 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2021-02-19 00:20:57 +0100 |
| commit | a1265a059aa048a539d4cc0ea3e072ef5f98f0c1 (patch) | |
| tree | 2b51ccb572615ff63d60b27865128ee56935dfa0 /src/backenddb/merchant-0001.sql | |
| parent | c3b87356b2f31f63bb7dfa84cb7a3361fc55debc (diff) | |
| download | merchant-a1265a059aa048a539d4cc0ea3e072ef5f98f0c1.tar.gz merchant-a1265a059aa048a539d4cc0ea3e072ef5f98f0c1.tar.bz2 merchant-a1265a059aa048a539d4cc0ea3e072ef5f98f0c1.zip | |
remove bogus UNIQUE constraint (#6758)
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
| -rw-r--r-- | src/backenddb/merchant-0001.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index a39a2436..ba2129dc 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -94,7 +94,7 @@ COMMENT ON TABLE merchant_keys CREATE TABLE IF NOT EXISTS merchant_accounts (account_serial BIGSERIAL PRIMARY KEY - ,merchant_serial BIGINT NOT NULL UNIQUE + ,merchant_serial BIGINT NOT NULL REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE ,h_wire BYTEA NOT NULL CHECK (LENGTH(h_wire)=64) ,salt BYTEA NOT NULL CHECK (LENGTH(salt)=64) @@ -242,7 +242,7 @@ CREATE TABLE IF NOT EXISTS merchant_contract_terms ,refund_deadline INT8 NOT NULL ,paid BOOLEAN DEFAULT FALSE NOT NULL ,wired BOOLEAN DEFAULT FALSE NOT NULL - ,fulfillment_url VARCHAR + ,fulfillment_url VARCHAR ,session_id VARCHAR DEFAULT '' NOT NULL ,UNIQUE (merchant_serial, order_id) ,UNIQUE (merchant_serial, h_contract_terms) |