Mercurial > lada > lada-server
changeset 1066:daca5c62356f
A period with end before start is meaningless.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 29 Sep 2016 16:48:29 +0200 |
| parents | 7d87ddba5520 |
| children | 0a44ab47d3d5 |
| files | db_schema/lada_schema.sql |
| diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Thu Sep 29 16:23:04 2016 +0200 +++ b/db_schema/lada_schema.sql Thu Sep 29 16:48:29 2016 +0200 @@ -745,7 +745,8 @@ mpr_id integer, solldatum_beginn timestamp without time zone, solldatum_ende timestamp without time zone, - tree_modified timestamp without time zone DEFAULT now() + tree_modified timestamp without time zone DEFAULT now(), + CHECK(solldatum_beginn <= solldatum_ende) ) INHERITS (bund.probe);