From 267b7065444b2904e1172817c661709e0b456b80 Mon Sep 17 00:00:00 2001
From: Jebbs <qjebbs@gmail.com>
Date: Tue, 12 Feb 2019 14:20:07 +0800
Subject: Sort search results by relevance

---
 database/sql/schema_version_22.sql | 1 +
 1 file changed, 1 insertion(+)
 create mode 100644 database/sql/schema_version_22.sql

(limited to 'database/sql')

diff --git a/database/sql/schema_version_22.sql b/database/sql/schema_version_22.sql
new file mode 100644
index 0000000..1b51e8a
--- /dev/null
+++ b/database/sql/schema_version_22.sql
@@ -0,0 +1 @@
+update entries set document_vectors = setweight(to_tsvector(substring(coalesce(title, '') for 1000000)), 'A') || setweight(to_tsvector(substring(coalesce(content, '') for 1000000)), 'B');
\ No newline at end of file
-- 
cgit v1.2.3