diff options
| -rw-r--r-- | p2pvr/datasources/schema.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql index e76b6b8..f6d1d45 100644 --- a/p2pvr/datasources/schema.sql +++ b/p2pvr/datasources/schema.sql @@ -447,6 +447,13 @@ CREATE INDEX idx_event_title ON events USING btree (lower(title)); -- +-- Name: idx_events_timerange; Type: INDEX; Schema: public; Owner: -; Tablespace: +-- + +CREATE INDEX idx_events_timerange ON events USING gist (tsrange(starttime, stoptime)); + + +-- -- Name: idx_recorded_schedule; Type: INDEX; Schema: public; Owner: -; Tablespace: -- |