diff options
| author | randomdan <randomdan@localhost> | 2014-01-07 19:20:40 +0000 |
|---|---|---|
| committer | randomdan <randomdan@localhost> | 2014-01-07 19:20:40 +0000 |
| commit | 63014d0c997a8b8ccece2d1643a1c1724feca52f (patch) | |
| tree | 905972cc5130fe6fa4f9f2606eddb5bf501b8199 | |
| parent | Corrections to schema (diff) | |
| download | p2pvr-63014d0c997a8b8ccece2d1643a1c1724feca52f.tar.bz2 p2pvr-63014d0c997a8b8ccece2d1643a1c1724feca52f.tar.xz p2pvr-63014d0c997a8b8ccece2d1643a1c1724feca52f.zip | |
Add event time range index
| -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: -- |