make taler-merchant-wirewatch multi-instance capable

1 files changed, 10 insertions, 9 deletions

diff --git a/src/backenddb/merchant-0005.sql b/src/backenddb/merchant-0005.sql
index f558cbd2..1f3b9131 100644
--- a/src/backenddb/merchant-0005.sql
+++ b/src/backenddb/merchant-0005.sql
@@ -29,15 +29,16 @@ 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
+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
+  IS 'JSON with credentials needed to access the credit facade';
+COMMENT ON COLUMN merchant_accounts.last_bank_serial
   IS 'Serial number of the bank of the last transaction we successfully imported';
 
 -- Complete transaction