Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 1077:7143cd96d3de
Calendar.DAY_OF_YEAR is 1-based.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 30 Sep 2016 18:41:12 +0200 |
| parents | daca5c62356f |
| children | 6499f2410c42 |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Fri Sep 30 18:32:48 2016 +0200 +++ b/db_schema/lada_schema.sql Fri Sep 30 18:41:12 2016 +0200 @@ -583,8 +583,8 @@ teilintervall_von integer NOT NULL, teilintervall_bis integer NOT NULL, 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), + gueltig_von integer NOT NULL CHECK(gueltig_von BETWEEN 1 AND 365), + gueltig_bis integer NOT NULL CHECK(gueltig_bis BETWEEN 1 AND 365), probe_nehmer_id integer, probe_kommentar character varying(80), letzte_aenderung timestamp without time zone DEFAULT now() NOT NULL,