1 files changed, 12 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..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 ''
+);