From da8dca7935e6fd5e78adb7d5e25d86a0b523be5f Mon Sep 17 00:00:00 2001 From: randomdan Date: Wed, 9 Apr 2014 20:14:51 +0000 Subject: Remove dead tables --- p2pvr/datasources/schema.sql | 62 -------------------------------------------- 1 file changed, 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 @@ -127,17 +127,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: -- @@ -285,17 +274,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: -- @@ -360,14 +338,6 @@ ALTER TABLE ONLY events ADD CONSTRAINT pk_events PRIMARY KEY (serviceid, eventid); --- --- 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: -- @@ -416,14 +386,6 @@ ALTER TABLE ONLY services ADD CONSTRAINT pk_services PRIMARY KEY (serviceid); --- --- 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: -- @@ -526,22 +488,6 @@ ALTER TABLE ONLY delivery_dvbt ADD CONSTRAINT fk_delivery_dvbt_transportstream FOREIGN KEY (transportstreamid) REFERENCES transportstreams(transportstreamid) ON UPDATE CASCADE ON DELETE CASCADE; --- --- 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: - -- @@ -590,14 +536,6 @@ ALTER TABLE ONLY services ADD CONSTRAINT fk_services_transportstreams FOREIGN KEY (transportstreamid) REFERENCES transportstreams(transportstreamid) ON UPDATE CASCADE ON DELETE CASCADE; --- --- 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: - -- -- cgit v1.2.3