-- Add Price Range Report under Catalogue (run once on existing DB)
INSERT IGNORE INTO `app_modules` (`module_key`, `module_name`, `module_group`, `route`, `sort_order`) VALUES
('price_range_report', 'Price Range Report', 'Catalogue', 'report/price_range_report', 127);

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