ALTER TABLE stock_log
    CHANGE COLUMN lot partnumber VARCHAR(255) NOT NULL;