-- Migration: 0001_init
-- Creates the hermes_session_message_stats table for hermes-session-message-stats sense.

CREATE TABLE IF NOT EXISTS hermes_session_message_stats (
  id                           INTEGER PRIMARY KEY AUTOINCREMENT,
  ts                           INTEGER NOT NULL,
  total_user_messages          INTEGER NOT NULL,
  total_assistant_messages     INTEGER NOT NULL,
  total_tool_messages          INTEGER NOT NULL,
  total_messages               INTEGER NOT NULL,
  active_sessions              INTEGER NOT NULL,
  measurement_window_seconds   INTEGER NOT NULL
);