-- Simple migration: Add warranty and condition fields to bids table
-- Run this in phpMyAdmin or MySQL command line
-- If you get an error that a column already exists, that's fine - just skip that step

-- Add warrantyAvailable column
ALTER TABLE `bids` 
ADD COLUMN `warrantyAvailable` BOOLEAN DEFAULT FALSE NULL AFTER `notes`;

-- Add warrantyPeriod column
ALTER TABLE `bids` 
ADD COLUMN `warrantyPeriod` INT NULL AFTER `warrantyAvailable`;

-- Add condition column
ALTER TABLE `bids` 
ADD COLUMN `condition` ENUM('brand_new', 'used') NULL AFTER `warrantyPeriod`;

-- Verify: Check that columns were added
SHOW COLUMNS FROM `bids`;

