[taler-merchant] branch master updated: update DB schema for #6446

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository merchant.

The following commit(s) were added to refs/heads/master by this push:
     new 3cbbe7b  update DB schema for #6446
3cbbe7b is described below

commit 3cbbe7b9ff49e8053458bac68bd47ebef72ed0ec
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Mon Jul 27 10:44:49 2020 +0200

    update DB schema for #6446
---
 src/backenddb/merchant-0001.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql
index f26cd5a..8b2b3ca 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

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.