-- Add halftime score columns to soccer_results table
-- This enables proper payout calculation for halftime markets

ALTER TABLE soccer_results 
ADD COLUMN home_halftime_goals INT DEFAULT NULL AFTER home_goals,
ADD COLUMN away_halftime_goals INT DEFAULT NULL AFTER away_goals;

-- Add index for faster queries
ALTER TABLE soccer_results 
ADD INDEX idx_halftime_scores (fixture_id, home_halftime_goals, away_halftime_goals);
