-- STEP-BY-STEP: Add warranty and condition fields to bids table
-- Run each ALTER TABLE statement separately (one at a time)

-- STEP 1: Add warrantyAvailable column
-- Copy and run this first:
ALTER TABLE `bids` ADD COLUMN `warrantyAvailable` BOOLEAN DEFAULT FALSE NULL AFTER `notes`;

-- STEP 2: Add warrantyPeriod column
-- Copy and run this second:
ALTER TABLE `bids` ADD COLUMN `warrantyPeriod` INT NULL AFTER `warrantyAvailable`;

-- STEP 3: Add condition column
-- Copy and run this third:
ALTER TABLE `bids` ADD COLUMN `condition` ENUM('brand_new', 'used') NULL AFTER `warrantyPeriod`;

-- STEP 4: Verify (optional - run this to check):
SHOW COLUMNS FROM `bids` LIKE 'warranty%';
SHOW COLUMNS FROM `bids` LIKE 'condition%';