 --
 
 CREATE UNIQUE INDEX reading_id_idx ON "Reading" USING btree (reading_id);
+
+
+--
+-- Name: service_point_id_idx; Type: INDEX; Schema: public; Owner: daniel; Tablespace: 
+--
+
+CREATE INDEX service_point_id_idx ON "MeterLocationHistory" USING btree (service_point_id);
 
 
 --



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

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


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

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


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

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


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




--
-- Name: installed_uninstalled_idx; Type: INDEX; Schema: public; Owner: daniel; Tablespace: 
--

CREATE INDEX installed_uninstalled_idx ON "MeterLocationHistory" USING btree (installed, uninstalled);


--
-- Name: interval_id_idx; Type: INDEX; Schema: public; Owner: sepgroup; Tablespace: 
--

