-- Add validation status to ranking_records
-- Records can be saved for logging even if they don't match a valid participant
-- Only valid records (is_valid = 1) will be used in ranking calculations

ALTER TABLE `ranking_records` ADD COLUMN `is_valid` INTEGER NOT NULL DEFAULT 1;
ALTER TABLE `ranking_records` ADD COLUMN `validation_notes` TEXT DEFAULT NULL;
