stephan
7bd586b619
This commit introduces new functions for permission inspection, allowing super admins to toggle and manage access rights more effectively. It adds visual elements for permission badges in the admin interface and updates the sidebar navigation to include a migration section for legacy accounts. Additionally, CSS styles are enhanced for better user experience and clarity. The version code is updated to reflect these changes.
39 lines
1.5 KiB
SQL
39 lines
1.5 KiB
SQL
/*
|
|
MSIN - Acces evenement v2 (phase 4) - Kit « tous les droits »
|
|
Executer APRES MSIN-eve-acces-v2-phase3-role-delegable.sql
|
|
|
|
role_grants_all = 1 : le kit accorde toute permission active du catalogue,
|
|
presentes et futures, sans maintenir la matrice role_permissions.
|
|
*/
|
|
|
|
SET NAMES utf8mb4;
|
|
|
|
ALTER TABLE `inscriptions_eve_roles`
|
|
ADD COLUMN `role_grants_all` tinyint(1) unsigned NOT NULL DEFAULT 0
|
|
COMMENT '1 = tous les droits actifs du catalogue (presents et futurs)'
|
|
AFTER `role_delegable`;
|
|
|
|
UPDATE `inscriptions_eve_roles`
|
|
SET `role_grants_all` = 1
|
|
WHERE `role_code` = 'owner';
|
|
|
|
INSERT INTO `inscriptions_eve_roles`
|
|
(`role_code`, `role_label_fr`, `role_label_en`, `role_description_fr`, `role_description_en`,
|
|
`role_icone`, `role_systeme`, `role_actif`, `role_tri`, `role_delegable`, `role_grants_all`)
|
|
VALUES
|
|
('migration_legacy', 'Migration promoteur', 'Legacy promoter migration',
|
|
'Acces total equivalent promoteur legacy — migration uniquement',
|
|
'Full legacy promoter equivalent access — migration only',
|
|
'fa-exchange', 1, 1, 5, 0, 1)
|
|
ON DUPLICATE KEY UPDATE
|
|
`role_label_fr` = VALUES(`role_label_fr`),
|
|
`role_label_en` = VALUES(`role_label_en`),
|
|
`role_description_fr` = VALUES(`role_description_fr`),
|
|
`role_description_en` = VALUES(`role_description_en`),
|
|
`role_icone` = VALUES(`role_icone`),
|
|
`role_systeme` = VALUES(`role_systeme`),
|
|
`role_actif` = VALUES(`role_actif`),
|
|
`role_tri` = VALUES(`role_tri`),
|
|
`role_delegable` = VALUES(`role_delegable`),
|
|
`role_grants_all` = VALUES(`role_grants_all`);
|