-- Safe approach: Create new table, copy data, swap tables
-- This preserves all data

-- STEP 1: Create backup
CREATE TABLE `bids_backup` AS SELECT * FROM `bids`;

-- STEP 2: Get the CREATE TABLE statement and modify it
-- Remove the unique index line: UNIQUE KEY `bids_inquiry_id_supplier_id` (`inquiryId`,`supplierId`)
-- Then create the new table structure

-- STEP 3: After creating new table structure, copy data back
-- INSERT INTO `bids` SELECT * FROM `bids_backup`;

-- This is complex - let's try the modify columns approach first