Mercurial > lada > lada-server
changeset 1013:48c07fc5d2d1 schema-update
Fixed column names in constraints.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 11:46:20 +0200 |
| parents | c739d08040d6 |
| children | 6b204c617c1f |
| files | db_schema/stammdaten_schema.sql |
| diffstat | 1 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Mon Jul 04 11:31:31 2016 +0200 +++ b/db_schema/stammdaten_schema.sql Mon Jul 04 11:46:20 2016 +0200 @@ -478,7 +478,7 @@ code character varying(3) NOT NULL, bezeichnung character varying(120) NOT NULL, letzte_aenderung timestamp without time zone, - UNIQUE(mpl_id, netzbetreiber_id) + UNIQUE(code, netzbetreiber_id) ); CREATE TRIGGER letzte_aenderung_messprogramm_kategorie BEFORE UPDATE ON messprogramm_kategorie FOR EACH ROW EXECUTE PROCEDURE update_letzte_aenderung(); @@ -826,7 +826,7 @@ ALTER TABLE ONLY auth_lst_umw - ADD CONSTRAINT auth_lst_umw_lst_fkey FOREIGN KEY (lst_id) REFERENCES mess_stelle(id); + ADD CONSTRAINT auth_lst_umw_lst_fkey FOREIGN KEY (mst_id) REFERENCES mess_stelle(id);