Skip to main content

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