Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 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 |
comparison
equal
deleted
inserted
replaced
| 1003:552215760ba8 | 1004:c0ff3965c266 |
|---|---|
| 409 | 409 |
| 410 CREATE INDEX messung_probe_id_idx ON messung USING btree (probe_id); | 410 CREATE INDEX messung_probe_id_idx ON messung USING btree (probe_id); |
| 411 | 411 |
| 412 | 412 |
| 413 -- | 413 -- |
| 414 -- Name: ort_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: | |
| 415 -- | |
| 416 | |
| 417 CREATE INDEX ort_probe_id_idx ON ortszuordnung USING btree (probe_id); | |
| 418 | |
| 419 | |
| 420 -- | |
| 421 -- Name: zusatz_wert_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: | |
| 422 -- | |
| 423 | |
| 424 CREATE INDEX zusatz_wert_probe_id_idx ON zusatz_wert USING btree (probe_id); | |
| 425 | |
| 426 | |
| 427 -- | |
| 428 -- Name: kommentar_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: | |
| 429 -- | |
| 430 | |
| 431 CREATE INDEX kommentar_probe_id_idx ON kommentar_p USING btree (probe_id); | |
| 432 | |
| 433 | |
| 434 -- | |
| 414 -- Name: messwert_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: | 435 -- Name: messwert_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: |
| 415 -- | 436 -- |
| 416 | 437 |
| 417 CREATE INDEX messwert_messungs_id_idx ON messwert USING btree (messungs_id); | 438 CREATE INDEX messwert_messungs_id_idx ON messwert USING btree (messungs_id); |
| 418 | 439 |
| 419 | 440 |
| 420 -- | 441 -- |
| 421 -- Name: probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: | 442 -- Name: status_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: |
| 422 -- | 443 -- |
| 423 | 444 |
| 424 CREATE INDEX probe_id_idx ON probe USING btree (id); | 445 CREATE INDEX status_messungs_id_idx ON status_protokoll USING btree (messungs_id); |
| 446 | |
| 447 | |
| 448 -- | |
| 449 -- Name: kommentar_messungs_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: | |
| 450 -- | |
| 451 | |
| 452 CREATE INDEX kommentar_messungs_id_idx ON kommentar_m USING btree (messungs_id); | |
| 425 | 453 |
| 426 | 454 |
| 427 COMMIT; | 455 COMMIT; |