Mercurial > lada > lada-server
diff db_schema/lada_schema.sql @ 1168:cd9bf2430eef
Let the database enforce,too, what rev 46db98d060ae introduced.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Wed, 09 Nov 2016 17:24:49 +0100 |
| parents | 84ff77bba9b0 |
| children | 4ee336c65ab3 |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Wed Nov 09 16:32:29 2016 +0100 +++ b/db_schema/lada_schema.sql Wed Nov 09 17:24:49 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();