ALTER TABLE agent_telemetry_state ADD COLUMN dropped_baseline_at TEXT;
ALTER TABLE agent_telemetry_state ADD COLUMN accepted_baseline_at TEXT;
ALTER TABLE agent_stats_samples ADD COLUMN dropped_interval_start TEXT;
ALTER TABLE agent_stats_samples ADD COLUMN accepted_interval_start TEXT;
ALTER TABLE agent_stats_samples ADD COLUMN dropped_present INTEGER;
ALTER TABLE agent_stats_samples ADD COLUMN accepted_present INTEGER;
ALTER TABLE agent_stats_samples ADD COLUMN analytics_processed INTEGER NOT NULL DEFAULT 0;
CREATE INDEX idx_stats_agent_cursor ON agent_stats_samples(agent_id, recorded_at, id);
CREATE INDEX idx_stats_recorded_at ON agent_stats_samples(recorded_at);
CREATE INDEX idx_stats_analytics_pending ON agent_stats_samples(analytics_processed, recorded_at, id);

CREATE TABLE agent_stats_rollups (
  agent_id TEXT NOT NULL REFERENCES agents(id) ON DELETE CASCADE,
  resolution TEXT NOT NULL CHECK(resolution IN ('1m','1h','1d')),
  bucket_start TEXT NOT NULL,
  packets_dropped REAL NOT NULL DEFAULT 0,
  packets_accepted REAL NOT NULL DEFAULT 0,
  dropped_coverage_ms INTEGER NOT NULL DEFAULT 0,
  accepted_coverage_ms INTEGER NOT NULL DEFAULT 0,
  partial INTEGER NOT NULL DEFAULT 0,
  truncated INTEGER NOT NULL DEFAULT 0,
  estimated INTEGER NOT NULL DEFAULT 0,
  unsupported_json TEXT NOT NULL DEFAULT '[]',
  lost_reports INTEGER NOT NULL DEFAULT 0,
  PRIMARY KEY(agent_id, resolution, bucket_start)
);
CREATE INDEX idx_stats_rollups_resolution_time ON agent_stats_rollups(resolution, bucket_start);