ALTER TABLE inventory_items
    ADD COLUMN photo_url VARCHAR(500) NULL AFTER supplier;