diff options
Diffstat (limited to 'database/sql/schema_version_20.sql')
-rw-r--r-- | database/sql/schema_version_20.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/database/sql/schema_version_20.sql b/database/sql/schema_version_20.sql new file mode 100644 index 0000000..228e162 --- /dev/null +++ b/database/sql/schema_version_20.sql @@ -0,0 +1,3 @@ +alter table entries add column document_vectors tsvector; +update entries set document_vectors = to_tsvector(title || ' ' || coalesce(content, '')); +create index document_vectors_idx on entries using gin(document_vectors);
\ No newline at end of file |