From 39df770ea4ae37f3f9e30c5be5274b741e7ecf7b Mon Sep 17 00:00:00 2001 From: soryu Date: Thu, 12 Feb 2026 23:28:57 +0000 Subject: Fix migration --- .../20260211000000_add_directive_memories.sql | 20 -------------------- .../20260212000000_add_directive_memory_enabled.sql | 2 ++ 2 files changed, 2 insertions(+), 20 deletions(-) delete mode 100644 makima/migrations/20260211000000_add_directive_memories.sql create mode 100644 makima/migrations/20260212000000_add_directive_memory_enabled.sql 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; -- cgit v1.2.3