From 63014d0c997a8b8ccece2d1643a1c1724feca52f Mon Sep 17 00:00:00 2001
From: randomdan <randomdan@localhost>
Date: Tue, 7 Jan 2014 19:20:40 +0000
Subject: Add event time range index

---
 p2pvr/datasources/schema.sql | 7 +++++++
 1 file changed, 7 insertions(+)

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
@@ -446,6 +446,13 @@ CREATE INDEX idx_event_search ON events USING gin ((((setweight(to_tsvector('eng
 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: 
 --
-- 
cgit v1.2.3