-- LOT 11.20 - controles non destructifs quota/status licence
-- A executer apres deploiement et apres un check PLACE.

SELECT id, license_key, edition_code, max_courses_rolling_year, sms_quota_month, sms_overage_price, offline_grace_days
FROM licenses
ORDER BY id DESC
LIMIT 10;

SELECT id, license_id, computed_at, rolling_365_course_count, sms_sent_count,
       active_events_count, active_runs_count, source, details_json, created_at
FROM license_usage_stats
ORDER BY id DESC
LIMIT 10;

SELECT id, license_id, event_type, payload_json, created_at
FROM license_audit_log
WHERE event_type = 'check'
ORDER BY id DESC
LIMIT 10;
