9 lines
398 B
SQL
9 lines
398 B
SQL
-- Weekly Digest Email Preferences Migration for BroadcastBeat
|
|
-- Adds weekly_digest_enabled opt-in column to user_profiles
|
|
|
|
-- ============================================================
|
|
-- 1. ADD WEEKLY DIGEST PREFERENCE COLUMN
|
|
-- ============================================================
|
|
ALTER TABLE public.user_profiles
|
|
ADD COLUMN IF NOT EXISTS weekly_digest_enabled BOOLEAN DEFAULT false;
|