-- Add Search Catalogue Report (run once on existing DB)
INSERT IGNORE INTO `app_modules` (`module_key`, `module_name`, `module_group`, `route`, `sort_order`) VALUES
('search_catalogue_report', 'Search Catalogue Report', 'Catalogue', 'report/search_catalogue_report', 72);

INSERT IGNORE INTO `app_role_permissions` (`role_id`, `module_key`, `can_view`, `can_export`)
SELECT `role_id`, 'search_catalogue_report', `can_view`, `can_export`
FROM `app_role_permissions`
WHERE `module_key` = 'accession_register';
