Query
CREATE TABLE conversation_state (
thread_id TEXT PRIMARY KEY,
last_turn_id TEXT,
last_source_event_id TEXT,
rolling_summary TEXT,
open_loops TEXT,
intents TEXT,
state_blob TEXT,
salience REAL DEFAULT 0.0,
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
FOREIGN KEY (last_turn_id) REFERENCES conversation_turns(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED,
FOREIGN KEY (last_source_event_id) REFERENCES events(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)