diff options
Diffstat (limited to 'storage/migrations/002_add_vector.up.sql')
-rw-r--r-- | storage/migrations/002_add_vector.up.sql | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/storage/migrations/002_add_vector.up.sql b/storage/migrations/002_add_vector.up.sql index 6c8fb52..2ac4621 100644 --- a/storage/migrations/002_add_vector.up.sql +++ b/storage/migrations/002_add_vector.up.sql @@ -1,11 +1,12 @@ -CREATE VIRTUAL TABLE IF NOT EXISTS embeddings USING vec0( - embedding FLOAT[5120], - slug TEXT NOT NULL, - raw_text TEXT PRIMARY KEY, -); +--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 + raw_text TEXT PRIMARY KEY, + filename TEXT NOT NULL DEFAULT '' ); |