CREATE TABLE IF NOT EXISTS users (
    user_id       INTEGER PRIMARY KEY,
    username      TEXT,
    first_name    TEXT,
    token         TEXT UNIQUE,
    is_active     INTEGER DEFAULT 1,
    created_at    TEXT NOT NULL,
    last_seen     TEXT,
    total_turns   INTEGER DEFAULT 0
);

CREATE TABLE IF NOT EXISTS tokens (
    token         TEXT PRIMARY KEY,
    assigned_to   INTEGER,
    is_active     INTEGER DEFAULT 1,
    created_at    TEXT NOT NULL,
    turns_used    INTEGER DEFAULT 0,
    last_used     TEXT
);

CREATE TABLE IF NOT EXISTS conversations (
    id            INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id       INTEGER NOT NULL,
    role          TEXT NOT NULL,
    content       TEXT NOT NULL,
    timestamp     TEXT NOT NULL,
    latency_ms    INTEGER,
    gpu_time_ms   INTEGER
);

CREATE INDEX IF NOT EXISTS idx_conv_user_ts
    ON conversations(user_id, timestamp);

CREATE TABLE IF NOT EXISTS admin_audit (
    id            INTEGER PRIMARY KEY AUTOINCREMENT,
    admin_id      TEXT,
    action        TEXT,
    target_user_id INTEGER,
    timestamp     TEXT NOT NULL,
    details       TEXT
);

CREATE TABLE IF NOT EXISTS gpu_log (
    id            INTEGER PRIMARY KEY AUTOINCREMENT,
    user_id       INTEGER,
    timestamp     TEXT NOT NULL,
    duration_ms   INTEGER,
    status        TEXT
);

CREATE TABLE IF NOT EXISTS settings (
    key           TEXT PRIMARY KEY,
    value         TEXT NOT NULL
);