diff options
Diffstat (limited to 'makima/migrations/20260211000000_add_directive_memories.sql')
| -rw-r--r-- | makima/migrations/20260211000000_add_directive_memories.sql | 20 |
1 files changed, 0 insertions, 20 deletions
diff --git a/makima/migrations/20260211000000_add_directive_memories.sql b/makima/migrations/20260211000000_add_directive_memories.sql deleted file mode 100644 index 69d00bf..0000000 --- a/makima/migrations/20260211000000_add_directive_memories.sql +++ /dev/null @@ -1,20 +0,0 @@ --- Directive memory system: optional key-value storage scoped to a directive. --- Allows directives to persist learnings, decisions, and context across steps. - --- Add memory_enabled flag to directives -ALTER TABLE directives ADD COLUMN memory_enabled BOOLEAN NOT NULL DEFAULT false; - --- Key-value memory entries scoped to a directive -CREATE TABLE directive_memories ( - id UUID PRIMARY KEY DEFAULT gen_random_uuid(), - directive_id UUID NOT NULL REFERENCES directives(id) ON DELETE CASCADE, - key VARCHAR(255) NOT NULL, - value TEXT NOT NULL, - category VARCHAR(100), - created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), - updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), - UNIQUE(directive_id, key) -); - -CREATE INDEX idx_directive_memories_directive_id ON directive_memories(directive_id); -CREATE INDEX idx_directive_memories_category ON directive_memories(directive_id, category); |
