Update schema as dumped by a recent pg_dump

1 files changed, 50 insertions, 45 deletions

diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql
index 26655c2..1f9cab0 100644
--- a/p2pvr/datasources/schema.sql
+++ b/p2pvr/datasources/schema.sql
@@ -2,12 +2,17 @@
 -- PostgreSQL database dump
 --
 
+-- Dumped from database version 9.6.3
+-- Dumped by pg_dump version 9.6.3
+
 SET statement_timeout = 0;
 SET lock_timeout = 0;
+SET idle_in_transaction_session_timeout = 0;
 SET client_encoding = 'UTF8';
 SET standard_conforming_strings = on;
 SET check_function_bodies = false;
 SET client_min_messages = warning;
+SET row_security = off;
 
 --
 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
@@ -41,7 +46,7 @@ SET default_tablespace = '';
 SET default_with_oids = false;
 
 --
--- Name: events; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: events; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE events (
@@ -88,7 +93,7 @@ $$;
 
 
 --
--- Name: delivery_dvbc; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: delivery_dvbc; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE delivery_dvbc (
@@ -102,7 +107,7 @@ CREATE TABLE delivery_dvbc (
 
 
 --
--- Name: delivery_dvbs; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: delivery_dvbs; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE delivery_dvbs (
@@ -120,7 +125,7 @@ CREATE TABLE delivery_dvbs (
 
 
 --
--- Name: delivery_dvbt; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: delivery_dvbt; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE delivery_dvbt (
@@ -244,7 +249,7 @@ ALTER SEQUENCE events_eventuid_seq OWNED BY events.eventuid;
 
 
 --
--- Name: networks; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: networks; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE networks (
@@ -254,7 +259,7 @@ CREATE TABLE networks (
 
 
 --
--- Name: record; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: record; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE record (
@@ -265,7 +270,7 @@ CREATE TABLE record (
 
 
 --
--- Name: recorded; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: recorded; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE recorded (
@@ -295,7 +300,7 @@ ALTER SEQUENCE recorded_recordedid_seq OWNED BY recorded.recordedid;
 
 
 --
--- Name: recordings; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: recordings; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE recordings (
@@ -327,7 +332,7 @@ ALTER SEQUENCE recordings_recordingid_seq OWNED BY recordings.recordingid;
 
 
 --
--- Name: schedules; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: schedules; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE schedules (
@@ -363,7 +368,7 @@ ALTER SEQUENCE schedules_scheduleid_seq OWNED BY schedules.scheduleid;
 
 
 --
--- Name: services; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: services; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE services (
@@ -381,7 +386,7 @@ CREATE TABLE services (
 
 
 --
--- Name: transportstreams; Type: TABLE; Schema: public; Owner: -; Tablespace: 
+-- Name: transportstreams; Type: TABLE; Schema: public; Owner: -
 --
 
 CREATE TABLE transportstreams (
@@ -392,35 +397,35 @@ CREATE TABLE transportstreams (
 
 
 --
--- Name: eventuid; Type: DEFAULT; Schema: public; Owner: -
+-- Name: events eventuid; Type: DEFAULT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY events ALTER COLUMN eventuid SET DEFAULT nextval('events_eventuid_seq'::regclass);
 
 
 --
--- Name: recordedid; Type: DEFAULT; Schema: public; Owner: -
+-- Name: recorded recordedid; Type: DEFAULT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY recorded ALTER COLUMN recordedid SET DEFAULT nextval('recorded_recordedid_seq'::regclass);
 
 
 --
--- Name: recordingid; Type: DEFAULT; Schema: public; Owner: -
+-- Name: recordings recordingid; Type: DEFAULT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY recordings ALTER COLUMN recordingid SET DEFAULT nextval('recordings_recordingid_seq'::regclass);
 
 
 --
--- Name: scheduleid; Type: DEFAULT; Schema: public; Owner: -
+-- Name: schedules scheduleid; Type: DEFAULT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY schedules ALTER COLUMN scheduleid SET DEFAULT nextval('schedules_scheduleid_seq'::regclass);
 
 
 --
--- Name: pk_delivery_dvbc; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: delivery_dvbc pk_delivery_dvbc; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY delivery_dvbc
@@ -428,7 +433,7 @@ ALTER TABLE ONLY delivery_dvbc
 
 
 --
--- Name: pk_delivery_dvbs; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: delivery_dvbs pk_delivery_dvbs; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY delivery_dvbs
@@ -436,7 +441,7 @@ ALTER TABLE ONLY delivery_dvbs
 
 
 --
--- Name: pk_delivery_dvbt; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: delivery_dvbt pk_delivery_dvbt; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY delivery_dvbt
@@ -444,7 +449,7 @@ ALTER TABLE ONLY delivery_dvbt
 
 
 --
--- Name: pk_events; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: events pk_events; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY events
@@ -452,7 +457,7 @@ ALTER TABLE ONLY events
 
 
 --
--- Name: pk_networks; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: networks pk_networks; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY networks
@@ -460,7 +465,7 @@ ALTER TABLE ONLY networks
 
 
 --
--- Name: pk_recorded; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: recorded pk_recorded; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY recorded
@@ -468,7 +473,7 @@ ALTER TABLE ONLY recorded
 
 
 --
--- Name: pk_recordings; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: recordings pk_recordings; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY recordings
@@ -476,7 +481,7 @@ ALTER TABLE ONLY recordings
 
 
 --
--- Name: pk_records; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: record pk_records; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY record
@@ -484,7 +489,7 @@ ALTER TABLE ONLY record
 
 
 --
--- Name: pk_schedules; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: schedules pk_schedules; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY schedules
@@ -492,7 +497,7 @@ ALTER TABLE ONLY schedules
 
 
 --
--- Name: pk_services; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: services pk_services; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY services
@@ -500,7 +505,7 @@ ALTER TABLE ONLY services
 
 
 --
--- Name: pk_transportstreams; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
+-- Name: transportstreams pk_transportstreams; Type: CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY transportstreams
@@ -508,56 +513,56 @@ ALTER TABLE ONLY transportstreams
 
 
 --
--- Name: idx_event_search; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+-- Name: idx_event_search; Type: INDEX; Schema: public; Owner: -
 --
 
 CREATE INDEX idx_event_search ON events USING gin (event_tsvector(events.*));
 
 
 --
--- Name: idx_event_title; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+-- Name: idx_event_title; Type: INDEX; Schema: public; Owner: -
 --
 
 CREATE INDEX idx_event_title ON events USING btree (lower(title));
 
 
 --
--- Name: idx_events_timerange; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+-- Name: idx_events_timerange; Type: INDEX; Schema: public; Owner: -
 --
 
 CREATE INDEX idx_events_timerange ON events USING gist (tsrange(starttime, stoptime));
 
 
 --
--- Name: idx_recorded_schedule; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+-- Name: idx_recorded_schedule; Type: INDEX; Schema: public; Owner: -
 --
 
 CREATE INDEX idx_recorded_schedule ON recorded USING btree (scheduleid);
 
 
 --
--- Name: idx_recordings_schedule; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+-- Name: idx_recordings_schedule; Type: INDEX; Schema: public; Owner: -
 --
 
 CREATE INDEX idx_recordings_schedule ON recordings USING btree (scheduleid);
 
 
 --
--- Name: uni_events_serviceevent; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+-- Name: uni_events_serviceevent; Type: INDEX; Schema: public; Owner: -
 --
 
 CREATE UNIQUE INDEX uni_events_serviceevent ON events USING btree (serviceid, eventid) WHERE current;
 
 
 --
--- Name: uni_recordings_storage; Type: INDEX; Schema: public; Owner: -; Tablespace: 
+-- Name: uni_recordings_storage; Type: INDEX; Schema: public; Owner: -
 --
 
 CREATE UNIQUE INDEX uni_recordings_storage ON recordings USING btree (storageaddress, guid);
 
 
 --
--- Name: fk_delivery_dvbc_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: delivery_dvbc fk_delivery_dvbc_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY delivery_dvbc
@@ -565,7 +570,7 @@ ALTER TABLE ONLY delivery_dvbc
 
 
 --
--- Name: fk_delivery_dvbs_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: delivery_dvbs fk_delivery_dvbs_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY delivery_dvbs
@@ -573,7 +578,7 @@ ALTER TABLE ONLY delivery_dvbs
 
 
 --
--- Name: fk_delivery_dvbt_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: delivery_dvbt fk_delivery_dvbt_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY delivery_dvbt
@@ -581,7 +586,7 @@ ALTER TABLE ONLY delivery_dvbt
 
 
 --
--- Name: fk_record_eventuid; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: record fk_record_eventuid; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY record
@@ -589,7 +594,7 @@ ALTER TABLE ONLY record
 
 
 --
--- Name: fk_recorded_eventuid; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: recorded fk_recorded_eventuid; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY recorded
@@ -597,7 +602,7 @@ ALTER TABLE ONLY recorded
 
 
 --
--- Name: fk_recorded_schedule; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: recorded fk_recorded_schedule; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY recorded
@@ -605,7 +610,7 @@ ALTER TABLE ONLY recorded
 
 
 --
--- Name: fk_recordings_eventuid; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: recordings fk_recordings_eventuid; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY recordings
@@ -613,7 +618,7 @@ ALTER TABLE ONLY recordings
 
 
 --
--- Name: fk_records_schedule; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: record fk_records_schedule; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY record
@@ -621,7 +626,7 @@ ALTER TABLE ONLY record
 
 
 --
--- Name: fk_schedule_event; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: schedules fk_schedule_event; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY schedules
@@ -629,7 +634,7 @@ ALTER TABLE ONLY schedules
 
 
 --
--- Name: fk_schedule_service; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: schedules fk_schedule_service; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY schedules
@@ -637,7 +642,7 @@ ALTER TABLE ONLY schedules
 
 
 --
--- Name: fk_services_transportstreams; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: services fk_services_transportstreams; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY services
@@ -645,7 +650,7 @@ ALTER TABLE ONLY services
 
 
 --
--- Name: fk_transportstreams_network; Type: FK CONSTRAINT; Schema: public; Owner: -
+-- Name: transportstreams fk_transportstreams_network; Type: FK CONSTRAINT; Schema: public; Owner: -
 --
 
 ALTER TABLE ONLY transportstreams