-- Migration: Add rank_time_seconds to rankings table
-- Date: 2026-04-01

ALTER TABLE `rankings` ADD COLUMN `rank_time_seconds` INT DEFAULT NULL COMMENT 'Elapsed time in seconds for this stage ranking';

-- Add index for performance on view queries
ALTER TABLE `rankings` ADD INDEX `idx_stage_id_time` (`stage_id`, `rank_time_seconds`);
