migrations/20251103000000_identity_notifications.sql at main

serendipty01.dev / smokesignal

forked from smokesignal.events/smokesignal

fork atom

The smokesignal.events web application

fork atom

smokesignal / migrations / 20251103000000_identity_notifications.sql

at main 14 lines 592 B view raw

wrap content

Nick Gerakines feature: email 4mo ago

5513454d

 1-- Create identity_notifications table for user notification preferences
 2CREATE TABLE identity_notifications (
 3    did TEXT PRIMARY KEY,
 4    email TEXT DEFAULT NULL,
 5    confirmed_at TIMESTAMPTZ DEFAULT NULL,
 6    email_on_rsvp BOOLEAN NOT NULL DEFAULT false,
 7    email_on_event_change BOOLEAN NOT NULL DEFAULT false,
 8    email_on_24h BOOLEAN NOT NULL DEFAULT false,
 9    created_at TIMESTAMPTZ NOT NULL,
10    updated_at TIMESTAMPTZ NOT NULL
11);
12
13-- Create index on email for webhook lookups
14CREATE INDEX idx_identity_notifications_email ON identity_notifications(email) WHERE email IS NOT NULL;