diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-02-21 14:48:07 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-02-21 14:48:07 +0100 |
| commit | fbdb2b127c828ce2feffc0ee72417f51e9b78987 (patch) | |
| tree | 91beaf5d2ad6b654e6ce55dac83ec27bfa7905e1 | |
| parent | 1c3fbbf86b82e4ce12855431400ef0f95f0c4273 (diff) | |
-fix SQL
| -rw-r--r-- | src/backenddb/merchant-0004.sql | 8 | ||||
| -rw-r--r-- | 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" |