-- Rename/move report modules (run once on existing DB)
UPDATE `app_modules` SET `module_name` = 'Current Checkout Report' WHERE `module_key` = 'current_checkout';
UPDATE `app_modules` SET `module_name` = 'Due Clearance Report' WHERE `module_key` = 'due_clearance';
UPDATE `app_modules` SET `module_name` = 'Accession Register Report' WHERE `module_key` = 'accession_register';
UPDATE `app_modules` SET `module_name` = 'New Arrivals Report' WHERE `module_key` = 'new_arrivals';
UPDATE `app_modules` SET `module_name` = 'Institutional Repository Report' WHERE `module_key` = 'institutional_repository';
UPDATE `app_modules` SET `module_name` = 'Standards Data Report' WHERE `module_key` = 'standards_data';
UPDATE `app_modules` SET `module_name` = 'EReport Books Report' WHERE `module_key` = 'ereport_books';
UPDATE `app_modules` SET `module_name` = 'Material Statistics Report' WHERE `module_key` = 'overall_material_statistics_report';

UPDATE `app_modules`
SET `module_name` = 'Top Books Report', `module_group` = 'Circulation'
WHERE `module_key` = 'top_books_report';

UPDATE `app_modules`
SET `module_name` = 'Single Catalogue History Report', `module_group` = 'Circulation'
WHERE `module_key` = 'single_book_report';

UPDATE `app_modules`
SET `module_name` = 'Top Users Report', `module_group` = 'Circulation'
WHERE `module_key` = 'top_users_report';

UPDATE `app_modules`
SET `module_name` = 'Single User History Report', `module_group` = 'Circulation'
WHERE `module_key` = 'single_user_report';

UPDATE `app_modules`
SET `module_name` = 'Publication Wise Report'
WHERE `module_key` = 'publisher_year_wise_report';

UPDATE `app_modules`
SET `module_name` = 'Publisher Wise Report'
WHERE `module_key` = 'publisher_person_wise_report';
