Готовые проверки
SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;
PRAGMA table_info(url_registry);
PRAGMA table_info(new_url_notifications);
PRAGMA table_info(deleted_url_notifications);
SELECT COUNT(*) AS cnt FROM url_registry;
SELECT last_event, COUNT(*) AS cnt FROM url_registry GROUP BY last_event ORDER BY cnt DESC;
SELECT is_present, COUNT(*) AS cnt FROM url_registry GROUP BY is_present ORDER BY is_present DESC;
SELECT * FROM url_registry ORDER BY last_seen_run_id DESC, id DESC LIMIT 50;
SELECT * FROM deleted_url_notifications ORDER BY id DESC LIMIT 50;