max / makenotwork

471 B · 12 lines History Blame Raw

1	-- Email bounce/complaint suppression list + release announcement opt-in
2
3	CREATE TABLE email_suppressions (
4	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
5	email TEXT NOT NULL,
6	reason TEXT NOT NULL, -- 'HardBounce', 'SpamComplaint'
7	created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
8	);
9	CREATE UNIQUE INDEX idx_email_suppressions_email ON email_suppressions (LOWER(email));
10
11	ALTER TABLE users ADD COLUMN notify_release BOOLEAN NOT NULL DEFAULT true;
12