-- ============================================
-- SIMPLE SOLUTION: Drop Unique Index
-- Run all these commands in one go
-- ============================================

SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;
SET FOREIGN_KEY_CHECKS = 1;

-- Create non-unique index (skip if you get "Duplicate key" error)
CREATE INDEX `idx_bids_inquiry_supplier` ON `bids` (`inquiryId`, `supplierId`);

-- Verify
SHOW INDEX FROM `bids` WHERE Column_name IN ('inquiryId', 'supplierId`);