Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1055:37952c111f71 | 1056:299f4ba86090 |
|---|---|
| 229 ); | 229 ); |
| 230 CREATE TRIGGER letzte_aenderung_datensatz_erzeuger BEFORE UPDATE ON datensatz_erzeuger FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); | 230 CREATE TRIGGER letzte_aenderung_datensatz_erzeuger BEFORE UPDATE ON datensatz_erzeuger FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); |
| 231 | 231 |
| 232 ALTER SEQUENCE datensatz_erzeuger_id_seq OWNED BY datensatz_erzeuger.id; | 232 ALTER SEQUENCE datensatz_erzeuger_id_seq OWNED BY datensatz_erzeuger.id; |
| 233 | 233 |
| 234 | |
| 235 CREATE SEQUENCE de_vg_id_seq | |
| 236 START WITH 1 | |
| 237 INCREMENT BY 1 | |
| 238 NO MINVALUE | |
| 239 NO MAXVALUE | |
| 240 CACHE 1; | |
| 241 | |
| 242 CREATE TABLE de_vg ( | |
| 243 id integer PRIMARY KEY DEFAULT nextval('de_vg_id_seq'::regclass), | |
| 244 use double precision, | |
| 245 rs character varying(12), | |
| 246 gf double precision, | |
| 247 rau_rs character varying(12), | |
| 248 gen character varying(50), | |
| 249 des character varying(75), | |
| 250 isn double precision, | |
| 251 bemerk character varying(75), | |
| 252 nambild character varying(16), | |
| 253 ags character varying(12), | |
| 254 rs_alt character varying(20), | |
| 255 wirksamkei date, | |
| 256 debkg_id character varying(16), | |
| 257 length numeric, | |
| 258 shape_area numeric, | |
| 259 geom public.geometry(MultiPolygon,4326) | |
| 260 ); | |
| 261 | |
| 262 ALTER SEQUENCE de_vg_id_seq OWNED BY de_vg.id; | |
| 263 | |
| 264 | |
| 265 CREATE TABLE deskriptor_umwelt ( | 234 CREATE TABLE deskriptor_umwelt ( |
| 266 id integer PRIMARY KEY, | 235 id integer PRIMARY KEY, |
| 267 s00 integer NOT NULL, | 236 s00 integer NOT NULL, |
| 268 s01 integer NOT NULL, | 237 s01 integer NOT NULL, |
| 269 s02 integer, | 238 s02 integer, |
| 807 | 776 |
| 808 ALTER TABLE ONLY umwelt | 777 ALTER TABLE ONLY umwelt |
| 809 ADD CONSTRAINT umwelt_umwelt_bereich_key UNIQUE (umwelt_bereich); | 778 ADD CONSTRAINT umwelt_umwelt_bereich_key UNIQUE (umwelt_bereich); |
| 810 | 779 |
| 811 | 780 |
| 812 CREATE INDEX de_vg_geom_gist ON de_vg USING gist (geom); | |
| 813 | |
| 814 | |
| 815 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id); | 781 CREATE INDEX fts_stauts_kooin10001 ON staat USING btree (kda_id); |
| 816 | 782 |
| 817 | 783 |
| 818 | 784 |
| 819 ALTER TABLE ONLY auth | 785 ALTER TABLE ONLY auth |