merchant

commit fbdb2b127c828ce2feffc0ee72417f51e9b78987
parent 1c3fbbf86b82e4ce12855431400ef0f95f0c4273
Author: Christian Grothoff <christian@grothoff.org>
Date:   Tue, 21 Feb 2023 14:48:07 +0100

-fix SQL

Diffstat:
M
src/backenddb/merchant-0004.sql
 | 
8
++++----
M
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
@@ -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
@@ -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"