diff db_schema/lada_schema.sql @ 1120:7061388e0af7

Rev d1d7d684800c missed to adapt default FK value.
author Tom Gottfried <tom@intevation.de>
date Fri, 28 Oct 2016 16:49:47 +0200
parents 186d602e031a
children 1ef08710aaeb
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Fri Oct 28 11:58:52 2016 +0200
+++ b/db_schema/lada_schema.sql	Fri Oct 28 16:49:47 2016 +0200
@@ -119,7 +119,7 @@
     mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle,
     labor_mst_id character varying(5) NOT NULL REFERENCES stammdaten.mess_stelle,
     datenbasis_id integer NOT NULL REFERENCES stammdaten.datenbasis,
-    ba_id integer DEFAULT 0 REFERENCES stammdaten.betriebsart,
+    ba_id integer DEFAULT 1 REFERENCES stammdaten.betriebsart,
     gem_id character varying(8) REFERENCES stammdaten.verwaltungseinheit,
     ort_id integer NOT NULL REFERENCES stammdaten.ort,
     media_desk character varying(100),
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)