Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 927:690b6506e0a2
merged.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 29 Apr 2016 16:40:26 +0200 |
| parents | 9121d99a471e 34c04b0557ac |
| children | b943e956b767 |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Fri Apr 29 16:38:33 2016 +0200 +++ b/db_schema/lada_schema.sql Fri Apr 29 16:40:26 2016 +0200 @@ -399,7 +399,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) ); CREATE TRIGGER letzte_aenderung_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung();