Mercurial > lada > lada-server
comparison db_schema/stammdaten_schema.sql @ 1051:9615be7b1626 schema-update
Added new table for messprogramm mappings.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Tue, 20 Sep 2016 10:13:43 +0200 |
| parents | 1c6c83037b8c |
| children | 1868bd3565bf |
comparison
equal
deleted
inserted
replaced
| 1050:28d2d5be7e03 | 1051:9615be7b1626 |
|---|---|
| 637 JOIN stammdaten.status_kombi zu | 637 JOIN stammdaten.status_kombi zu |
| 638 ON zu.id = r.zu_id | 638 ON zu.id = r.zu_id |
| 639 ); | 639 ); |
| 640 -- Status workflow | 640 -- Status workflow |
| 641 | 641 |
| 642 -- Mappings for import | |
| 643 | |
| 644 CREATE TABLE messprogramm_transfer ( | |
| 645 id serial PRIMARY KEY, | |
| 646 messprogramm_s character varying(1) NOT NULL, | |
| 647 messprogramm_c character varying(100) NOT NULL, | |
| 648 ba_id integer NOT NULL REFERENCES betriebsart, | |
| 649 datenbasis_id integer NOT NULL REFERENCES datenbasis, | |
| 650 UNIQUE (messprogramm_s) | |
| 651 ); | |
| 652 | |
| 653 -- Mappings for import | |
| 642 | 654 |
| 643 CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom); | 655 CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom); |
| 644 | 656 |
| 645 | 657 |
| 646 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id); | 658 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id); |