-- Migration: Suppression du champ type de la table presidents_commissions
-- Date: 2025-01-XX
-- Description: Supprime le champ type qui n'est plus nécessaire

SET @dbname = DATABASE();
SET @tablename = 'presidents_commissions';
SET @column = 'type';

-- Vérifier si la colonne existe et la supprimer
SET @preparedStatement = (SELECT IF(
  (
    SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
    WHERE
      (TABLE_SCHEMA = @dbname)
      AND (TABLE_NAME = @tablename)
      AND (COLUMN_NAME = @column)
  ) > 0,
  CONCAT('ALTER TABLE `', @tablename, '` DROP COLUMN `', @column, '`;'),
  'SELECT "La colonne type n\'existe pas." AS message;'
));
PREPARE alterIfExists FROM @preparedStatement;
EXECUTE alterIfExists;
DEALLOCATE PREPARE alterIfExists;

-- Supprimer l'index idx_type s'il existe
SET @indexName = 'idx_type';
SET @preparedStatement2 = (SELECT IF(
  (
    SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS
    WHERE
      (TABLE_SCHEMA = @dbname)
      AND (TABLE_NAME = @tablename)
      AND (INDEX_NAME = @indexName)
  ) > 0,
  CONCAT('ALTER TABLE `', @tablename, '` DROP INDEX `', @indexName, '`;'),
  'SELECT "L\'index idx_type n\'existe pas." AS message;'
));
PREPARE dropIndexIfExists FROM @preparedStatement2;
EXECUTE dropIndexIfExists;
DEALLOCATE PREPARE dropIndexIfExists;