-- Remediation: 0046 was recorded in _drizzle_migrations but was missing from
-- _journal.json, so its ALTER TYPE never executed on production.
-- This migration adds 'nba_bracket' to the simulator_type enum idempotently.
DO $$ BEGIN
  IF NOT EXISTS (
    SELECT 1 FROM pg_enum
    WHERE enumlabel = 'nba_bracket'
      AND enumtypid = (SELECT oid FROM pg_type WHERE typname = 'simulator_type')
  ) THEN
    ALTER TYPE "public"."simulator_type" ADD VALUE 'nba_bracket';
  END IF;
END $$;
