-- Seed default roles and permissions
INSERT IGNORE INTO `roles` (`role`, `permissions`) VALUES
('super_admin', JSON_OBJECT('all', true)),
('admin', JSON_OBJECT('can_manage_users', true, 'can_manage_roles', true, 'can_view_analytics', true)),
('regional_admin', JSON_OBJECT('manage_region', 'usa', 'can_view_reports', true)),
('instructor', JSON_OBJECT('can_create_courses', true, 'can_create_assessments', true, 'can_view_reports', true)),
('student', JSON_OBJECT());