+/- table definition
Query
CREATE TABLE sessions (
id TEXT PRIMARY KEY,
title TEXT NOT NULL DEFAULT 'New Session',
workspace TEXT NOT NULL DEFAULT '',
model TEXT NOT NULL DEFAULT 'claude-sonnet-4-6',
status TEXT NOT NULL DEFAULT 'active' CHECK (status IN ('active', 'archived')),
created_at TEXT NOT NULL DEFAULT (datetime('now')),
updated_at TEXT NOT NULL DEFAULT (datetime('now')),
permission_mode TEXT NOT NULL DEFAULT '',
user_id TEXT NOT NULL DEFAULT '',
external_user_id TEXT,
backend TEXT NOT NULL DEFAULT 'claude'
)