-- Migration: Ajouter les champs manquants à convention_specifique
-- Date: 2025-11-11
-- Description: Ajoute delai_realisation_mois, vice_president_crcs_id, president_commission_permanente_id à convention_specifique

ALTER TABLE `convention_specifique` 
ADD COLUMN `delai_realisation_mois` DECIMAL(5, 2) NULL DEFAULT NULL COMMENT "Délai de réalisation en mois" AFTER `nature`,
ADD COLUMN `vice_president_crcs_id` INT NULL DEFAULT NULL COMMENT "ID du Vice-Président CRCS" AFTER `delai_realisation_mois`,
ADD COLUMN `president_commission_permanente_id` INT NULL DEFAULT NULL COMMENT "ID du Président de la Commission Permanente" AFTER `vice_president_crcs_id`;

-- Ajouter les index et contraintes
ALTER TABLE `convention_specifique`
ADD INDEX `idx_vice_president` (`vice_president_crcs_id` ASC) USING BTREE,
ADD INDEX `idx_president_commission` (`president_commission_permanente_id` ASC) USING BTREE,
ADD CONSTRAINT `convention_specifique_ibfk_5` FOREIGN KEY (`vice_president_crcs_id`) REFERENCES `partenaires` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
ADD CONSTRAINT `convention_specifique_ibfk_6` FOREIGN KEY (`president_commission_permanente_id`) REFERENCES `partenaires` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT;