50 lines
1.2 KiB
SQL
50 lines
1.2 KiB
SQL
-- MSIN-4468 — Message de validation de la quantité totale
|
|
-- À exécuter avec le déploiement de l'édition de la quantité totale dans la gestion des dossards.
|
|
-- Idempotent; ajoute uniquement les libellés FR/EN absents pour compte.php.
|
|
|
|
INSERT INTO info (
|
|
info_clef,
|
|
info_langue,
|
|
info_texte,
|
|
info_aide,
|
|
info_prg,
|
|
info_description,
|
|
info_trie,
|
|
info_actif,
|
|
info_option1,
|
|
info_option2,
|
|
info_option3,
|
|
info_creation
|
|
)
|
|
SELECT
|
|
src.info_clef,
|
|
src.info_langue,
|
|
src.info_texte,
|
|
'',
|
|
'compte.php',
|
|
'MSIN-4468',
|
|
0,
|
|
1,
|
|
'',
|
|
'',
|
|
'',
|
|
NOW()
|
|
FROM (
|
|
SELECT
|
|
'bib_v5_qte_total_min' AS info_clef,
|
|
'fr' AS info_langue,
|
|
'Quantité refusée : le total doit être d''au moins %d, soit le nombre d''inscriptions déjà vendues.' AS info_texte
|
|
UNION ALL
|
|
SELECT
|
|
'bib_v5_qte_total_min',
|
|
'en',
|
|
'Quantity rejected: the total must be at least %d, which is the number of registrations already sold.'
|
|
) src
|
|
WHERE NOT EXISTS (
|
|
SELECT 1
|
|
FROM info current_info
|
|
WHERE current_info.info_clef = src.info_clef
|
|
AND current_info.info_langue = src.info_langue
|
|
AND current_info.info_prg = 'compte.php'
|
|
);
|