Das Feld "transaction_description" gibt es auch in der Tabelle "delivery_orders".

diff --git a/sql/Pg-upgrade2/transaction_description_not_null.sql b/sql/Pg-upgrade2/transaction_description_not_null.sql
index 2758d68651e1bcc7153d782595cb042a1c4e8ae6..54530e818f52d923c880d1ab9e1f70216a24b265 100644 (file)
--- a/sql/Pg-upgrade2/transaction_description_not_null.sql
+++ b/sql/Pg-upgrade2/transaction_description_not_null.sql
@@ -1,6 +1,7 @@
 -- @tag: transaction_description_not_null
 -- @description: Das Feld "transaction_description" sollte nicht NULL-Werte enthalten.
 -- @tag: transaction_description_not_null
 -- @description: Das Feld "transaction_description" sollte nicht NULL-Werte enthalten.

--- @depends: transaction_description
+-- @depends: transaction_description delivery_orders

 UPDATE ap SET transaction_description = '' WHERE transaction_description IS NULL;
 UPDATE ar SET transaction_description = '' WHERE transaction_description IS NULL;
 UPDATE oe SET transaction_description = '' WHERE transaction_description IS NULL;
 UPDATE ap SET transaction_description = '' WHERE transaction_description IS NULL;
 UPDATE ar SET transaction_description = '' WHERE transaction_description IS NULL;
 UPDATE oe SET transaction_description = '' WHERE transaction_description IS NULL;

+UPDATE delivery_orders SET transaction_description = '' WHERE transaction_description IS NULL;