Mercurial > lada > lada-server
changeset 924:34c04b0557ac
Added missing UNIQUE-Constraint.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 15 Apr 2016 10:18:24 +0200 |
| parents | 20547dfc436e |
| children | 2b746f4e97d6 |
| 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 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) ); --