max / makenotwork

371 B · 8 lines History Blame Raw

1	-- I4: Content Newsletter Emails
2	-- Items: web_only flag (publish without emailing subscribers)
3	ALTER TABLE items ADD COLUMN web_only BOOLEAN NOT NULL DEFAULT false;
4
5	-- Blog posts: web_only flag + idempotent announcement guard
6	ALTER TABLE blog_posts ADD COLUMN web_only BOOLEAN NOT NULL DEFAULT false;
7	ALTER TABLE blog_posts ADD COLUMN release_announced_at TIMESTAMPTZ;
8