summaryrefslogtreecommitdiff
path: root/makima/migrations/20260211000000_add_directive_memories.sql
diff options
context:
space:
mode:
Diffstat (limited to 'makima/migrations/20260211000000_add_directive_memories.sql')
-rw-r--r--makima/migrations/20260211000000_add_directive_memories.sql20
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);