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 '';
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 '';