merchant

commit f6492a1e124bb71bd8082ffc1e07d6a663c81393
parent 2c0f428f9c2c551b5825bb81600ab436e966f7d7
Author: priscilla <priscilla.huang@efrei.net>
Date:   Fri, 25 Nov 2022 05:48:03 -0500

webhook sql

Diffstat:
M
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
@@ -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;