30 lines
1.9 KiB
SQL
30 lines
1.9 KiB
SQL
-- MSIN-4459 — Liste inscriptions : 1 ligne / participant ; dossard ≠ no_equipe
|
|
-- Prérequis : aucun
|
|
-- Idempotent (DELETE + INSERT). Compte.php (contexte AJAX / fiche gestion).
|
|
|
|
DELETE FROM info
|
|
WHERE info_prg = 'compte.php'
|
|
AND info_clef IN (
|
|
'inscr_gestion_list_team_name',
|
|
'inscr_gestion_list_teammate',
|
|
'inscr_gestion_list_team_no',
|
|
'inscr_gestion_list_team_no_label',
|
|
'inscr_gestion_list_team_name_label',
|
|
'inscr_gestion_rech_bib_equipe',
|
|
'inscr_gestion_col_dossard'
|
|
);
|
|
|
|
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) VALUES
|
|
('inscr_gestion_list_team_name', 'fr', 'Équipe : %s', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_list_team_name', 'en', 'Team: %s', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_list_teammate', 'fr', 'Coéquipier', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_list_teammate', 'en', 'Teammate', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_list_team_no_label', 'fr', 'No d\'équipe', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_list_team_no_label', 'en', 'Team no.', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_list_team_name_label', 'fr', 'Nom d\'équipe', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_list_team_name_label', 'en', 'Team name', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_rech_bib_equipe', 'fr', 'Dossard', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_rech_bib_equipe', 'en', 'Bib', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_col_dossard', 'fr', 'Dossard', '', 'compte.php', '', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_col_dossard', 'en', 'Bib', '', 'compte.php', '', 0, 1, '', '', '', NOW());
|