1 -- @tag: warehouse_alter_chargenumber
2 -- @description: Chargennummber von NULL auf '' aktualisieren
3 -- @depends: release_2_6_3
5 UPDATE inventory set chargenumber='' where chargenumber IS NULL;
6 ALTER TABLE inventory ALTER COLUMN chargenumber SET NOT NULL;
7 ALTER TABLE inventory ALTER COLUMN chargenumber SET default '';