-- スプレッドシート比較: 堅実2番手（〇対抗）列を追加
USE keiba_ai;

ALTER TABLE sheet_forecast_compare
    ADD COLUMN ai_rank2_umaban TINYINT UNSIGNED DEFAULT NULL AFTER ai_rank1_score,
    ADD COLUMN ai_rank2_name VARCHAR(128) DEFAULT NULL AFTER ai_rank2_umaban,
    ADD COLUMN ai_rank2_score DECIMAL(8,2) DEFAULT NULL AFTER ai_rank2_name,
    ADD COLUMN match_ai_rank2_winner TINYINT(1) DEFAULT NULL COMMENT '1=AI堅実2位(〇)が1着' AFTER match_ai_rank1_winner,
    ADD COLUMN match_ai_rank2_honmei TINYINT(1) DEFAULT NULL COMMENT '1=AI堅実2位(〇)=sheet本命' AFTER match_ai_rank1_honmei;
