15 lines
446 B
MySQL
15 lines
446 B
MySQL
|
-- Preserve administrator access after adding the e-conomic catalog permissions.
|
||
|
|
-- Migration 002 grants all permissions known at install time, so permissions
|
||
|
|
-- introduced later must also be assigned to the Administrators group.
|
||
|
|
BEGIN;
|
||
|
|
|
||
|
|
INSERT INTO group_permissions (group_id, permission_id)
|
||
|
|
SELECT g.id, p.id
|
||
|
|
FROM groups g
|
||
|
|
CROSS JOIN permissions p
|
||
|
|
WHERE g.name = 'Administrators'
|
||
|
|
AND p.category = 'economic'
|
||
|
|
ON CONFLICT DO NOTHING;
|
||
|
|
|
||
|
|
COMMIT;
|