fix: reference projects(guid) not projects(id) in chat_histories FK

2026-04-01 16:23:21 +02:00
1 changed files with 1 additions and 1 deletions
--- a/migrations/018_chat_histories.sql
+++ b/migrations/018_chat_histories.sql
@@ -7,7 +7,7 @@ CREATE TABLE IF NOT EXISTS chat_histories (
    title       TEXT,
    channel     TEXT,
    agent_id    TEXT,
-    project_id  UUID        REFERENCES projects(id) ON DELETE SET NULL,
+    project_id  UUID        REFERENCES projects(guid) ON DELETE SET NULL,
    messages    JSONB       NOT NULL DEFAULT '[]',
    summary     TEXT,
    metadata    JSONB       NOT NULL DEFAULT '{}',