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



--
-- Name: deprecated_YU_energy_to_houses_without_PV_copy; Type: ACL; Schema: public; Owner: yuma
--

REVOKE ALL ON TABLE "deprecated_YU_energy_to_houses_without_PV_copy" FROM PUBLIC;
REVOKE ALL ON TABLE "deprecated_YU_energy_to_houses_without_PV_copy" FROM yuma;
GRANT ALL ON TABLE "deprecated_YU_energy_to_houses_without_PV_copy" TO yuma;
GRANT ALL ON TABLE "deprecated_YU_energy_to_houses_without_PV_copy" TO sepgroup;


--
-- Name: deprecated_meter_ids_for_houses_without_pv_with_locations; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE deprecated_meter_ids_for_houses_without_pv_with_locations FROM PUBLIC;
REVOKE ALL ON TABLE deprecated_meter_ids_for_houses_without_pv_with_locations FROM postgres;
GRANT ALL ON TABLE deprecated_meter_ids_for_houses_without_pv_with_locations TO postgres;
GRANT ALL ON TABLE deprecated_meter_ids_for_houses_without_pv_with_locations TO sepgroup;


--
-- Name: deprecated_dz_energy_voltages_for_houses_without_pv; Type: ACL; Schema: public; Owner: daniel
--

REVOKE ALL ON TABLE deprecated_dz_energy_voltages_for_houses_without_pv FROM PUBLIC;
REVOKE ALL ON TABLE deprecated_dz_energy_voltages_for_houses_without_pv FROM daniel;
GRANT ALL ON TABLE deprecated_dz_energy_voltages_for_houses_without_pv TO daniel;
GRANT ALL ON TABLE deprecated_dz_energy_voltages_for_houses_without_pv TO postgres;
GRANT ALL ON TABLE deprecated_dz_energy_voltages_for_houses_without_pv TO sepgroup;


--
-- Name: deprecated_get_kwh_meter_locations; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE deprecated_get_kwh_meter_locations FROM PUBLIC;
REVOKE ALL ON TABLE deprecated_get_kwh_meter_locations FROM postgres;
GRANT ALL ON TABLE deprecated_get_kwh_meter_locations TO postgres;
GRANT ALL ON TABLE deprecated_get_kwh_meter_locations TO sepgroup;


--
-- Name: deprecated_get_meter_readings_locations; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE deprecated_get_meter_readings_locations FROM PUBLIC;
REVOKE ALL ON TABLE deprecated_get_meter_readings_locations FROM postgres;
GRANT ALL ON TABLE deprecated_get_meter_readings_locations TO postgres;
GRANT ALL ON TABLE deprecated_get_meter_readings_locations TO sepgroup;


--
-- Name: deprecated_new_energy_readings_with_location_address; Type: ACL; Schema: public; Owner: postgres
--

REVOKE ALL ON TABLE deprecated_new_energy_readings_with_location_address FROM PUBLIC;
REVOKE ALL ON TABLE deprecated_new_energy_readings_with_location_address FROM postgres;
GRANT ALL ON TABLE deprecated_new_energy_readings_with_location_address TO postgres;
GRANT ALL ON TABLE deprecated_new_energy_readings_with_location_address TO sepgroup;


--
-- Name: deprecated_readings_by_meter_location_history; Type: ACL; Schema: public; Owner: daniel
--

REVOKE ALL ON TABLE deprecated_readings_by_meter_location_history FROM PUBLIC;
REVOKE ALL ON TABLE deprecated_readings_by_meter_location_history FROM daniel;
GRANT ALL ON TABLE deprecated_readings_by_meter_location_history TO daniel;
GRANT ALL ON TABLE deprecated_readings_by_meter_location_history TO sepgroup;


--
-- Name: meter_ids_for_houses_without_pv; Type: ACL; Schema: public; Owner: postgres
--


    house_service_point_id character varying,
    "PV_Mod_size_kW" double precision,
    inverter_model character varying,
    "size_kW" real,
    "system_cap_kW" real,
    bat character varying,
    sub character varying,
    circuit smallint,
    date_uploaded timestamp without time zone,
    has_meter smallint,
    has_separate_pv_meter smallint,
    "add_cap_kW" real,
    upgraded_total_kw real,
    street character varying,
    city character varying,
    state character varying,
    zip integer
);


