Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 924:34c04b0557ac
Added missing UNIQUE-Constraint.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 15 Apr 2016 10:18:24 +0200 |
| parents | 54e83373bfae |
| children | 690b6506e0a2 |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Wed Apr 13 20:34:37 2016 +0200 +++ b/db_schema/lada_schema.sql Fri Apr 15 10:18:24 2016 +0200 @@ -378,7 +378,8 @@ probeentnahme_beginn timestamp with time zone, probeentnahme_ende timestamp with time zone, mittelungsdauer bigint, - letzte_aenderung timestamp without time zone DEFAULT now() + letzte_aenderung timestamp without time zone DEFAULT now(), + UNIQUE (mst_id, hauptproben_nr) ); --