diff options
| -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," |