41 lines
1.8 KiB
SQL
41 lines
1.8 KiB
SQL
-- MSIN-4401 — Scanner QR = droit Inscriptions V2 (pas l'ancienne API)
|
|
-- Prérequis : MSIN-4401-eve-acces-v2-pages-niveau1.sql
|
|
-- Idempotent. Safe pilote.
|
|
--
|
|
-- Note : kit propriétaire (role_grants_all) n'a PAS besoin de cette ligne —
|
|
-- il a déjà tout. On met le droit seulement sur les kits ciblés.
|
|
|
|
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.qr_scan', 'inscriptions_v2', 'action',
|
|
'Inscriptions V2 — scanner QR', 'Registration mgmt V2 — QR scan',
|
|
'Lecteur QR sur la liste (hub, compte ou /mobile) — meme droit partout',
|
|
'QR reader on the list (hub, account or /mobile) — same right everywhere',
|
|
2, 1, 105)
|
|
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`);
|
|
|
|
/* Kits terrain (pas owner : grants_all suffit pour le proprietaire) */
|
|
INSERT INTO inscriptions_eve_role_permissions (role_id, perm_key)
|
|
SELECT r.role_id, 'inscriptions_gestion.qr_scan'
|
|
FROM inscriptions_eve_roles r
|
|
WHERE r.role_code IN ('gestion_ops', 'gestion_statut')
|
|
ON DUPLICATE KEY UPDATE perm_key = VALUES(perm_key);
|
|
|
|
DELETE erp FROM inscriptions_eve_role_permissions erp
|
|
INNER JOIN inscriptions_eve_roles r ON r.role_id = erp.role_id
|
|
WHERE erp.perm_key = 'inscriptions_gestion.qr_scan'
|
|
AND r.role_code IN ('gestion_readonly', 'bib_ops', 'qr_debug');
|