diff options
Diffstat (limited to 'storage/migrations/004_populate_fts.up.sql')
| -rw-r--r-- | storage/migrations/004_populate_fts.up.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/storage/migrations/004_populate_fts.up.sql b/storage/migrations/004_populate_fts.up.sql new file mode 100644 index 0000000..1068bf7 --- /dev/null +++ b/storage/migrations/004_populate_fts.up.sql @@ -0,0 +1,4 @@ +-- Populate FTS table with existing embeddings (incremental - only inserts missing rows) +-- Only use 768 embeddings as that's what we use +INSERT OR IGNORE INTO fts_embeddings (slug, raw_text, filename, embedding_size) +SELECT slug, raw_text, filename, 768 FROM embeddings_768;
\ No newline at end of file |