Constant LOCAL_SCHEMA 

pub const LOCAL_SCHEMA: &str = "\
CREATE TABLE IF NOT EXISTS local_sessions (
    id                   TEXT PRIMARY KEY,
    source_path          TEXT,
    sync_status          TEXT NOT NULL DEFAULT 'local_only',
    last_synced_at       TEXT,
    user_id              TEXT,
    nickname             TEXT,
    team_id              TEXT,
    tool                 TEXT NOT NULL,
    agent_provider       TEXT,
    agent_model          TEXT,
    title                TEXT,
    description          TEXT,
    tags                 TEXT,
    created_at           TEXT NOT NULL,
    uploaded_at          TEXT,
    message_count        INTEGER DEFAULT 0,
    task_count           INTEGER DEFAULT 0,
    event_count          INTEGER DEFAULT 0,
    duration_seconds     INTEGER DEFAULT 0,
    total_input_tokens   INTEGER DEFAULT 0,
    total_output_tokens  INTEGER DEFAULT 0,
    git_remote           TEXT,
    git_branch           TEXT,
    git_commit           TEXT,
    git_repo_name        TEXT,
    pr_number            INTEGER,
    pr_url               TEXT,
    working_directory    TEXT
);
CREATE TABLE IF NOT EXISTS sync_cursors (
    team_id    TEXT NOT NULL,
    cursor     TEXT NOT NULL,
    updated_at TEXT NOT NULL DEFAULT (datetime('now')),
    PRIMARY KEY (team_id)
);
CREATE TABLE IF NOT EXISTS body_cache (
    session_id  TEXT PRIMARY KEY,
    body        BLOB,
    cached_at   TEXT NOT NULL DEFAULT (datetime('now'))
);
";

Local-only SQLite schema for TUI + Daemon (not on the server).