 
 
 --
--- Name: dz_energy_voltages_for_houses_without_pv; Type: ACL; Schema: public; Owner: postgres
+-- Name: dz_energy_voltages_for_houses_without_pv; Type: ACL; Schema: public; Owner: daniel
 --
 
 REVOKE ALL ON TABLE dz_energy_voltages_for_houses_without_pv FROM PUBLIC;
-REVOKE ALL ON TABLE dz_energy_voltages_for_houses_without_pv FROM postgres;
+REVOKE ALL ON TABLE dz_energy_voltages_for_houses_without_pv FROM daniel;
+GRANT ALL ON TABLE dz_energy_voltages_for_houses_without_pv TO daniel;
 GRANT ALL ON TABLE dz_energy_voltages_for_houses_without_pv TO postgres;
 GRANT ALL ON TABLE dz_energy_voltages_for_houses_without_pv TO sepgroup;
 

REVOKE ALL ON TABLE "IntervalReadData" FROM PUBLIC;
REVOKE ALL ON TABLE "IntervalReadData" FROM sepgroup;
GRANT ALL ON TABLE "IntervalReadData" TO sepgroup;


--



ALTER TABLE public."IntervalReadData" OWNER TO sepgroup;

--
-- Name: IrradianceData; Type: TABLE; Schema: public; Owner: eileen; Tablespace: 
--

CREATE TABLE "IrradianceData" (
    sensor_id integer NOT NULL,
    irradiance_w_per_m2 double precision,
    "timestamp" timestamp without time zone NOT NULL
);


ALTER TABLE public."IrradianceData" OWNER TO eileen;

--
-- Name: IrradianceSensorInfo; Type: TABLE; Schema: public; Owner: eileen; Tablespace: 
--

CREATE TABLE "IrradianceSensorInfo" (
    sensor_id integer NOT NULL,
    latitude double precision,
    longitude double precision,
    manufacturer character varying,
    model character varying
);


ALTER TABLE public."IrradianceSensorInfo" OWNER TO eileen;

--
-- Name: LocationRecords; Type: TABLE; Schema: public; Owner: sepgroup; Tablespace: 
