Mercurial > lada > lada-server
changeset 1010:c1e00e1fe5c8 schema-update
Use status_kombi as FK in status_protokol
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Mon, 04 Jul 2016 11:24:59 +0200 |
| parents | f0ac901a4387 |
| children | 302f800ba588 |
| files | db_schema/lada_schema.sql |
| diffstat | 1 files changed, 1 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/lada_schema.sql Mon Jul 04 10:00:08 2016 +0200 +++ b/db_schema/lada_schema.sql Mon Jul 04 11:24:59 2016 +0200 @@ -302,8 +302,7 @@ datum timestamp without time zone DEFAULT now(), text character varying(1024), messungs_id integer NOT NULL REFERENCES messung ON DELETE CASCADE, - status_stufe integer NOT NULL REFERENCES stammdaten.status_stufe, - status_wert integer NOT NULL REFERENCES stammdaten.status_wert, + status_kombi integer NOT NULL REFERENCES stammdaten.status_kombi, tree_modified timestamp without time zone DEFAULT now() ); CREATE TRIGGER tree_modified_status_protokoll BEFORE UPDATE ON status_protokoll FOR EACH ROW EXECUTE PROCEDURE update_tree_modified();