diff options
author | priscilla <priscilla.huang@efrei.net> | 2022-11-25 05:48:03 -0500 |
---|---|---|
committer | priscilla <priscilla.huang@efrei.net> | 2022-11-25 05:48:03 -0500 |
commit | f6492a1e124bb71bd8082ffc1e07d6a663c81393 (patch) | |
tree | d3e15c6343eee6b533a8107adb2ea62cb0b7aacc | |
parent | 2c0f428f9c2c551b5825bb81600ab436e966f7d7 (diff) | |
download | merchant-f6492a1e124bb71bd8082ffc1e07d6a663c81393.tar.gz merchant-f6492a1e124bb71bd8082ffc1e07d6a663c81393.tar.bz2 merchant-f6492a1e124bb71bd8082ffc1e07d6a663c81393.zip |
webhook sql
-rw-r--r-- | src/backenddb/merchant-0004.sql | 13 |
1 files 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; |