summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorsoryu <soryu@soryu.co>2026-02-12 23:28:57 +0000
committersoryu <soryu@soryu.co>2026-02-12 23:28:57 +0000
commit39df770ea4ae37f3f9e30c5be5274b741e7ecf7b (patch)
tree19a69c401a8b38da973880a0c4962b4b05570c35
parenta6d40de1be0f8ae1ba938acb7875ebcf2b3b18e7 (diff)
downloadsoryu-39df770ea4ae37f3f9e30c5be5274b741e7ecf7b.tar.gz
soryu-39df770ea4ae37f3f9e30c5be5274b741e7ecf7b.zip
Fix migration
-rw-r--r--makima/migrations/20260211000000_add_directive_memories.sql20
-rw-r--r--makima/migrations/20260212000000_add_directive_memory_enabled.sql2
2 files changed, 2 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);
diff --git a/makima/migrations/20260212000000_add_directive_memory_enabled.sql b/makima/migrations/20260212000000_add_directive_memory_enabled.sql
new file mode 100644
index 0000000..598f75f
--- /dev/null
+++ b/makima/migrations/20260212000000_add_directive_memory_enabled.sql
@@ -0,0 +1,2 @@
+-- Add memory_enabled flag to directives table.
+ALTER TABLE directives ADD COLUMN memory_enabled BOOLEAN NOT NULL DEFAULT false;