merchant

commit 5e801cfd864eb8c8dd790cc138e1edbacb16e83e
parent 7d6f8650413abf4b50a9db6532260b4fcd7c5dd4
Author: Christian Grothoff <christian@grothoff.org>
Date:   Fri, 28 Jun 2024 08:58:26 +0200

fix merchant-categories SQL bug, fix merchant-0009 syntax issue

Diffstat:
M
src/backenddb/merchant-0009.sql
 | 
6
+++---
M
src/backenddb/pg_insert_category.c
 | 
3
++-

2 files changed, 5 insertions(+), 4 deletions(-)
diff --git a/src/backenddb/merchant-0009.sql b/src/backenddb/merchant-0009.sql
@@ -24,10 +24,10 @@ BEGIN;
 -- Check patch versioning is in place.
 SELECT _v.register_patch('merchant-0009', NULL, NULL);
 
-SET search_path TO merchant
-  DROP COLUMN required_currency;
+SET search_path TO merchant;
 
-ALTER TABLE merchant_template ;
+ALTER TABLE merchant_template
+  DROP COLUMN required_currency;
 
 -- Complete transaction
 COMMIT;
diff --git a/src/backenddb/pg_insert_category.c b/src/backenddb/pg_insert_category.c
@@ -50,7 +50,8 @@ TMH_PG_insert_category (void *cls,
   PREPARE (pg,
            "insert_category",
            "INSERT INTO merchant_categories"
-           "(category_name"
+           "(merchant_serial"
+           ",category_name"
            ",category_name_i18n"
            ")"
            " SELECT merchant_serial,"