1CREATE TABLE pings (
2 id INTEGER PRIMARY KEY AUTOINCREMENT,
3 service_id TEXT NOT NULL,
4 timestamp INTEGER NOT NULL,
5 status TEXT NOT NULL CHECK (status IN ('up', 'degraded', 'down')),
6 latency_ms INTEGER
7);
8
9CREATE INDEX idx_pings_service_ts ON pings (service_id, timestamp DESC);
dunkirk.sh