-- MSIN-4379 — Libellé « annulé » dans la vue liste des dossards

SELECT 'bib_v4_view_cancelled', 'fr', 'Annulé', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_view_cancelled' AND info_langue = 'fr' AND info_prg = 'compte.php');

SELECT 'bib_v4_view_cancelled', 'en', 'Cancelled', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM info WHERE info_clef = 'bib_v4_view_cancelled' AND info_langue = 'en' AND info_prg = 'compte.php');

-- Correction si la clé existe mais affiche le nom technique ou un texte vide
UPDATE info SET info_texte = 'Annulé', info_actif = 1
WHERE info_clef = 'bib_v4_view_cancelled' AND info_langue = 'fr' AND info_prg = 'compte.php';

UPDATE info SET info_texte = 'Cancelled', info_actif = 1
WHERE info_clef = 'bib_v4_view_cancelled' AND info_langue = 'en' AND info_prg = 'compte.php';
