-- Верификация 007: таблицы, сид ролей/прав/матрицы
SELECT 'roles' AS t, count(*) FROM roles
UNION ALL SELECT 'permissions', count(*) FROM permissions
UNION ALL SELECT 'role_permissions', count(*) FROM role_permissions
UNION ALL SELECT 'security_settings', count(*) FROM security_settings
UNION ALL SELECT 'users_new_cols', count(*) FROM information_schema.columns WHERE table_name='users' AND column_name IN ('unit_id','status','failed_login_count','locked_until','must_change_password','created_by','updated_at','position');
SELECT r.name, count(rp.permission_id) AS perms FROM roles r LEFT JOIN role_permissions rp ON rp.role_id = r.id GROUP BY r.name ORDER BY r.name;
SELECT name, kind FROM mchs_units;
SELECT version_num FROM alembic_version;