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;
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)