Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1194:289edf060550
Removed table de_vg and added verwaltungsgrenze.
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Tue, 29 Nov 2016 15:57:09 +0100 |
parents | 1bc8ab13e1f7 |
children | 9dda1237c756 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Tue Nov 29 15:54:48 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Tue Nov 29 15:57:09 2016 +0100 @@ -167,7 +167,7 @@ CREATE TABLE verwaltungsgrenze ( id serial PRIMARY KEY, gem_id character varying(8) NOT NULL, - shape public.geometry(MultiPolygon) + shape public.geometry(MultiPolygon, 4326) ); CREATE TABLE netz_betreiber ( @@ -236,26 +236,6 @@ ); CREATE TRIGGER letzte_aenderung_datensatz_erzeuger BEFORE UPDATE ON datensatz_erzeuger FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); -CREATE TABLE de_vg ( - id serial PRIMARY KEY, - use double precision, - rs character varying(12), - gf double precision, - rau_rs character varying(12), - gen character varying(50), - des character varying(75), - isn double precision, - bemerk character varying(75), - nambild character varying(16), - ags character varying(12), - rs_alt character varying(20), - wirksamkei date, - debkg_id character varying(16), - length numeric, - shape_area numeric, - geom public.geometry(MultiPolygon,4326) -); - CREATE TABLE deskriptor_umwelt ( id serial PRIMARY KEY,