database schema update for #8638

1 files changed, 11 insertions, 2 deletions

diff --git a/src/backenddb/merchant-0005.sql b/src/backenddb/merchant-0005.sql
index b7bf4c91..a356f6da 100644
--- a/src/backenddb/merchant-0005.sql
+++ b/src/backenddb/merchant-0005.sql
@@ -1,6 +1,6 @@
 --
 -- This file is part of TALER
--- Copyright (C) 2023 Taler Systems SA
+-- Copyright (C) 2024 Taler Systems SA
 --
 -- TALER is free software; you can redistribute it and/or modify it under the
 -- terms of the GNU General Public License as published by the Free Software
@@ -18,10 +18,19 @@
 BEGIN;
 
 -- Check patch versioning is in place.
--- SELECT _v.register_patch('merchant-0005', NULL, NULL);
+SELECT _v.register_patch('merchant-0005', NULL, NULL);
 
 SET search_path TO merchant;
 
+ALTER TABLE merchant_template
+  ADD COLUMN required_currency VARCHAR(12) DEFAULT NULL,
+  ADD COLUMN editable_defaults TEXT DEFAULT NULL;
+
+COMMENT ON COLUMN merchant_template.required_currency
+  IS 'currency that the amount to be paid entered by the user must be in; if not given and the amount is not fixed in the template contract, the user may edit the currency';
+COMMENT ON COLUMN merchant_template.editable_defaults
+  IS 'JSON object with fields matching the template contract, just with default values that are editable by the user';
+
 
 -- Complete transaction
 COMMIT;