-- Ajouter les colonnes de configuration des tests à v2_calendar_settings
-- Exécuter ce script sur la base de données

ALTER TABLE v2_calendar_settings 
    -- Configuration Test Phase
    ADD COLUMN phase_test_question_count INT DEFAULT 10,
    ADD COLUMN phase_test_time_minutes INT DEFAULT 30,
    ADD COLUMN phase_test_passing_score DECIMAL(5,2) DEFAULT 60.00,
    
    -- Configuration Test Niveau  
    ADD COLUMN level_test_question_count INT DEFAULT 15,
    ADD COLUMN level_test_time_minutes INT DEFAULT 45,
    ADD COLUMN level_test_passing_score DECIMAL(5,2) DEFAULT 60.00,
    
    -- Configuration Examen Final
    ADD COLUMN final_exam_question_count INT DEFAULT 20,
    ADD COLUMN final_exam_time_minutes INT DEFAULT 60,
    ADD COLUMN final_exam_passing_score DECIMAL(5,2) DEFAULT 70.00;
