-- Add only the missing columns (skip warrantyAvailable since it already exists)
-- Run these one at a time:

-- Step 1: Add warrantyPeriod (if it doesn't exist)
ALTER TABLE `bids` ADD COLUMN `warrantyPeriod` INT NULL AFTER `warrantyAvailable`;

-- Step 2: Add condition (if it doesn't exist)
ALTER TABLE `bids` ADD COLUMN `condition` ENUM('brand_new', 'used') NULL AFTER `warrantyPeriod`;

-- If you get "Duplicate column name" error, that column already exists - skip it!