Mercurial > lada > lada-server
changeset 1004:c0ff3965c266 schema-update
Added index for "child"-tables and removed index for probe.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Fri, 01 Jul 2016 19:51:41 +0200 |
parents | 552215760ba8 |
children | e9116ec4eb40 |
files | db_schema/lada_schema.sql |
diffstat | 1 files changed, 30 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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;