27 lines
972 B
SQL
27 lines
972 B
SQL
|
-- +goose Up
|
||
|
|
-- +goose StatementBegin
|
||
|
|
CREATE TABLE autoscan_webhook_deliveries (
|
||
|
|
id bigserial PRIMARY KEY,
|
||
|
|
source_id uuid NOT NULL
|
||
|
|
REFERENCES autoscan_sources(id) ON DELETE CASCADE,
|
||
|
|
provider_event_type text NOT NULL,
|
||
|
|
changes jsonb NOT NULL,
|
||
|
|
received_at timestamptz NOT NULL,
|
||
|
|
attempt_count integer NOT NULL DEFAULT 1,
|
||
|
|
next_attempt_at timestamptz NOT NULL DEFAULT now(),
|
||
|
|
locked_at timestamptz,
|
||
|
|
locked_by text NOT NULL DEFAULT '',
|
||
|
|
last_error text NOT NULL DEFAULT '',
|
||
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
||
|
|
updated_at timestamptz NOT NULL DEFAULT now()
|
||
|
|
);
|
||
|
|
|
||
|
|
CREATE INDEX idx_autoscan_webhook_deliveries_due
|
||
|
|
ON autoscan_webhook_deliveries (next_attempt_at, id);
|
||
|
|
-- +goose StatementEnd
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- +goose StatementBegin
|
||
|
|
DROP TABLE autoscan_webhook_deliveries;
|
||
|
|
-- +goose StatementEnd
|