-- ============================================
-- ALTERNATIVE: Use ALTER TABLE to modify structure
-- This might work when direct DROP INDEX fails
-- ============================================

-- STEP 1: Disable foreign key checks
SET FOREIGN_KEY_CHECKS = 0;

-- STEP 2: Try to modify the table structure
-- This might remove the unique constraint
ALTER TABLE `bids` 
  DROP INDEX `bids_inquiry_id_supplier_id`,
  ADD INDEX `idx_bids_inquiry_supplier` (`inquiryId`, `supplierId`);

-- STEP 3: Re-enable foreign key checks
SET FOREIGN_KEY_CHECKS = 1;

-- STEP 4: Verify
SHOW INDEX FROM `bids` WHERE Column_name IN ('inquiryId', 'supplierId`);
-- Should see idx_bids_inquiry_supplier with Non_unique = 1

-- ============================================
-- If Step 2 fails, try this instead:
-- ============================================
-- STEP 2B: Drop and recreate in one command
-- SET FOREIGN_KEY_CHECKS = 0;
-- ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;
-- CREATE INDEX `idx_bids_inquiry_supplier` ON `bids` (`inquiryId`, `supplierId`);
-- SET FOREIGN_KEY_CHECKS = 1;