# HG changeset patch
# User Raimund Renkert <raimund.renkert@intevation.de>
# Date 1478782171 -3600
# Node ID 7c510615a4e826f2617b980d76086d7d9fd2ccbc
# Parent  67a85c6a7474e19be299ed711ec73abe6e1c7788# Parent  cd9bf2430eef55508789b9445a3102d3d66e0593
merged.

diff -r 67a85c6a7474 -r 7c510615a4e8 db_schema/lada_schema.sql
--- a/db_schema/lada_schema.sql	Thu Nov 10 13:48:46 2016 +0100
+++ b/db_schema/lada_schema.sql	Thu Nov 10 13:49:31 2016 +0100
@@ -278,7 +278,8 @@
     ortszuordnung_typ character varying(1) REFERENCES stammdaten.ortszuordnung_typ,
     ortszusatztext character varying(100),
     letzte_aenderung timestamp without time zone DEFAULT now(),
-    tree_modified timestamp without time zone DEFAULT now()
+    tree_modified timestamp without time zone DEFAULT now(),
+    EXCLUDE (probe_id WITH =) WHERE (ortszuordnung_typ = 'E')
 );
 CREATE TRIGGER letzte_aenderung_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung();
 CREATE TRIGGER tree_modified_ortszuordnung BEFORE UPDATE ON ortszuordnung FOR EACH ROW EXECUTE PROCEDURE update_tree_modified();