personal_agent/database/migrations/002_add_memory_fts.sql


1
2
3
4
5
6

CREATE VIRTUAL TABLE IF NOT EXISTS memories_fts
USING fts5(
    content,
    content='memories',
    content_rowid='rowid'
);