[taler-merchant] branch master updated: define new merchant_wirewatch table

[gnunet]

This is an automated email from the git hooks/post-receive script.

grothoff pushed a commit to branch master
in repository merchant.

The following commit(s) were added to refs/heads/master by this push:
     new fc276666 define new merchant_wirewatch table
fc276666 is described below

commit fc27666623c28fedf272495881ee63d7580cd589
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Wed Apr 12 15:31:39 2023 +0200

    define new merchant_wirewatch table
---
 src/backenddb/merchant-0005.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

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;

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.