diff options
Diffstat (limited to 'src/backenddb/merchant-0004.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; |