-- EA-6 / PR-37: lower Monitor.retries default from 3 to 2
-- =========================================================
-- The `retries` column already drives the engine's consecutive-failure
-- threshold (read as `requiredDowns` in src/lib/monitor-engine.ts).
-- The previous default of 3 was overly conservative: on a 60s probe
-- interval it suppressed real alerts for ~3 minutes. 2 catches single
-- transient blips without paging on them while surfacing real outages
-- within 2 × intervalSeconds.
--
-- Only the DEFAULT changes. Existing rows keep whatever value they
-- have. Operators who explicitly set 3 stay at 3.

-- ============================================================
-- UP
-- ============================================================

ALTER TABLE `Monitor`
  ALTER COLUMN `retries` SET DEFAULT 2;

-- ============================================================
-- DOWN
-- ============================================================

ALTER TABLE `Monitor`
  ALTER COLUMN `retries` SET DEFAULT 3;