-- Check which columns exist and add only the missing ones
-- Run this first to see what columns already exist:

SHOW COLUMNS FROM `bids` LIKE 'warranty%';
SHOW COLUMNS FROM `bids` LIKE 'condition%';

-- Based on the output above, run only the ALTER TABLE statements for columns that DON'T exist:

-- If warrantyAvailable doesn't exist, run this:
-- ALTER TABLE `bids` ADD COLUMN `warrantyAvailable` BOOLEAN DEFAULT FALSE NULL AFTER `notes`;

-- If warrantyPeriod doesn't exist, run this:
-- ALTER TABLE `bids` ADD COLUMN `warrantyPeriod` INT NULL AFTER `warrantyAvailable`;

-- If condition doesn't exist, run this:
-- ALTER TABLE `bids` ADD COLUMN `condition` ENUM('brand_new', 'used') NULL AFTER `warrantyPeriod`;

