SET @payroll_group = (SELECT id FROM permission_roles WHERE name = 'traveltime_payroll');

SET @submissions_resource = (SELECT id FROM permission_resources WHERE name = 'traveltime_submissions');

INSERT INTO permission_rules (name, role_id, resource_id) VALUES ('view_all', @payroll_group, @submissions_resource);
