# HG changeset patch # User Raimund Renkert # Date 1467395501 -7200 # Node ID c0ff3965c266bec4e4d3bff7a05a915d2ad88fa5 # Parent 552215760ba82b2887384b42e159961427392291 Added index for "child"-tables and removed index for probe. diff -r 552215760ba8 -r c0ff3965c266 db_schema/lada_schema.sql --- a/db_schema/lada_schema.sql Fri Jul 01 19:47:21 2016 +0200 +++ b/db_schema/lada_schema.sql Fri Jul 01 19:51:41 2016 +0200 @@ -411,6 +411,27 @@ -- +-- Name: ort_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: +-- + +CREATE INDEX ort_probe_id_idx ON ortszuordnung USING btree (probe_id); + + +-- +-- Name: zusatz_wert_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: +-- + +CREATE INDEX zusatz_wert_probe_id_idx ON zusatz_wert USING btree (probe_id); + + +-- +-- Name: kommentar_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: +-- + +CREATE INDEX kommentar_probe_id_idx ON kommentar_p USING btree (probe_id); + + +-- -- Name: messwert_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: -- @@ -418,10 +439,17 @@ -- --- Name: probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: +-- Name: status_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: -- -CREATE INDEX probe_id_idx ON probe USING btree (id); +CREATE INDEX status_messungs_id_idx ON status_protokoll USING btree (messungs_id); + + +-- +-- Name: kommentar_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: +-- + +CREATE INDEX kommentar_messungs_id_idx ON kommentar_m USING btree (messungs_id); COMMIT;