Mercurial > lada > lada-server
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 883:2e264556f186 | 884:fa7278bd8d73 |
|---|---|
| 691 | 691 |
| 692 FOR kombi_to IN SELECT * FROM status_kombi LOOP | 692 FOR kombi_to IN SELECT * FROM status_kombi LOOP |
| 693 s_to := kombi_to.stufe_id; | 693 s_to := kombi_to.stufe_id; |
| 694 w_to := kombi_to.wert_id; | 694 w_to := kombi_to.wert_id; |
| 695 | 695 |
| 696 IF s_from = s_to AND w_to <> 0 AND w_from <> 4 THEN | 696 IF s_from = s_to AND w_to <> 0 THEN |
| 697 -- At the same 'stufe', all permutations occur, | 697 -- At the same 'stufe', all permutations occur, |
| 698 -- but 'nicht vergeben' is only allowed for von_id | 698 -- but 'nicht vergeben' is only allowed for von_id |
| 699 -- and 'Rückfrage' is only allowed for zu_id | |
| 700 INSERT INTO status_reihenfolge (von_id, zu_id) | 699 INSERT INTO status_reihenfolge (von_id, zu_id) |
| 701 VALUES (kombi_from.id, kombi_to.id); | 700 VALUES (kombi_from.id, kombi_to.id); |
| 702 | 701 |
| 703 ELSEIF s_to = s_from + 1 AND w_from <> 0 AND w_from <> 4 THEN | 702 ELSEIF s_to = s_from + 1 AND w_from <> 0 AND w_from <> 4 THEN |
| 704 -- Going to the next 'stufe' all available status_kombi are allowed | 703 -- Going to the next 'stufe' all available status_kombi are allowed |