Mercurial > lada > lada-server
changeset 1046:434b46ead134 schema-update
Added unique constraint for probe.id_alt
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Fri, 09 Sep 2016 15:33:04 +0200 |
| parents | 1b9516c60a5a |
| children | 1b6adb3971d4 |
| files | db_schema/lada_schema.sql |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Mon Sep 05 10:19:23 2016 +0200 +++ b/db_schema/lada_schema.sql Fri Sep 09 15:33:04 2016 +0200 @@ -180,7 +180,7 @@ solldatum_beginn timestamp without time zone, solldatum_ende timestamp without time zone, tree_modified timestamp without time zone DEFAULT now(), - UNIQUE (mst_id, hauptproben_nr) + UNIQUE (mst_id, hauptproben_nr, id_alt) ); CREATE TRIGGER letzte_aenderung_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); CREATE TRIGGER tree_modified_probe BEFORE UPDATE ON probe FOR EACH ROW EXECUTE PROCEDURE update_tree_modified_probe();