Don't specify the owner in the schema

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;