From 7035e2f268a3cc2e8f7024409cada48099b729e1 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Tue, 1 Aug 2017 19:13:22 +0100 Subject: Update schema as dumped by a recent pg_dump --- p2pvr/datasources/schema.sql | 95 +++++++++++++++++++++++--------------------- 1 file 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 -- cgit v1.2.3