Add full text search via PostgreSQL

1 files changed, 3 insertions, 1 deletions

diff --git a/schema.sql b/schema.sql
index 62ecd66..5ab895c 100644
--- a/schema.sql
+++ b/schema.sql
@@ -3,8 +3,10 @@ create table if not exists torrents (
     infohash character varying(40) unique,
     size bigint,
     name text,
-    seen timestamp with time zone
+    seen timestamp with time zone,
+    tsv tsvector
 );
+create index tsv_idx on torrents using gin(tsv);
 create table if not exists files (
     id serial not null primary key,
     torrent_id integer not null references torrents on delete cascade,