diff options
Diffstat (limited to 'src/backenddb/merchant-0004.sql')
-rw-r--r-- | src/backenddb/merchant-0004.sql | 93 |
1 files changed, 6 insertions, 87 deletions
diff --git a/src/backenddb/merchant-0004.sql b/src/backenddb/merchant-0004.sql index 55cfa2fc..711026a2 100644 --- a/src/backenddb/merchant-0004.sql +++ b/src/backenddb/merchant-0004.sql @@ -1,6 +1,6 @@ -- -- This file is part of TALER --- Copyright (C) 2022-2023 Taler Systems SA +-- Copyright (C) 2024 Taler Systems SA -- -- TALER is free software; you can redistribute it and/or modify it under the -- terms of the GNU General Public License as published by the Free Software @@ -14,98 +14,17 @@ -- TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/> -- - --- @file merchant-0004.sql --- @brief database helper functions for postgres used by the merchant and function for plugin_merchantdb_postgres.c --- @author Priscilla Huang - - BEGIN; -- Check patch versioning is in place. SELECT _v.register_patch('merchant-0004', NULL, NULL); SET search_path TO merchant; --- create table here! - -CREATE TABLE IF NOT EXISTS merchant_template - (template_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY - ,merchant_serial BIGINT NOT NULL - REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE - ,template_id VARCHAR NOT NULL - ,template_description VARCHAR NOT NULL - ,image BYTEA - ,template_contract VARCHAR NOT NULL -- in JSON format - ,UNIQUE (merchant_serial, template_id) - ); -COMMENT ON TABLE merchant_template - IS 'template used by the merchant (may be incomplete, frontend can override)'; -COMMENT ON COLUMN merchant_template.template_description - IS 'Human-readable template description'; -COMMENT ON COLUMN merchant_template.image - IS 'NOT NULL, but can be 0 bytes; must contain an ImageDataUrl'; -COMMENT ON COLUMN merchant_template.template_contract - IS 'The template contract will contains some additional information.'; - - -CREATE TABLE IF NOT EXISTS merchant_webhook - (webhook_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY - ,merchant_serial BIGINT NOT NULL - REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE - ,webhook_id VARCHAR NOT NULL - ,event_type VARCHAR NOT NULL - ,url VARCHAR NOT NULL - ,http_method VARCHAR NOT NULL - ,header_template VARCHAR - ,body_template VARCHAR - ,UNIQUE (merchant_serial, webhook_id) - ); -COMMENT ON TABLE merchant_webhook - IS 'webhook used by the merchant (may be incomplete, frontend can override)'; -COMMENT ON COLUMN merchant_webhook.event_type - IS 'Event of the webhook'; -COMMENT ON COLUMN merchant_webhook.url - IS 'URL to make the request to'; -COMMENT ON COLUMN merchant_webhook.http_method - IS 'http method use by the merchant'; -COMMENT ON COLUMN merchant_webhook.header_template - IS 'Template for the header of the webhook, to be modified based on trigger data'; -COMMENT ON COLUMN merchant_webhook.body_template - IS 'Template for the body of the webhook, to be modified based on trigger data'; - - -CREATE TABLE IF NOT EXISTS merchant_pending_webhooks - (webhook_pending_serial BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY - ,merchant_serial BIGINT NOT NULL - REFERENCES merchant_instances (merchant_serial) ON DELETE CASCADE - ,webhook_serial BIGINT NOT NULL - REFERENCES merchant_webhook (webhook_serial) ON DELETE CASCADE - ,next_attempt INT8 NOT NULL DEFAULT(0) - ,retries INT4 NOT NULL DEFAULT(0) - ,url VARCHAR NOT NULL - ,http_method VARCHAR NOT NULL - ,header VARCHAR - ,body VARCHAR - ,UNIQUE (merchant_serial, webhook_pending_serial) - ); -COMMENT ON TABLE merchant_pending_webhooks - IS 'webhooks that still need to be executed by the merchant'; -COMMENT ON COLUMN merchant_pending_webhooks.url - IS 'URL to make the request to'; -COMMENT ON COLUMN merchant_pending_webhooks.webhook_serial - IS 'Reference to the configured webhook template'; -COMMENT ON COLUMN merchant_pending_webhooks.retries - IS 'How often have we tried this request so far'; -COMMENT ON COLUMN merchant_pending_webhooks.next_attempt - IS 'Time when we should make the next request to the webhook'; -COMMENT ON COLUMN merchant_pending_webhooks.http_method - IS 'http method use for the webhook'; -COMMENT ON COLUMN merchant_pending_webhooks.header - IS 'Header of the webhook'; -COMMENT ON COLUMN merchant_pending_webhooks.body - IS 'Body of the webhook'; +DROP TABLE merchant_reward_pickup_signatures; +DROP TABLE merchant_reward_pickups; +DROP TABLE merchant_rewards; +DROP TABLE merchant_reward_reserve_keys; +DROP TABLE merchant_reward_reserves; COMMIT; - - |