Mercurial > lada > lada-server
comparison db_schema/lada_schema.sql @ 995:c21d2e3c988a schema-update
Removed obsolete search_path statements.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 01 Jul 2016 18:00:29 +0200 |
| parents | 5886384dcb92 |
| children | f77a9e85b122 |
comparison
equal
deleted
inserted
replaced
| 994:5886384dcb92 | 995:c21d2e3c988a |
|---|---|
| 449 -- | 449 -- |
| 450 | 450 |
| 451 ALTER TABLE ONLY status_protokoll ALTER COLUMN datum SET DEFAULT now(); | 451 ALTER TABLE ONLY status_protokoll ALTER COLUMN datum SET DEFAULT now(); |
| 452 | 452 |
| 453 | 453 |
| 454 SET search_path = land, pg_catalog; | |
| 455 | |
| 456 -- | 454 -- |
| 457 -- Name: datum; Type: DEFAULT; Schema: land; Owner: - | 455 -- Name: datum; Type: DEFAULT; Schema: land; Owner: - |
| 458 -- | 456 -- |
| 459 | 457 |
| 460 ALTER TABLE ONLY kommentar_m ALTER COLUMN datum SET DEFAULT now(); | 458 ALTER TABLE ONLY kommentar_m ALTER COLUMN datum SET DEFAULT now(); |
| 601 | 599 |
| 602 ALTER TABLE ONLY zusatz_wert | 600 ALTER TABLE ONLY zusatz_wert |
| 603 ADD CONSTRAINT zusatz_wert_probe_id_pzs_id_key UNIQUE (probe_id, pzs_id); | 601 ADD CONSTRAINT zusatz_wert_probe_id_pzs_id_key UNIQUE (probe_id, pzs_id); |
| 604 | 602 |
| 605 | 603 |
| 606 SET search_path = land, pg_catalog; | |
| 607 | |
| 608 -- | 604 -- |
| 609 -- Name: messung_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: | 605 -- Name: messung_probe_id_idx; Type: INDEX; Schema: land; Owner: -; Tablespace: |
| 610 -- | 606 -- |
| 611 | 607 |
| 612 CREATE INDEX messung_probe_id_idx ON messung USING btree (probe_id); | 608 CREATE INDEX messung_probe_id_idx ON messung USING btree (probe_id); |
| 630 -- Name: tree_timestamp_status; Type: TRIGGER; Schema: land; Owner: - | 626 -- Name: tree_timestamp_status; Type: TRIGGER; Schema: land; Owner: - |
| 631 -- | 627 -- |
| 632 | 628 |
| 633 CREATE TRIGGER tree_timestamp_status BEFORE UPDATE ON status_protokoll FOR EACH ROW EXECUTE PROCEDURE update_time_status(); | 629 CREATE TRIGGER tree_timestamp_status BEFORE UPDATE ON status_protokoll FOR EACH ROW EXECUTE PROCEDURE update_time_status(); |
| 634 | 630 |
| 635 | |
| 636 SET search_path = land, pg_catalog; | |
| 637 | 631 |
| 638 -- | 632 -- |
| 639 -- Name: tree_timestamp_messung; Type: TRIGGER; Schema: land; Owner: - | 633 -- Name: tree_timestamp_messung; Type: TRIGGER; Schema: land; Owner: - |
| 640 -- | 634 -- |
| 641 | 635 |