serendipty01.dev
forked from
smokesignal.events/smokesignal
The smokesignal.events web application
1-- Add RSVP redirect settings to events table
2-- Allows organizers to redirect users to external ticketing systems instead of direct RSVPs
3
4ALTER TABLE events
5ADD COLUMN disable_direct_rsvp BOOLEAN NOT NULL DEFAULT false,
6ADD COLUMN rsvp_redirect_url TEXT;
7
8-- Add constraint for URL requirement when redirect is enabled
9ALTER TABLE events
10ADD CONSTRAINT check_rsvp_redirect_url
11CHECK (
12 disable_direct_rsvp = false
13 OR (disable_direct_rsvp = true AND rsvp_redirect_url IS NOT NULL AND rsvp_redirect_url != '')
14);