[taler-merchant] branch master updated: webhook sql

[gnunet]

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

priscilla-huang pushed a commit to branch master
in repository merchant.

The following commit(s) were added to refs/heads/master by this push:
     new f6492a1e webhook sql
f6492a1e is described below

commit f6492a1e124bb71bd8082ffc1e07d6a663c81393
Author: priscilla <priscilla.huang@efrei.net>
AuthorDate: Fri Nov 25 05:48:03 2022 -0500

    webhook sql
---
 src/backenddb/merchant-0004.sql | 13 +++++--------
 1 file changed, 5 insertions(+), 8 deletions(-)

diff --git a/src/backenddb/merchant-0004.sql b/src/backenddb/merchant-0004.sql
index f7412a24..8e341583 100644
--- a/src/backenddb/merchant-0004.sql
+++ b/src/backenddb/merchant-0004.sql
@@ -51,10 +51,9 @@ CREATE TABLE IF NOT EXISTS merchant_webhooks
   ,webhook_id VARCHAR NOT NULL
   ,event_type VARCHAR NOT NULL
   ,url VARCHAR NOT NULL
-  ,methods VARCHAR NOT NULL
-  ,header_template VARCHAR NOT NULL -- in JSON format
-  ,body_template VARCHAR NOT NULL -- in JSON format
-  ,merchant_instance VARCHAR NOT NULL
+  ,http_method VARCHAR NOT NULL
+  ,header_template VARCHAR NOT NULL
+  ,body_template VARCHAR NOT NULL
   ,UNIQUE (merchant_serial, webhooks_id)
   );
 COMMENT ON TABLE merchant_webhooks
@@ -63,14 +62,12 @@ COMMENT ON COLUMN merchant_webhooks.event_type
   IS 'Event of the webhooks';
 COMMENT ON COLUMN merchant_webhooks.url
   IS 'URL use by the customer';
-COMMENT ON COLUMN merchant_webhooks.methods
-  IS 'Methods use by the merchant';
+COMMENT ON COLUMN merchant_webhooks.http_method
+  IS 'http method use by the merchant';
 COMMENT ON COLUMN merchant_webhooks.header_template
   IS 'Header of the webhooks';
 COMMENT ON COLUMN merchant_webhooks.body_template
   IS 'Body of the webhooks';
-COMMENT ON COLUMN merchant_webhooks.merchant_instance
-  IS 'Information of the merchant';
 
 COMMIT;
 

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