74 lines
4.9 KiB
SQL
74 lines
4.9 KiB
SQL
-- MSIN-4464 — Droit kit « voir historique fiche » + libellés Info (popup !)
|
|
-- Prérequis : sql/MSIN-4464-fiche-audit-config.sql
|
|
-- Notes prod : idempotent. Kit owner (role_grants_all) obtient le droit auto.
|
|
-- Les autres kits : cocher manuellement dans la matrice.
|
|
|
|
SET NAMES utf8mb4;
|
|
|
|
INSERT INTO `inscriptions_eve_permissions`
|
|
(`perm_key`, `perm_group`, `perm_scope`, `perm_label_fr`, `perm_label_en`,
|
|
`perm_description_fr`, `perm_description_en`, `perm_phase`, `perm_actif`, `perm_tri`)
|
|
VALUES
|
|
('inscriptions_gestion.audit_view', 'inscriptions', 'action',
|
|
'Gestion inscription : voir historique ( ! )',
|
|
'Registration mgmt: view change history (!)',
|
|
'Affiche un ! a cote des champs audites sur la fiche ; pop-up des derniers changements',
|
|
'Shows a ! next to audited fields on the sheet; popup of recent changes',
|
|
2, 1, 118)
|
|
ON DUPLICATE KEY UPDATE
|
|
`perm_group` = VALUES(`perm_group`),
|
|
`perm_scope` = VALUES(`perm_scope`),
|
|
`perm_label_fr` = VALUES(`perm_label_fr`),
|
|
`perm_label_en` = VALUES(`perm_label_en`),
|
|
`perm_description_fr` = VALUES(`perm_description_fr`),
|
|
`perm_description_en` = VALUES(`perm_description_en`),
|
|
`perm_phase` = VALUES(`perm_phase`),
|
|
`perm_actif` = 1,
|
|
`perm_tri` = VALUES(`perm_tri`);
|
|
|
|
DELETE FROM info
|
|
WHERE info_prg = 'compte.php'
|
|
AND info_clef IN (
|
|
'inscr_gestion_audit_bang_title',
|
|
'inscr_gestion_audit_bang_aria',
|
|
'inscr_gestion_audit_popup_title',
|
|
'inscr_gestion_audit_popup_empty',
|
|
'inscr_gestion_audit_popup_close',
|
|
'inscr_gestion_audit_col_when',
|
|
'inscr_gestion_audit_col_who',
|
|
'inscr_gestion_audit_col_from',
|
|
'inscr_gestion_audit_col_to',
|
|
'inscr_gestion_audit_field_par_statut_course',
|
|
'inscr_gestion_audit_field_no_bib',
|
|
'inscr_gestion_audit_field_no_bib_remis',
|
|
'inscr_gestion_audit_field_is_cancelled'
|
|
);
|
|
|
|
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_audit_bang_title', 'fr', 'Voir les derniers changements', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_bang_title', 'en', 'View recent changes', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_bang_aria', 'fr', 'Historique des modifications', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_bang_aria', 'en', 'Change history', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_popup_title', 'fr', 'Derniers changements', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_popup_title', 'en', 'Recent changes', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_popup_empty', 'fr', 'Aucun historique pour ce champ.', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_popup_empty', 'en', 'No history for this field.', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_popup_close', 'fr', 'Fermer', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_popup_close', 'en', 'Close', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_when', 'fr', 'Quand', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_when', 'en', 'When', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_who', 'fr', 'Par', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_who', 'en', 'By', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_from', 'fr', 'Avant', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_from', 'en', 'From', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_to', 'fr', 'Après', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_col_to', 'en', 'To', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_par_statut_course', 'fr', 'Statut de course', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_par_statut_course', 'en', 'Race status', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_no_bib', 'fr', 'Numéro de dossard', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_no_bib', 'en', 'Bib number', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_no_bib_remis', 'fr', 'Dossard remis', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_no_bib_remis', 'en', 'Bib handed out', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_is_cancelled', 'fr', 'Annulation', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW()),
|
|
('inscr_gestion_audit_field_is_cancelled', 'en', 'Cancellation', '', 'compte.php', 'MSIN-4464', 0, 1, '', '', '', NOW());
|