opencode-pulse/schema.sql at main · fetep/opencode-pulse · GitHub

33 lines (30 loc) · 1.15 KB

-- Schema version 4: add subagent tracking and session age

CREATE TABLE IF NOT EXISTS schema_version (

id INTEGER PRIMARY KEY CHECK(id = 1),

version INTEGER NOT NULL

);

INSERT INTO schema_version (id, version) VALUES (1, 4)

ON CONFLICT(id) DO UPDATE SET version = excluded.version;

CREATE TABLE IF NOT EXISTS sessions (

pid INTEGER PRIMARY KEY,

session_id TEXT,

project_id TEXT,

directory TEXT,

title TEXT,

status TEXT NOT NULL DEFAULT 'idle',

retry_message TEXT,

retry_next INTEGER,

error_message TEXT,

tmux_pane TEXT,

tmux_target TEXT,

opencode_version TEXT,

todo_total INTEGER NOT NULL DEFAULT 0,

todo_done INTEGER NOT NULL DEFAULT 0,

subagent_count INTEGER NOT NULL DEFAULT 0,

session_started_at INTEGER,

heartbeat_at INTEGER NOT NULL,

created_at INTEGER NOT NULL,

updated_at INTEGER NOT NULL

);

CREATE INDEX IF NOT EXISTS idx_sessions_status ON sessions(status);

CREATE INDEX IF NOT EXISTS idx_sessions_heartbeat ON sessions(heartbeat_at);

Expand file tree