Enha (RAG): raw text as primary key in vector db

1 files changed, 2 insertions, 4 deletions

diff --git a/storage/migrations/002_add_vector.up.sql b/storage/migrations/002_add_vector.up.sql
index f64aecb..6c8fb52 100644
--- a/storage/migrations/002_add_vector.up.sql
+++ b/storage/migrations/002_add_vector.up.sql
@@ -1,13 +1,11 @@
 CREATE VIRTUAL TABLE IF NOT EXISTS embeddings USING vec0(
-    id INTEGER PRIMARY KEY AUTOINCREMENT,
     embedding FLOAT[5120],
     slug TEXT NOT NULL,
-    raw_text TEXT NOT NULL
+    raw_text TEXT PRIMARY KEY,
 );
 
 CREATE VIRTUAL TABLE IF NOT EXISTS embeddings_384 USING vec0(
-    id INTEGER PRIMARY KEY AUTOINCREMENT,
     embedding FLOAT[384],
     slug TEXT NOT NULL,
-    raw_text TEXT NOT NULL
+    raw_text TEXT PRIMARY KEY
 );