X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/e83691e94c3fa3736daf1c3da5f2152789c68651..refs/heads/b-3.5.4:/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql diff --git a/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql b/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql index 725e374a7..1ee620b0d 100644 --- a/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql +++ b/sql/Pg-upgrade2/warehouse_alter_chargenumber.sql @@ -1,7 +1,6 @@ -- @tag: warehouse_alter_chargenumber -- @description: Chargennummber von NULL auf '' aktualisieren -- @depends: release_2_6_3 --- @charset: utf-8 UPDATE inventory set chargenumber='' where chargenumber IS NULL; ALTER TABLE inventory ALTER COLUMN chargenumber SET NOT NULL; ALTER TABLE inventory ALTER COLUMN chargenumber SET default '';