diff options
| -rw-r--r-- | p2pvr/datasources/schema.sql | 154 |
1 files changed, 60 insertions, 94 deletions
diff --git a/p2pvr/datasources/schema.sql b/p2pvr/datasources/schema.sql index e19c597..126286d 100644 --- a/p2pvr/datasources/schema.sql +++ b/p2pvr/datasources/schema.sql @@ -10,14 +10,14 @@ SET check_function_bodies = false; SET client_min_messages = warning; -- --- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: +-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- --- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: +-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: - -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; @@ -30,7 +30,7 @@ SET default_tablespace = ''; SET default_with_oids = false; -- --- Name: events; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: events; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE events ( @@ -61,10 +61,8 @@ CREATE TABLE events ( ); -ALTER TABLE public.events OWNER TO gentoo; - -- --- Name: event_tsvector(events); Type: FUNCTION; Schema: public; Owner: gentoo +-- Name: event_tsvector(events); Type: FUNCTION; Schema: public; Owner: - -- CREATE FUNCTION event_tsvector(e events) RETURNS tsvector @@ -76,10 +74,8 @@ select (setweight(to_tsvector('english', e.title), 'A') || $$; -ALTER FUNCTION public.event_tsvector(e events) OWNER TO gentoo; - -- --- Name: delivery_dvbc; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: delivery_dvbc; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE delivery_dvbc ( @@ -92,10 +88,8 @@ CREATE TABLE delivery_dvbc ( ); -ALTER TABLE public.delivery_dvbc OWNER TO gentoo; - -- --- Name: delivery_dvbs; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: delivery_dvbs; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE delivery_dvbs ( @@ -112,10 +106,8 @@ CREATE TABLE delivery_dvbs ( ); -ALTER TABLE public.delivery_dvbs OWNER TO gentoo; - -- --- Name: delivery_dvbt; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: delivery_dvbt; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE delivery_dvbt ( @@ -135,10 +127,8 @@ CREATE TABLE delivery_dvbt ( ); -ALTER TABLE public.delivery_dvbt OWNER TO gentoo; - -- --- Name: event_schedule; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: event_schedule; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE event_schedule ( @@ -148,10 +138,8 @@ CREATE TABLE event_schedule ( ); -ALTER TABLE public.event_schedule OWNER TO gentoo; - -- --- Name: networks; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: networks; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE networks ( @@ -160,10 +148,8 @@ CREATE TABLE networks ( ); -ALTER TABLE public.networks OWNER TO gentoo; - -- --- Name: record; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: record; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE record ( @@ -174,10 +160,8 @@ CREATE TABLE record ( ); -ALTER TABLE public.record OWNER TO gentoo; - -- --- Name: recorded; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: recorded; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE recorded ( @@ -191,10 +175,8 @@ CREATE TABLE recorded ( ); -ALTER TABLE public.recorded OWNER TO gentoo; - -- --- Name: recorded_recordedid_seq; Type: SEQUENCE; Schema: public; Owner: gentoo +-- Name: recorded_recordedid_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE recorded_recordedid_seq @@ -205,17 +187,15 @@ CREATE SEQUENCE recorded_recordedid_seq CACHE 1; -ALTER TABLE public.recorded_recordedid_seq OWNER TO gentoo; - -- --- Name: recorded_recordedid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gentoo +-- Name: recorded_recordedid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE recorded_recordedid_seq OWNED BY recorded.recordedid; -- --- Name: recordings; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: recordings; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE recordings ( @@ -231,10 +211,8 @@ CREATE TABLE recordings ( ); -ALTER TABLE public.recordings OWNER TO gentoo; - -- --- Name: recordings_recordingid_seq; Type: SEQUENCE; Schema: public; Owner: gentoo +-- Name: recordings_recordingid_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE recordings_recordingid_seq @@ -245,17 +223,15 @@ CREATE SEQUENCE recordings_recordingid_seq CACHE 1; -ALTER TABLE public.recordings_recordingid_seq OWNER TO gentoo; - -- --- Name: recordings_recordingid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gentoo +-- Name: recordings_recordingid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE recordings_recordingid_seq OWNED BY recordings.recordingid; -- --- Name: schedules; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: schedules; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE schedules ( @@ -271,10 +247,8 @@ CREATE TABLE schedules ( ); -ALTER TABLE public.schedules OWNER TO gentoo; - -- --- Name: schedules_scheduleid_seq; Type: SEQUENCE; Schema: public; Owner: gentoo +-- Name: schedules_scheduleid_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE schedules_scheduleid_seq @@ -285,17 +259,15 @@ CREATE SEQUENCE schedules_scheduleid_seq CACHE 1; -ALTER TABLE public.schedules_scheduleid_seq OWNER TO gentoo; - -- --- Name: schedules_scheduleid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: gentoo +-- Name: schedules_scheduleid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE schedules_scheduleid_seq OWNED BY schedules.scheduleid; -- --- Name: services; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: services; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE services ( @@ -313,10 +285,8 @@ CREATE TABLE services ( ); -ALTER TABLE public.services OWNER TO gentoo; - -- --- Name: servicestreams; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: servicestreams; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE servicestreams ( @@ -326,10 +296,8 @@ CREATE TABLE servicestreams ( ); -ALTER TABLE public.servicestreams OWNER TO gentoo; - -- --- Name: transportstreams; Type: TABLE; Schema: public; Owner: gentoo; Tablespace: +-- Name: transportstreams; Type: TABLE; Schema: public; Owner: -; Tablespace: -- CREATE TABLE transportstreams ( @@ -339,31 +307,29 @@ CREATE TABLE transportstreams ( ); -ALTER TABLE public.transportstreams OWNER TO gentoo; - -- --- Name: recordedid; Type: DEFAULT; Schema: public; Owner: gentoo +-- Name: 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: gentoo +-- Name: 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: gentoo +-- Name: 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: gentoo; Tablespace: +-- Name: pk_delivery_dvbc; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY delivery_dvbc @@ -371,7 +337,7 @@ ALTER TABLE ONLY delivery_dvbc -- --- Name: pk_delivery_dvbs; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_delivery_dvbs; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY delivery_dvbs @@ -379,7 +345,7 @@ ALTER TABLE ONLY delivery_dvbs -- --- Name: pk_delivery_dvbt; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_delivery_dvbt; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY delivery_dvbt @@ -387,7 +353,7 @@ ALTER TABLE ONLY delivery_dvbt -- --- Name: pk_events; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_events; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY events @@ -395,7 +361,7 @@ ALTER TABLE ONLY events -- --- Name: pk_eventschedule; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_eventschedule; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY event_schedule @@ -403,7 +369,7 @@ ALTER TABLE ONLY event_schedule -- --- Name: pk_networks; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_networks; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY networks @@ -411,7 +377,7 @@ ALTER TABLE ONLY networks -- --- Name: pk_recorded; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_recorded; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY recorded @@ -419,7 +385,7 @@ ALTER TABLE ONLY recorded -- --- Name: pk_recordings; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_recordings; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY recordings @@ -427,7 +393,7 @@ ALTER TABLE ONLY recordings -- --- Name: pk_records; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_records; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY record @@ -435,7 +401,7 @@ ALTER TABLE ONLY record -- --- Name: pk_schedules; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_schedules; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY schedules @@ -443,7 +409,7 @@ ALTER TABLE ONLY schedules -- --- Name: pk_services; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_services; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY services @@ -451,7 +417,7 @@ ALTER TABLE ONLY services -- --- Name: pk_servicestreams; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_servicestreams; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY servicestreams @@ -459,7 +425,7 @@ ALTER TABLE ONLY servicestreams -- --- Name: pk_transportstreams; Type: CONSTRAINT; Schema: public; Owner: gentoo; Tablespace: +-- Name: pk_transportstreams; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: -- ALTER TABLE ONLY transportstreams @@ -467,70 +433,70 @@ ALTER TABLE ONLY transportstreams -- --- Name: idx_event_search; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_event_search; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_event_search ON events USING gin ((((setweight(to_tsvector('english'::regconfig, title), 'A'::"char") || setweight(to_tsvector('english'::regconfig, COALESCE(subtitle, ''::text)), 'B'::"char")) || setweight(to_tsvector('english'::regconfig, COALESCE(description, ''::text)), 'C'::"char")))); -- --- Name: idx_event_title; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_event_title; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_event_title ON events USING btree (lower(title)); -- --- Name: idx_recorded_schedule; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_recorded_schedule; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_recorded_schedule ON recorded USING btree (scheduleid); -- --- Name: idx_recorded_starttime; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_recorded_starttime; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_recorded_starttime ON recorded USING btree (starttime); -- --- Name: idx_recorded_title; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_recorded_title; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_recorded_title ON recorded USING btree (title); -- --- Name: idx_recordings_schedule; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_recordings_schedule; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_recordings_schedule ON recordings USING btree (scheduleid); -- --- Name: idx_recordings_starttime; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_recordings_starttime; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_recordings_starttime ON recordings USING btree (starttime); -- --- Name: idx_recordings_title; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: idx_recordings_title; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE INDEX idx_recordings_title ON recordings USING btree (title); -- --- Name: uni_recordings_storage; Type: INDEX; Schema: public; Owner: gentoo; Tablespace: +-- Name: uni_recordings_storage; Type: INDEX; Schema: public; Owner: -; Tablespace: -- CREATE UNIQUE INDEX uni_recordings_storage ON recordings USING btree (storageaddress, guid); -- --- Name: fk_delivery_dvbc_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_delivery_dvbc_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY delivery_dvbc @@ -538,7 +504,7 @@ ALTER TABLE ONLY delivery_dvbc -- --- Name: fk_delivery_dvbs_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_delivery_dvbs_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY delivery_dvbs @@ -546,7 +512,7 @@ ALTER TABLE ONLY delivery_dvbs -- --- Name: fk_delivery_dvbt_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_delivery_dvbt_transportstream; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY delivery_dvbt @@ -554,7 +520,7 @@ ALTER TABLE ONLY delivery_dvbt -- --- Name: fk_eventschedule; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_eventschedule; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY event_schedule @@ -562,7 +528,7 @@ ALTER TABLE ONLY event_schedule -- --- Name: fk_eventschedule_schedule; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_eventschedule_schedule; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY event_schedule @@ -570,7 +536,7 @@ ALTER TABLE ONLY event_schedule -- --- Name: fk_recorded_schedule; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_recorded_schedule; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY recorded @@ -578,7 +544,7 @@ ALTER TABLE ONLY recorded -- --- Name: fk_records_event; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_records_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY record @@ -586,7 +552,7 @@ ALTER TABLE ONLY record -- --- Name: fk_schedule_event; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_schedule_event; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY schedules @@ -594,7 +560,7 @@ ALTER TABLE ONLY schedules -- --- Name: fk_schedule_service; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_schedule_service; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY schedules @@ -602,7 +568,7 @@ ALTER TABLE ONLY schedules -- --- Name: fk_services_transportstreams; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_services_transportstreams; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY services @@ -610,7 +576,7 @@ ALTER TABLE ONLY services -- --- Name: fk_servicestreams_service; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_servicestreams_service; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY servicestreams @@ -618,7 +584,7 @@ ALTER TABLE ONLY servicestreams -- --- Name: fk_transportstreams_network; Type: FK CONSTRAINT; Schema: public; Owner: gentoo +-- Name: fk_transportstreams_network; Type: FK CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY transportstreams @@ -626,7 +592,7 @@ ALTER TABLE ONLY transportstreams -- --- Name: public; Type: ACL; Schema: -; Owner: postgres +-- Name: public; Type: ACL; Schema: -; Owner: - -- REVOKE ALL ON SCHEMA public FROM PUBLIC; |