From afd9ad0560d76c2a6d161dad52553b10ff428905 Mon Sep 17 00:00:00 2001 From: Kujtim Hoxha Date: Thu, 27 Mar 2025 22:35:48 +0100 Subject: rework llm --- internal/db/migrations/000001_initial.up.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'internal/db/migrations') diff --git a/internal/db/migrations/000001_initial.up.sql b/internal/db/migrations/000001_initial.up.sql index b87592bb5..d4a5e39fe 100644 --- a/internal/db/migrations/000001_initial.up.sql +++ b/internal/db/migrations/000001_initial.up.sql @@ -1,6 +1,7 @@ -- Sessions CREATE TABLE IF NOT EXISTS sessions ( id TEXT PRIMARY KEY, + parent_session_id TEXT, title TEXT NOT NULL, message_count INTEGER NOT NULL DEFAULT 0 CHECK (message_count >= 0), prompt_tokens INTEGER NOT NULL DEFAULT 0 CHECK (prompt_tokens >= 0), @@ -21,7 +22,12 @@ END; CREATE TABLE IF NOT EXISTS messages ( id TEXT PRIMARY KEY, session_id TEXT NOT NULL, - message_data TEXT NOT NULL, -- JSON string of message content + role TEXT NOT NULL, + content TEXT NOT NULL, + thinking Text NOT NULL DEFAULT '', + finished BOOLEAN NOT NULL DEFAULT 0, + tool_calls TEXT, + tool_results TEXT, created_at INTEGER NOT NULL, -- Unix timestamp in milliseconds updated_at INTEGER NOT NULL, -- Unix timestamp in milliseconds FOREIGN KEY (session_id) REFERENCES sessions (id) ON DELETE CASCADE -- cgit v1.2.3