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);
 
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)