-- Add checkpoint_id and decision_method to ranking_records
-- checkpoint_id links an AI record to the exact checkpoint where the crossing occurred
-- decision_method records which signal (OCR / face / ReID / fusion) resolved the runner

ALTER TABLE `ranking_records`
    ADD COLUMN `checkpoint_id` VARCHAR(36) NULL AFTER `bib_number`,
    ADD COLUMN `decision_method` VARCHAR(32) NULL AFTER `validation_notes`,
    ADD INDEX `idx_rr_checkpoint` (`checkpoint_id`);
