 
 
 --
+-- Name: cd_energy_voltages_for_houses_with_pv; Type: ACL; Schema: public; Owner: eileen
+--
+
+REVOKE ALL ON TABLE cd_energy_voltages_for_houses_with_pv FROM PUBLIC;
+REVOKE ALL ON TABLE cd_energy_voltages_for_houses_with_pv FROM eileen;
+GRANT ALL ON TABLE cd_energy_voltages_for_houses_with_pv TO eileen;
+GRANT ALL ON TABLE cd_energy_voltages_for_houses_with_pv TO sepgroup;
+
+
+--
+-- Name: count_of_event_duplicates; Type: ACL; Schema: public; Owner: daniel
+--
+
+REVOKE ALL ON TABLE count_of_event_duplicates FROM PUBLIC;
+REVOKE ALL ON TABLE count_of_event_duplicates FROM daniel;
+GRANT ALL ON TABLE count_of_event_duplicates TO daniel;
+GRANT ALL ON TABLE count_of_event_duplicates TO sepgroup;
+
+
+--
 -- Name: count_of_readings_and_meters_by_day; Type: ACL; Schema: public; Owner: daniel
 --
 



SET search_path = public, pg_catalog;

SET default_tablespace = '';




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: 
