max / makenotwork

547 B · 13 lines History Blame Raw

1	-- Phase 11: Email Notifications
2	-- Notification preferences, broadcast rate limiting, release announcement tracking.
3
4	-- Notification preferences (creator-facing)
5	ALTER TABLE users ADD COLUMN notify_sale BOOLEAN NOT NULL DEFAULT true;
6	ALTER TABLE users ADD COLUMN notify_follower BOOLEAN NOT NULL DEFAULT true;
7
8	-- Broadcast rate limiting
9	ALTER TABLE users ADD COLUMN last_broadcast_at TIMESTAMPTZ;
10
11	-- Release announcement tracking (prevents re-announcement on unpublish/republish)
12	ALTER TABLE items ADD COLUMN release_announced_at TIMESTAMPTZ;
13