2 files changed, 13 insertions, 0 deletions
diff --git a/storage/migrations/001_init.up.sql b/storage/migrations/001_init.up.sql
index 8980ccf..09bb5e6 100644
--- a/storage/migrations/001_init.up.sql
+++ b/storage/migrations/001_init.up.sql
@@ -2,6 +2,7 @@ CREATE TABLE IF NOT EXISTS chats (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
     name TEXT NOT NULL,
     msgs TEXT NOT NULL,
+    agent TEXT NOT NULL DEFAULT 'assistant',
     created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
     updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
 );
diff --git a/storage/migrations/002_add_vector.up.sql b/storage/migrations/002_add_vector.up.sql
new file mode 100644
index 0000000..2ac4621
--- /dev/null
+++ b/storage/migrations/002_add_vector.up.sql
@@ -0,0 +1,12 @@
+--CREATE VIRTUAL TABLE IF NOT EXISTS embeddings_5120 USING vec0(
+--    embedding FLOAT[5120],
+--    slug TEXT NOT NULL,
+--    raw_text TEXT PRIMARY KEY,
+--);
+
+CREATE VIRTUAL TABLE IF NOT EXISTS embeddings_384 USING vec0(
+    embedding FLOAT[384],
+    slug TEXT NOT NULL,
+    raw_text TEXT PRIMARY KEY,
+    filename TEXT NOT NULL DEFAULT ''
+);