-- MSIN-4379 — Étape 1 / i18n bib v4
-- Mode équipe (colonne gauche) + libellés replier/développer les blocs.
--
-- IMPORTANT : aucun DELETE. N'écrase pas vos textes déjà en BD.
-- Chaque INSERT ne s'exécute que si la clé n'existe pas encore.
-- info_prg = compte.php

-- bib_v4_team_mode_title
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 'bib_v4_team_mode_title', 'fr', 'Méthode d''assignation', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_team_mode_title' AND info_langue = 'fr' AND info_prg = '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 'bib_v4_team_mode_title', 'en', 'Assignment method', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_team_mode_title' AND info_langue = 'en' AND info_prg = 'compte.php'
);

-- bib_v4_team_mode_individual
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 'bib_v4_team_mode_individual', 'fr', 'Dossards individuels', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_team_mode_individual' AND info_langue = 'fr' AND info_prg = '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 'bib_v4_team_mode_individual', 'en', 'Individual bibs', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_team_mode_individual' AND info_langue = 'en' AND info_prg = 'compte.php'
);

-- bib_v4_team_mode_one_team
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 'bib_v4_team_mode_one_team', 'fr', '1 équipe = 1 dossard', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_team_mode_one_team' AND info_langue = 'fr' AND info_prg = '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 'bib_v4_team_mode_one_team', 'en', '1 team = 1 bib', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_team_mode_one_team' AND info_langue = 'en' AND info_prg = 'compte.php'
);

-- bib_v4_collapse
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 'bib_v4_collapse', 'fr', 'Réduire la section', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_collapse' AND info_langue = 'fr' AND info_prg = '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 'bib_v4_collapse', 'en', 'Collapse section', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_collapse' AND info_langue = 'en' AND info_prg = 'compte.php'
);

-- bib_v4_expand
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 'bib_v4_expand', 'fr', 'Développer la section', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_expand' AND info_langue = 'fr' AND info_prg = '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 'bib_v4_expand', 'en', 'Expand section', '', 'compte.php', '', 0, 1, '', '', '', NOW()
FROM DUAL
WHERE NOT EXISTS (
    SELECT 1 FROM info WHERE info_clef = 'bib_v4_expand' AND info_langue = 'en' AND info_prg = 'compte.php'
);
