Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1056:299f4ba86090
extend docker envireoment to load geographical data of german comunities
author | Michael Stanko <mstanko@bfs.de> |
---|---|
date | Wed, 28 Sep 2016 09:06:18 +0200 |
parents | 5efb32a41b24 |
children | effef57f3f7e |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Wed Sep 28 08:48:04 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Wed Sep 28 09:06:18 2016 +0200 @@ -231,37 +231,6 @@ ALTER SEQUENCE datensatz_erzeuger_id_seq OWNED BY datensatz_erzeuger.id; - -CREATE SEQUENCE de_vg_id_seq - START WITH 1 - INCREMENT BY 1 - NO MINVALUE - NO MAXVALUE - CACHE 1; - -CREATE TABLE de_vg ( - id integer PRIMARY KEY DEFAULT nextval('de_vg_id_seq'::regclass), - 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) -); - -ALTER SEQUENCE de_vg_id_seq OWNED BY de_vg.id; - - CREATE TABLE deskriptor_umwelt ( id integer PRIMARY KEY, s00 integer NOT NULL, @@ -809,9 +778,6 @@ ADD CONSTRAINT umwelt_umwelt_bereich_key UNIQUE (umwelt_bereich); -CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom); - - CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id);