-- Module coming_soon status, football predictions plans, remove sure_odds hub

ALTER TABLE modules
  MODIFY status ENUM('enabled','disabled','maintenance','coming_soon') NOT NULL DEFAULT 'disabled';

ALTER TABLE subscription_plans
  MODIFY plan_type ENUM('general','sure_odds','football','casino','forex','ads','surveys') NOT NULL DEFAULT 'general';

UPDATE subscription_plans SET plan_type = 'football' WHERE plan_type = 'sure_odds';

UPDATE modules SET status = 'disabled', description = 'Removed — use Football Center predictions'
  WHERE slug = 'sure_odds';

INSERT IGNORE INTO subscription_plans (plan_code, name, plan_type, price, duration_days, perks_json, status) VALUES
('football_weekly', 'Predictions Weekly', 'football', 12000, 7, '{}', 'active'),
('football_monthly', 'Predictions Monthly', 'football', 40000, 30, '{}', 'active'),
('casino_weekly', 'Casino Access Weekly', 'casino', 15000, 7, '{}', 'active'),
('casino_monthly', 'Casino Access Monthly', 'casino', 45000, 30, '{}', 'active'),
('surveys_weekly', 'Surveys Weekly', 'surveys', 8000, 7, '{}', 'active');

UPDATE modules SET description = 'Live scores, analytics & premium predictions' WHERE slug = 'football';