diff options
author | Christian Grothoff <christian@grothoff.org> | 2020-07-27 10:44:49 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2020-07-27 10:44:49 +0200 |
commit | 3cbbe7b9ff49e8053458bac68bd47ebef72ed0ec (patch) | |
tree | 0138a8f9c82314ec2862d9cd470aa583789fce98 | |
parent | c9de5986194bb2a65c65b39a50cf820517833893 (diff) | |
download | merchant-3cbbe7b9ff49e8053458bac68bd47ebef72ed0ec.tar.gz merchant-3cbbe7b9ff49e8053458bac68bd47ebef72ed0ec.tar.bz2 merchant-3cbbe7b9ff49e8053458bac68bd47ebef72ed0ec.zip |
update DB schema for #6446
-rw-r--r-- | src/backenddb/merchant-0001.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index f26cd5a8..8b2b3cad 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -188,6 +188,7 @@ CREATE TABLE IF NOT EXISTS merchant_orders ,merchant_serial BIGINT NOT NULL REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE ,order_id VARCHAR NOT NULL + ,claim_token BYTEA NOT NULL CHECK (LENGTH(h_contract_terms)=16) ,pay_deadline INT8 NOT NULL ,creation_time INT8 NOT NULL ,contract_terms BYTEA NOT NULL @@ -197,6 +198,8 @@ COMMENT ON TABLE merchant_orders IS 'Orders we offered to a customer, but that have not yet been claimed'; COMMENT ON COLUMN merchant_orders.contract_terms IS 'Claiming changes the contract_terms, hence we have no hash of the terms in this table'; +COMMENT ON COLUMN merchant_orders.claim_token + IS 'Token optionally used to authorize the wallet to claim the order. All zeros (not NULL) if not used'; COMMENT ON COLUMN merchant_orders.merchant_serial IS 'Identifies the instance offering the contract'; COMMENT ON COLUMN merchant_orders.pay_deadline |