[taler-merchant] branch master updated: -fix SQL

[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 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.