-- PR-C.1 (May 2026): drop dead Monitor.auth* columns
-- =========================================================
-- The four columns below were declared in the initial schema but
-- never wired into the HTTP probe strategy. A grep across src/ on
-- 2026-05-22 showed zero references — no API route writes them, no
-- monitor strategy reads them. They are pure dead schema, the kind
-- the May 2026 review flagged as a buyer-facing tell ("project ran
-- ahead of itself").
--
-- Drop is safe on EA's deployment because every row has authMethod
-- defaulted to 'none' and the *Enc columns are NULL.
--
-- Operator: run UP at maintenance time. If you decide later to ship
-- HTTP basic/bearer auth, re-add the columns via DOWN and a new UP
-- that wires them into HttpMonitorStrategy.

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

ALTER TABLE `Monitor`
  DROP COLUMN `authMethod`,
  DROP COLUMN `authUsername`,
  DROP COLUMN `authPasswordEnc`,
  DROP COLUMN `authTokenEnc`;

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

ALTER TABLE `Monitor`
  ADD COLUMN `authMethod` VARCHAR(191) NOT NULL DEFAULT 'none',
  ADD COLUMN `authUsername` VARCHAR(191) NULL,
  ADD COLUMN `authPasswordEnc` TEXT NULL,
  ADD COLUMN `authTokenEnc` TEXT NULL;