Distillation

Date: Sep 15, 2026

• 🟡 (13:09) packages/core/src/session/sql.ts:135-136 defines indexes session_message_session_time_created_id_idx on SessionMessageTable columns (session_id, time_created, id) and session_message_time_created_idx on (time_created).
• 🟡 (13:09) packages/core/src/session/sql.ts:140-166 defines SQLite table SessionInputTable as "session_input" with fields: id (text, typed SessionMessage.ID, primary key), session_id (text, typed SessionSchema.ID, non-null, references SessionTable.id with onDelete: "cascade"), prompt (text in JSON mode, non-null, typed Prompt), delivery (text, typed SessionInput.Delivery, non-null), admitted_seq (integer, non-null), promoted_seq (integer, nullable), and time_created (integer, non-null, default Date.now()).
• 🟡 (13:09) SessionInputTable indexes in packages/core/src/session/sql.ts:156-165 are: session_input_session_pending_delivery_seq_idx on (session_id, promoted_seq, delivery, admitted_seq); unique session_input_session_admitted_seq_idx on (session_id, admitted_seq); and unique session_input_session_promoted_seq_idx on (session_id, promoted_seq).
• 🟡 (13:09) packages/core/src/session/sql.ts:168-191 defines SQLite table SessionRecoveryTable as "session_recovery" with fields: session_id (text, typed SessionSchema.ID, non-null, references SessionTable.id with onDelete: "cascade"), execution_id (text, non-null), assistant_message_id (text, typed SessionMessage.ID, non-null, references SessionMessageTable.id with onDelete: "cascade"), continuation_message_id (text, typed SessionMessage.ID, non-null, references SessionInputTable.id with onDelete: "cascade"), and time_created (integer, non-null).
• 🟡 (13:09) SessionRecoveryTable constraints and indexes in packages/core/src/session/sql.ts:186-190 are: composite primary key (session_id, assistant_message_id); unique index session_recovery_execution_idx on execution_id; and unique index session_recovery_continuation_message_idx on continuation_message_id.
• 🟡 (13:09) packages/core/src/session/sql.ts:193-211 defines SQLite table SessionExecutionTable as "session_execution" with fields: id (text, primary key), session_id (text, typed SessionSchema.ID, non-null, references SessionTable.id with onDelete: "cascade"), owner_id (text, non-null), assistant_message_id (text, typed SessionMessage.ID, nullable), phase (text, typed "ready" | "safe" | "unknown", non-null), time_created (integer, non-null), and expires_at (integer, non-null).
• 🟡 (13:09) SessionExecutionTable indexes in packages/core/src/session/sql.ts:207-210 are unique session_execution_session_idx on session_id and non-unique session_execution_owner_idx on owner_id.
• 🟡 (13:09) packages/core/src/session/sql.ts:213 sets SESSION_EXECUTION_LEASE_MS = 30_000.
• 🟡 (13:09) packages/core/src/session/sql.ts:215-223 defines SQLite table SessionContextEpochTable as "session_context_epoch" with fields: session_id (text, typed SessionSchema.ID, primary key, references SessionTable.id with onDelete: "cascade"), baseline (text, non-null), snapshot (text in JSON mode, non-null, typed SystemContext.Snapshot), and baseline_seq (integer, non-null).