Ctrl K
ComunidadGuías…

drizzle/0083_default_monitor_notifications_manual.sql

Rama main · réplica de lectura del repositorio original.

Archivo original ↗Preguntar a KiBot
ALTER TABLE public.user_settings
  ADD COLUMN IF NOT EXISTS default_monitor_notification_pref varchar(16) NOT NULL DEFAULT 'both';

UPDATE public.user_settings
SET default_monitor_notification_pref = 'both'
WHERE default_monitor_notification_pref NOT IN ('email', 'telegram', 'both', 'none');

ALTER TABLE public.monitors
  ALTER COLUMN notification_pref SET DEFAULT 'both',
  ALTER COLUMN publish_on_status_page SET DEFAULT true;