diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-06-28 08:58:26 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-06-28 08:58:26 +0200 |
| commit | 5e801cfd864eb8c8dd790cc138e1edbacb16e83e (patch) | |
| tree | 4d620f4e4e09690dca820af21faa5960195d6831 | |
| parent | 7d6f8650413abf4b50a9db6532260b4fcd7c5dd4 (diff) | |
fix merchant-categories SQL bug, fix merchant-0009 syntax issue
| -rw-r--r-- | src/backenddb/merchant-0009.sql | 6 | ||||
| -rw-r--r-- | 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 index 56705c3e..babecf93 100644 --- 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 index f820b2c6..9fb14f99 100644 --- 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," |