ALTER TABLE partnumber_log_competitors
    DROP COLUMN lot_name,
    CHANGE COLUMN raw_partnumber partnumber VARCHAR(255) NOT NULL,
    CHANGE COLUMN quote_date date DATE NOT NULL;