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

-- Copy permissions from Accession Register for roles that already have it
INSERT IGNORE INTO `app_role_permissions` (`role_id`, `module_key`, `can_view`, `can_export`)
SELECT `role_id`, 'book_report', `can_view`, `can_export`
FROM `app_role_permissions`
WHERE `module_key` = 'accession_register';
