Blame · Line-by-line history

`0093_incident_hooks.sql`

Each line is annotated with the commit that last touched it. Click any SHA to jump to that commit and see the surrounding change.

0093_incident_hooks.sqlBlame10 lines · 1 contributor

70e3293Claude	1	-- Migration 0077: Incident hook configs for PagerDuty/Datadog/Opsgenie/generic
	2	CREATE TABLE IF NOT EXISTS incident_hook_configs (
	3	id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
	4	user_id uuid NOT NULL REFERENCES users(id) ON DELETE CASCADE,
	5	repo_id uuid NOT NULL REFERENCES repositories(id) ON DELETE CASCADE,
	6	provider text NOT NULL, -- 'pagerduty' \| 'datadog' \| 'opsgenie' \| 'generic'
	7	secret_hash text NOT NULL, -- SHA-256 of the webhook secret for HMAC validation
	8	created_at timestamp DEFAULT now(),
	9	UNIQUE(repo_id, provider)
	10	);