Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 1317:3ac30d816c9a release-2.5
prepare import of production data
author | Michael Stanko <mstanko@bfs.de> |
---|---|
date | Mon, 20 Mar 2017 15:52:22 +0100 |
parents | 5549c214e816 |
children |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Mon Mar 20 15:17:20 2017 +0100 +++ b/db_schema/stammdaten_schema.sql Mon Mar 20 15:52:22 2017 +0100 @@ -239,7 +239,8 @@ mst_id character varying(5) NOT NULL REFERENCES mess_stelle, bezeichnung character varying(120) NOT NULL, letzte_aenderung timestamp without time zone, - UNIQUE(datensatz_erzeuger_id, netzbetreiber_id) + UNIQUE(datensatz_erzeuger_id, netzbetreiber_id, mst_id) + ); CREATE TRIGGER letzte_aenderung_datensatz_erzeuger BEFORE UPDATE ON datensatz_erzeuger FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung();