diff options
| -rw-r--r-- | p2pvr/datasources/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql index df65cfa..fce7a4f 100644 --- a/p2pvr/datasources/schema.sql +++ b/p2pvr/datasources/schema.sql @@ -436,7 +436,7 @@ ALTER TABLE ONLY transportstreams -- Name: idx_event_search; Type: INDEX; Schema: public; Owner: -; Tablespace: -- -CREATE INDEX idx_event_search ON events USING gin ((((setweight(to_tsvector('english'::regconfig, title), 'A'::"char") || setweight(to_tsvector('english'::regconfig, COALESCE(subtitle, ''::text)), 'B'::"char")) || setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'C'::"char")))); +CREATE INDEX idx_event_search ON events USING gin (event_tsvector(events.*)); -- |