X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/9d3ce6e8de57241dbba95498f8db127410e11752..e14cb525c640cb15bb6b2dfb62ccebbe78cb45cd:/sql/Pg-upgrade2/transaction_description_not_null.sql diff --git a/sql/Pg-upgrade2/transaction_description_not_null.sql b/sql/Pg-upgrade2/transaction_description_not_null.sql index 2758d6865..33cf8c4ed 100644 --- 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. --- @depends: transaction_description +-- @description: Das Feld "transaction_description" sollte keine NULL-Werte enthalten. +-- @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 delivery_orders SET transaction_description = '' WHERE transaction_description IS NULL;