Blame · Line-by-line history

`0076_push_subscriptions.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.

0076_push_subscriptions.sqlBlame15 lines · 1 contributor

a2b3e99Claude	1	-- Block M2 addendum — extra push-preference columns for the four new
	2	-- notification kinds surfaced by src/routes/push-notifications.tsx:
	3	-- deploy_success → notify_push_on_deploy_success
	4	-- pr_merged → notify_push_on_pr_merged
	5	-- ai_review → notify_push_on_ai_review
	6	-- gate_failed → notify_push_on_gate_failed
	7	--
	8	-- Strictly additive. No existing table or column is touched.
	9	-- The push_subscriptions table itself already exists (drizzle/0043).
	10
	11	ALTER TABLE "users"
	12	ADD COLUMN IF NOT EXISTS "notify_push_on_deploy_success" boolean NOT NULL DEFAULT true,
	13	ADD COLUMN IF NOT EXISTS "notify_push_on_pr_merged" boolean NOT NULL DEFAULT true,
	14	ADD COLUMN IF NOT EXISTS "notify_push_on_ai_review" boolean NOT NULL DEFAULT true,
	15	ADD COLUMN IF NOT EXISTS "notify_push_on_gate_failed" boolean NOT NULL DEFAULT true;