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