Summary
memories_fts FTS5 only indexes: content, tags, namespace. The memory_type column is not indexed.
Current:
CREATE VIRTUAL TABLE memories_fts USING fts5(content, tags, namespace, content='memories');
Proposed
Add memory_type to FTS5 columns and update triggers.
Acceptance Criteria
Functional
Verification (CMO can run without reading code)
Tests
Priority
Low — /query endpoint (#657) is the primary solution.
Dependencies
Coordinate with #656 (index creation).
Summary
memories_ftsFTS5 only indexes: content, tags, namespace. Thememory_typecolumn is not indexed.Current:
Proposed
Add
memory_typeto FTS5 columns and update triggers.Acceptance Criteria
Functional
memory_typeto FTS5 columnsmemory_typeVerification (CMO can run without reading code)
sqlite3 uteke.db "SELECT * FROM memories_fts WHERE memories_fts MATCH 'memory_type:decision'"→ returns decision-type memoriessqlite3 uteke.db "SELECT * FROM memories_fts WHERE memories_fts MATCH 'memory_type:event'"→ returns event-type memoriessqlite3 uteke.db "SELECT * FROM memories_fts WHERE memories_fts MATCH 'memory_type:fact'"→ returns fact-type memories (most common)Tests
Priority
Low — /query endpoint (#657) is the primary solution.
Dependencies
Coordinate with #656 (index creation).