diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-03-18 23:45:58 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-03-18 23:45:58 +0100 |
| commit | ef8927863d6f39098c1c68bbc0bf8a36319caccf (patch) | |
| tree | 34fe3e930fbc66fcd63a9ae540b3e04d0791ca83 | |
| parent | 42490d300851bf16e94d9ba19ed230fc41867e38 (diff) | |
database schema update for #8638
| -rw-r--r-- | src/backenddb/merchant-0005.sql | 13 |
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; |