X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Ftransaction_description_not_null.sql;h=33cf8c4ed73981f03824db75f47b71636495aea2;hb=b36fb0f412d2d2b43b8d98d787743cbe1fbf2540;hp=2758d68651e1bcc7153d782595cb042a1c4e8ae6;hpb=9d3ce6e8de57241dbba95498f8db127410e11752;p=kivitendo-erp.git 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;