diff db_schema/lada_schema.sql @ 1059:a435b9fd1d85

Set default in data model instead of on generation of Probe objects.
author Tom Gottfried <tom@intevation.de>
date Fri, 23 Sep 2016 19:13:40 +0200
parents 3c9616e5439f
children 7788a805a98d
line wrap: on
line diff
--- a/db_schema/lada_schema.sql	Fri Sep 23 18:47:17 2016 +0200
+++ b/db_schema/lada_schema.sql	Fri Sep 23 19:13:40 2016 +0200
@@ -582,7 +582,7 @@
     probenintervall character varying(2) NOT NULL,
     teilintervall_von integer NOT NULL,
     teilintervall_bis integer NOT NULL,
-    intervall_offset integer,
+    intervall_offset integer NOT NULL DEFAULT 0,
     gueltig_von integer NOT NULL CHECK(gueltig_von BETWEEN 0 AND 364),
     gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 0 AND 364),
     probe_nehmer_id integer,
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)