diff options
| -rw-r--r-- | p2pvr/datasources/schema.sql | 62 |
1 files changed, 0 insertions, 62 deletions
diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql index fce7a4f..393325d 100644 --- a/p2pvr/datasources/schema.sql +++ b/p2pvr/datasources/schema.sql @@ -128,17 +128,6 @@ CREATE TABLE delivery_dvbt ( -- --- Name: event_schedule; Type: TABLE; Schema: public; Owner: -; Tablespace: --- - -CREATE TABLE event_schedule ( - serviceid integer NOT NULL, - eventid integer NOT NULL, - scheduleid integer NOT NULL -); - - --- -- Name: networks; Type: TABLE; Schema: public; Owner: -; Tablespace: -- @@ -286,17 +275,6 @@ CREATE TABLE services ( -- --- Name: servicestreams; Type: TABLE; Schema: public; Owner: -; Tablespace: --- - -CREATE TABLE servicestreams ( - serviceid integer NOT NULL, - id integer NOT NULL, - type smallint NOT NULL -); - - --- -- Name: transportstreams; Type: TABLE; Schema: public; Owner: -; Tablespace: -- @@ -361,14 +339,6 @@ ALTER TABLE ONLY events -- --- Name: pk_eventschedule; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: --- - -ALTER TABLE ONLY event_schedule - ADD CONSTRAINT pk_eventschedule PRIMARY KEY (eventid, scheduleid); - - --- -- Name: pk_networks; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- @@ -417,14 +387,6 @@ ALTER TABLE ONLY services -- --- Name: pk_servicestreams; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: --- - -ALTER TABLE ONLY servicestreams - ADD CONSTRAINT pk_servicestreams PRIMARY KEY (serviceid, id); - - --- -- Name: pk_transportstreams; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- @@ -527,22 +489,6 @@ ALTER TABLE ONLY delivery_dvbt -- --- Name: fk_eventschedule; Type: FK CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY event_schedule - ADD CONSTRAINT fk_eventschedule FOREIGN KEY (serviceid, eventid) REFERENCES events(serviceid, eventid) ON DELETE CASCADE; - - --- --- Name: fk_eventschedule_schedule; Type: FK CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY event_schedule - ADD CONSTRAINT fk_eventschedule_schedule FOREIGN KEY (scheduleid) REFERENCES schedules(scheduleid) ON UPDATE CASCADE ON DELETE CASCADE; - - --- -- Name: fk_recorded_schedule; Type: FK CONSTRAINT; Schema: public; Owner: - -- @@ -591,14 +537,6 @@ ALTER TABLE ONLY services -- --- Name: fk_servicestreams_service; Type: FK CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY servicestreams - ADD CONSTRAINT fk_servicestreams_service FOREIGN KEY (serviceid) REFERENCES services(serviceid) ON UPDATE CASCADE ON DELETE CASCADE; - - --- -- Name: fk_transportstreams_network; Type: FK CONSTRAINT; Schema: public; Owner: - -- |