diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-04-12 15:31:39 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-04-12 15:31:39 +0200 |
commit | fc27666623c28fedf272495881ee63d7580cd589 (patch) | |
tree | d5d65aa7488403cde90af7ee5c47d8f6c18f255a /src/backenddb | |
parent | 4c8214202116dc44171e14ec2bad1fdb37d2c4e7 (diff) | |
download | merchant-fc27666623c28fedf272495881ee63d7580cd589.tar.gz merchant-fc27666623c28fedf272495881ee63d7580cd589.tar.bz2 merchant-fc27666623c28fedf272495881ee63d7580cd589.zip |
define new merchant_wirewatch table
Diffstat (limited to 'src/backenddb')
-rw-r--r-- | src/backenddb/merchant-0005.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/src/backenddb/merchant-0005.sql b/src/backenddb/merchant-0005.sql index 8006e565..f558cbd2 100644 --- a/src/backenddb/merchant-0005.sql +++ b/src/backenddb/merchant-0005.sql @@ -28,5 +28,17 @@ ALTER TABLE merchant_instances COMMENT ON COLUMN merchant_instances.user_type IS 'what type of user is this (individual or business)'; + +CREATE TABLE IF NOT EXISTS merchant_wirewatch + (account_section VARCHAR PRIMARY KEY + ,last_bank_serial INT8 NOT NULL + ); +COMMENT ON TABLE merchant_wirewatch + IS 'table used to keep track of progress made by the taler-merchant-wirewatch tool'; +COMMENT ON COLUMN merchant_wirewatch.account_section + IS 'Name of the configuration section that specifies the bank account details and merchant instance being tracked here'; +COMMENT ON COLUMN merchant_wirewatch.last_bank_serial + IS 'Serial number of the bank of the last transaction we successfully imported'; + -- Complete transaction COMMIT; |