Skip to content

Modern Docker Management, Designed for Everyone

810 B
Raw Blame
-- +goose Up
CREATE TABLE IF NOT EXISTS webhooks (
    id               TEXT PRIMARY KEY,
    name             TEXT NOT NULL,
    token_hash       TEXT NOT NULL UNIQUE,
    token_prefix     TEXT NOT NULL,
    target_type      TEXT NOT NULL,
    action_type      TEXT NOT NULL DEFAULT '',
    target_id        TEXT NOT NULL,
    target_ref       TEXT NOT NULL DEFAULT '',
    environment_id   TEXT NOT NULL DEFAULT '',
    enabled          INTEGER NOT NULL DEFAULT 1,
    last_triggered_at DATETIME,
    created_at       DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at       DATETIME
);

CREATE INDEX IF NOT EXISTS idx_webhooks_token_prefix ON webhooks(token_prefix);
CREATE INDEX IF NOT EXISTS idx_webhooks_environment_id ON webhooks(environment_id);

-- +goose Down
DROP TABLE IF EXISTS webhooks;