27 lines
824 B
SQL
27 lines
824 B
SQL
-- MSIN-4401 — Kit : forcer sections fiche inscriptions ouvertes
|
|
-- Prérequis : inscriptions_eve_roles (accès v2)
|
|
-- Notes prod : idempotent (ajoute la colonne seulement si absente)
|
|
|
|
SET NAMES utf8mb4;
|
|
|
|
SET @col_exists := (
|
|
SELECT COUNT(*)
|
|
FROM information_schema.COLUMNS
|
|
WHERE TABLE_SCHEMA = DATABASE()
|
|
AND TABLE_NAME = 'inscriptions_eve_roles'
|
|
AND COLUMN_NAME = 'role_fiche_sections_open'
|
|
);
|
|
|
|
SET @sql := IF(
|
|
@col_exists = 0,
|
|
'ALTER TABLE `inscriptions_eve_roles`
|
|
ADD COLUMN `role_fiche_sections_open` tinyint(1) unsigned NOT NULL DEFAULT 0
|
|
COMMENT ''MSIN-4401 — 1 = toutes les sections de la fiche inscriptions ouvertes''
|
|
AFTER `role_grants_all`',
|
|
'SELECT ''role_fiche_sections_open already exists'' AS info'
|
|
);
|
|
|
|
PREPARE stmt FROM @sql;
|
|
EXECUTE stmt;
|
|
DEALLOCATE PREPARE stmt;
|