-- Add bib_performing column to event_heat_settings table
-- This stores the BIB number of the participant who is currently performing

ALTER TABLE event_heat_settings 
ADD COLUMN bib_performing INT DEFAULT NULL AFTER bib_latest_on_run;

-- Add comment to document the column
ALTER TABLE event_heat_settings 
MODIFY COLUMN bib_performing INT DEFAULT NULL COMMENT 'BIB number of participant currently performing';
