X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fwarehouse_alter_chargenumber.sql;h=1ee620b0dcbfbfd05d7a8b78239dea9866e2b21a;hb=a3b8cfa7b754629f39ee42e1cadd88d013666a14;hp=725e374a70b9b9b590d2124f550d43feaa3b749e;hpb=73be6af449d872825d1fbdffe536b9061ca649c8;p=kivitendo-erp.git 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 '';