Mercurial > lada > lada-server
diff 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 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Mon Sep 19 12:14:46 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Tue Sep 20 10:13:43 2016 +0200 @@ -639,6 +639,18 @@ ); -- Status workflow +-- Mappings for import + +CREATE TABLE messprogramm_transfer ( + id serial PRIMARY KEY, + messprogramm_s character varying(1) NOT NULL, + messprogramm_c character varying(100) NOT NULL, + ba_id integer NOT NULL REFERENCES betriebsart, + datenbasis_id integer NOT NULL REFERENCES datenbasis, + UNIQUE (messprogramm_s) +); + +-- Mappings for import CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom);