Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 884:fa7278bd8d73
Allow 'editing' of status 'Rückfrage'
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 15 Feb 2016 11:33:44 +0100 |
parents | 6bd149c352a9 |
children | d4d768295068 |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Fri Feb 12 14:22:53 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Mon Feb 15 11:33:44 2016 +0100 @@ -693,10 +693,9 @@ s_to := kombi_to.stufe_id; w_to := kombi_to.wert_id; - IF s_from = s_to AND w_to <> 0 AND w_from <> 4 THEN + IF s_from = s_to AND w_to <> 0 THEN -- At the same 'stufe', all permutations occur, -- but 'nicht vergeben' is only allowed for von_id - -- and 'Rückfrage' is only allowed for zu_id INSERT INTO status_reihenfolge (von_id, zu_id) VALUES (kombi_from.id, kombi_to.id);