[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-merchant] branch master updated: -fix SQL
From: |
gnunet |
Subject: |
[taler-merchant] branch master updated: -fix SQL |
Date: |
Tue, 21 Feb 2023 14:48:10 +0100 |
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 fbdb2b12 -fix SQL
fbdb2b12 is described below
commit fbdb2b127c828ce2feffc0ee72417f51e9b78987
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Tue Feb 21 14:48:07 2023 +0100
-fix SQL
---
src/backenddb/merchant-0004.sql | 8 ++++----
src/backenddb/plugin_merchantdb_postgres.c | 2 +-
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/backenddb/merchant-0004.sql b/src/backenddb/merchant-0004.sql
index 41d1008b..7c86a636 100644
--- a/src/backenddb/merchant-0004.sql
+++ b/src/backenddb/merchant-0004.sql
@@ -111,8 +111,8 @@ COMMENT ON COLUMN merchant_kyc.aml_decision
ALTER TABLE merchant_orders
- ADD COLUMN pos_key VARCHAR DEFAULT NULL;
- ADD COLUMN pos_algorithm INT4 NOT NULL DEFAULT (0);
+ ADD COLUMN pos_key VARCHAR DEFAULT NULL,
+ ADD COLUMN pos_algorithm INT NOT NULL DEFAULT (0);
COMMENT ON COLUMN merchant_orders.pos_key
IS 'encoded based key which is used for the verification of payment';
@@ -122,8 +122,8 @@ COMMENT ON COLUMN merchant_orders.pos_algorithm
ALTER TABLE merchant_contract_terms
- ADD COLUMN pos_key VARCHAR DEFAULT NULL;
- ADD COLUMN pos_algorithm INT4 NOT NULL DEFAULT (0);
+ ADD COLUMN pos_key VARCHAR DEFAULT NULL,
+ ADD COLUMN pos_algorithm INT NOT NULL DEFAULT (0);
COMMENT ON COLUMN merchant_contract_terms.pos_key
IS 'enconded based key which is used for the verification of payment';
diff --git a/src/backenddb/plugin_merchantdb_postgres.c
b/src/backenddb/plugin_merchantdb_postgres.c
index f8ef6efb..02749eff 100644
--- a/src/backenddb/plugin_merchantdb_postgres.c
+++ b/src/backenddb/plugin_merchantdb_postgres.c
@@ -9163,7 +9163,7 @@ postgres_connect (void *cls)
",mo.claim_token"
",mo.pos_key"
",mo.pos_algorithm"
- "FROM merchant_orders mo"
+ " FROM merchant_orders mo"
" WHERE order_id=$2"
" AND merchant_serial="
" (SELECT merchant_serial"
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [taler-merchant] branch master updated: -fix SQL,
gnunet <=