diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-04-24 01:32:26 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-04-24 01:32:26 +0200 |
commit | e65b6db7ea6951151a8e04b7676bc86888f6b7a5 (patch) | |
tree | ae7c120db599a52d300884a31f1a11ffaae0f74f /src/backenddb/merchant-0005.sql | |
parent | 5722b1933d734ffed9681c2a53a9a583666ce87a (diff) | |
download | merchant-e65b6db7ea6951151a8e04b7676bc86888f6b7a5.tar.gz merchant-e65b6db7ea6951151a8e04b7676bc86888f6b7a5.tar.bz2 merchant-e65b6db7ea6951151a8e04b7676bc86888f6b7a5.zip |
rough structure for taler-merchant-exchange
Diffstat (limited to 'src/backenddb/merchant-0005.sql')
-rw-r--r-- | src/backenddb/merchant-0005.sql | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/src/backenddb/merchant-0005.sql b/src/backenddb/merchant-0005.sql index 1f3b9131..16409b6d 100644 --- a/src/backenddb/merchant-0005.sql +++ b/src/backenddb/merchant-0005.sql @@ -24,16 +24,23 @@ SET search_path TO merchant; ALTER TABLE merchant_instances ADD COLUMN user_type INT; - COMMENT ON COLUMN merchant_instances.user_type IS 'what type of user is this (individual or business)'; +ALTER TABLE merchant_transfers + ADD COLUMN failed BOOLEAN NOT NULL DEFAULT FALSE, + ADD COLUMN validation_status VARCHAR DEFAULT NULL; +COMMENT ON COLUMN merchant_transfers.failed + IS 'set to true on permanent verification failures'; +COMMENT ON COLUMN merchant_instances.validation_status + IS 'human-readable description of the state of the validation'; + + ALTER TABLE merchant_accounts ADD COLUMN credit_facade_url VARCHAR, ADD COLUMN credit_facade_credentials VARCHAR, ADD COLUMN last_bank_serial INT8 NOT NULL DEFAULT (0); - COMMENT ON COLUMN merchant_accounts.credit_facade_url IS 'Base URL of a facade where the merchant can inquire about incoming bank transactions into this account'; COMMENT ON COLUMN merchant_accounts.credit_facade_credentials |