-- Phase 1 / Migration 1
-- Additive columns for rm_forecast_cache_v2
-- Pre-check:
-- SELECT column_name FROM information_schema.columns
-- WHERE table_name = 'rm_forecast_cache_v2'
--   AND column_name IN ('narrative_metadata', 'is_minor_league');
-- Post-check:
-- SELECT column_name, data_type, column_default FROM information_schema.columns
-- WHERE table_name = 'rm_forecast_cache_v2'
--   AND column_name IN ('narrative_metadata', 'is_minor_league');
-- Rollback:
-- ALTER TABLE rm_forecast_cache_v2 DROP COLUMN IF EXISTS narrative_metadata;
-- ALTER TABLE rm_forecast_cache_v2 DROP COLUMN IF EXISTS is_minor_league;

ALTER TABLE rm_forecast_cache_v2
  ADD COLUMN IF NOT EXISTS narrative_metadata jsonb DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS is_minor_league boolean DEFAULT false;
