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