Mercurial > lada > lada-server
changeset 1172:7c510615a4e8
merged.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Thu, 10 Nov 2016 13:49:31 +0100 |
| parents | 67a85c6a7474 (current diff) cd9bf2430eef (diff) |
| children | 60b91dbb98cc |
| files | |
| diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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();