personal_agent/database/migrations/001_create_memories.sql


1
2
3
4
5
6
7

CREATE TABLE IF NOT EXISTS memories (
  id TEXT PRIMARY KEY,
  content TEXT NOT NULL,
  category TEXT NOT NULL,
  created_at TEXT NOT NULL,
  importance INTEGER NOT NULL DEFAULT 2
);