-- ============================================
-- FINAL ATTEMPT: Drop and Recreate in One Command
-- ============================================

-- Try this single command that drops and recreates in one go:
SET FOREIGN_KEY_CHECKS = 0;

ALTER TABLE `bids` 
  DROP INDEX `bids_inquiry_id_supplier_id`,
  ADD INDEX `idx_bids_inquiry_supplier` (`inquiryId`, `supplierId`);

SET FOREIGN_KEY_CHECKS = 1;

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

-- ============================================
-- If the above fails, the foreign key might be preventing it
-- In that case, you have two options:
-- ============================================

-- OPTION 1: Skip this migration for now
-- The system will work, but suppliers can only submit one bid per inquiry
-- You can add multiple bids feature later

-- OPTION 2: Contact your database administrator
-- They can help drop the foreign key constraint and then the index