1 files changed, 6 insertions, 0 deletions
diff --git a/storage/migrations/002_add_vector.up.sql b/storage/migrations/002_add_vector.up.sql
new file mode 100644
index 0000000..4fcc9aa
--- /dev/null
+++ b/storage/migrations/002_add_vector.up.sql
@@ -0,0 +1,6 @@
+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
+);