-- Migration 941: v0.10.5 — Notification preferences defaults
-- Par défaut : push_message et push_follow activés ; likes/commentaires/mentions désactivés (anti-FOMO)

ALTER TABLE notification_preferences
  ALTER COLUMN push_follow SET DEFAULT true,
  ALTER COLUMN push_message SET DEFAULT true,
  ALTER COLUMN push_like SET DEFAULT false,
  ALTER COLUMN push_comment SET DEFAULT false,
  ALTER COLUMN push_mention SET DEFAULT false;

COMMENT ON COLUMN notification_preferences.push_follow IS 'v0.10.5: default true — new followers';
COMMENT ON COLUMN notification_preferences.push_message IS 'v0.10.5: default true — direct messages';
COMMENT ON COLUMN notification_preferences.push_like IS 'v0.10.5: default false — engagement (opt-in)';
COMMENT ON COLUMN notification_preferences.push_comment IS 'v0.10.5: default false — engagement (opt-in)';
COMMENT ON COLUMN notification_preferences.push_mention IS 'v0.10.5: default false — mentions (opt-in)';