-- Add flow_position_range column to event_heat_settings
-- This allows specifying which positions from source heat flow to this heat
-- Format: "1-3" (positions 1 to 3), "4-8" (positions 4 to 8), etc.

ALTER TABLE `event_heat_settings` 
ADD COLUMN `flow_position_range` VARCHAR(50) DEFAULT NULL 
COMMENT 'Position range from source heat (e.g., "1-3", "4-8")' 
AFTER `flow_participants_per_category`;
