pos_key in template is set. Test case is also good

1 files changed, 17 insertions, 0 deletions

diff --git a/src/backenddb/merchant-0004.sql b/src/backenddb/merchant-0004.sql
index 3864f37d..696e60fc 100644
--- a/src/backenddb/merchant-0004.sql
+++ b/src/backenddb/merchant-0004.sql
@@ -106,6 +106,7 @@ COMMENT ON COLUMN merchant_pending_webhooks.body
   IS 'Body of the webhook';
 
 
+
 ALTER TABLE merchant_kyc
   ADD COLUMN aml_decision INT4 NOT NULL DEFAULT (0);
 
@@ -113,6 +114,22 @@ COMMENT ON COLUMN merchant_kyc.aml_decision
   IS 'current AML decision for our account at the exchange';
 
 
+
+ALTER TABLE merchant_orders
+  ADD COLUMN pos_key VARCHAR;
+
+COMMENT ON COLUMN merchant_orders.pos_key
+  IS 'encoded based key which is used for the verification of payment';
+
+
+
+ALTER TABLE merchant_contract_terms
+  ADD COLUMN pos_key VARCHAR;
+
+COMMENT  ON COLUMN merchant_contract_terms.pos_key
+  IS 'enconded based key which is used for the verification of payment';
+
+
 COMMIT;