-- Run after SEPALS_CLASS_DIARY_MIGRATION.sql
SHOW TABLES LIKE 'class_diary';
SHOW TABLES LIKE 'diary_attachments';
SHOW TABLES LIKE 'diary_teacher_assignments';
SHOW TABLES LIKE 'diary_reads';
SELECT permission_key, permission_name, module
FROM permissions
WHERE permission_key IN ('diary.view','diary.manage','diary.assign')
ORDER BY permission_key;
SELECT rp.role, p.permission_key
FROM role_permissions rp
INNER JOIN permissions p ON p.id=rp.permission_id
WHERE p.permission_key LIKE 'diary.%'
ORDER BY rp.role,p.permission_key;