-- =============================================================================
-- 00-preflight-checks.sql
-- Run BEFORE any schema changes. Save query results for comparison after upgrade.
-- cPanel safe — no information_schema. Safe to run multiple times (read-only).
-- =============================================================================

SELECT COUNT(*) AS members_count FROM members;
SELECT COUNT(*) AS attendances_count FROM attendances;
SELECT COUNT(*) AS leaves_count FROM leaves;
SELECT COUNT(*) AS owner_count FROM owner;

SELECT id, timestamp, name FROM migrations ORDER BY id;

SHOW TABLES LIKE 'access_roles';
SHOW COLUMNS FROM `members` LIKE 'access_role_id';
