 
 
 --
+-- Name: PowerMeterEvents_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
+--
+
+ALTER TABLE ONLY "PowerMeterEvents"
+    ADD CONSTRAINT "PowerMeterEvents_pkey" PRIMARY KEY (id, event_time);
+
+
+--
 -- Name: Reading_pkey; Type: CONSTRAINT; Schema: public; Owner: sepgroup; Tablespace: 
 --
 



--
-- Name: az_houses_all_with_smart_meter; Type: ACL; Schema: public; Owner: eileen
--




--
-- Name: az_noaa_weather_data; Type: ACL; Schema: public; Owner: eileen
--

REVOKE ALL ON TABLE az_noaa_weather_data FROM PUBLIC;
REVOKE ALL ON TABLE az_noaa_weather_data FROM eileen;
GRANT ALL ON TABLE az_noaa_weather_data TO eileen;
GRANT ALL ON TABLE az_noaa_weather_data TO sepgroup;
GRANT SELECT ON TABLE az_noaa_weather_data TO sepgroupreadonly;


--
-- 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;
GRANT SELECT ON TABLE readings_by_meter_location_history TO sepgroupreadonly;


--
-- Name: cd_readings_channel_as_columns_by_service_point; Type: ACL; Schema: public; Owner: eileen
--

REVOKE ALL ON TABLE cd_readings_channel_as_columns_by_service_point FROM PUBLIC;
REVOKE ALL ON TABLE cd_readings_channel_as_columns_by_service_point FROM eileen;
GRANT ALL ON TABLE cd_readings_channel_as_columns_by_service_point TO eileen;
GRANT ALL ON TABLE cd_readings_channel_as_columns_by_service_point TO sepgroup;
GRANT SELECT ON TABLE cd_readings_channel_as_columns_by_service_point TO sepgroupreadonly;


--
-- Name: az_readings_channel_as_columns_by_spid; Type: ACL; Schema: public; Owner: eileen
--

REVOKE ALL ON TABLE az_readings_channel_as_columns_by_spid FROM PUBLIC;
REVOKE ALL ON TABLE az_readings_channel_as_columns_by_spid FROM eileen;
GRANT ALL ON TABLE az_readings_channel_as_columns_by_spid TO eileen;
GRANT ALL ON TABLE az_readings_channel_as_columns_by_spid TO sepgroup;
GRANT SELECT ON TABLE az_readings_channel_as_columns_by_spid TO sepgroupreadonly;


--
-- Name: readings_by_meter_location_history_new_spid; Type: ACL; Schema: public; Owner: eileen
--

REVOKE ALL ON TABLE readings_by_meter_location_history_new_spid FROM PUBLIC;
REVOKE ALL ON TABLE readings_by_meter_location_history_new_spid FROM eileen;
GRANT ALL ON TABLE readings_by_meter_location_history_new_spid TO eileen;
GRANT ALL ON TABLE readings_by_meter_location_history_new_spid TO sepgroup;
GRANT SELECT ON TABLE readings_by_meter_location_history_new_spid TO sepgroupreadonly;


--
-- Name: readings_channel_as_columns_by_new_spid; Type: ACL; Schema: public; Owner: eileen
--

REVOKE ALL ON TABLE readings_channel_as_columns_by_new_spid FROM PUBLIC;
REVOKE ALL ON TABLE readings_channel_as_columns_by_new_spid FROM eileen;
GRANT ALL ON TABLE readings_channel_as_columns_by_new_spid TO eileen;
GRANT ALL ON TABLE readings_channel_as_columns_by_new_spid TO sepgroup;
GRANT SELECT ON TABLE readings_channel_as_columns_by_new_spid TO sepgroupreadonly;


--
-- Name: az_readings_channels_as_columns_new_spid; Type: ACL; Schema: public; Owner: eileen
--

REVOKE ALL ON TABLE az_readings_channels_as_columns_new_spid FROM PUBLIC;
REVOKE ALL ON TABLE az_readings_channels_as_columns_new_spid FROM eileen;
GRANT ALL ON TABLE az_readings_channels_as_columns_new_spid TO eileen;
GRANT ALL ON TABLE az_readings_channels_as_columns_new_spid TO sepgroup;
GRANT SELECT ON TABLE az_readings_channels_as_columns_new_spid TO sepgroupreadonly;


--
