diff db_schema/lada_schema.sql @ 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 d77178ccbcbc
children
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();
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)