max / makenotwork

528 B · 9 lines History Blame Raw

1	-- Scheduled publish: allow creators to schedule items and blog posts for future publication.
2
3	ALTER TABLE items ADD COLUMN publish_at TIMESTAMPTZ;
4	ALTER TABLE blog_posts ADD COLUMN publish_at TIMESTAMPTZ;
5
6	-- Partial indexes for efficient scheduler polling (only unpublished items with a schedule)
7	CREATE INDEX idx_items_publish_at ON items (publish_at) WHERE publish_at IS NOT NULL AND is_public = false;
8	CREATE INDEX idx_blog_posts_publish_at ON blog_posts (publish_at) WHERE publish_at IS NOT NULL AND published_at IS NULL;
9