SET NAMES utf8mb4;
INSERT IGNORE INTO permissions(module,action,name) VALUES
('reports','view','Rapports — Consulter'),
('settings','view','Paramètres — Consulter');
INSERT IGNORE INTO role_permissions(role_id,permission_id)
SELECT r.id,p.id FROM roles r CROSS JOIN permissions p
WHERE r.code='administrator' AND p.module IN('reports','settings') AND p.action='view';