Blame · Line-by-line history

`0024_email_digest.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.

0024_email_digest.sqlBlame13 lines · 1 contributor

08420cdClaude	1	-- Gluecron migration 0024: Weekly email digest preference.
	2	--
	3	-- I7 — Opt-in weekly digest. Adds a single boolean column to `users` + a
	4	-- companion `last_digest_sent_at` timestamp so the cron job can skip users
	5	-- who've already received this week's digest (idempotent re-runs).
	6
	7	--> statement-breakpoint
	8	ALTER TABLE "users"
	9	ADD COLUMN IF NOT EXISTS "notify_email_digest_weekly" boolean NOT NULL DEFAULT false;
	10
	11	--> statement-breakpoint
	12	ALTER TABLE "users"
	13	ADD COLUMN IF NOT EXISTS "last_digest_sent_at" timestamp;