-- ============================================
-- FIRST: Check the exact index name
-- ============================================

-- Run this to see ALL indexes on the bids table
SHOW INDEX FROM `bids`;

-- Look for:
-- 1. Any index with Key_name containing "inquiry" and "supplier"
-- 2. Check the Non_unique column:
--    - Non_unique = 0 means it's UNIQUE (this is the one to drop)
--    - Non_unique = 1 means it's NOT unique (this is fine, keep it)
-- 3. Note the exact Key_name value

-- Common index names you might see:
-- - bids_inquiry_id_supplier_id
-- - bids_inquiryId_supplierId
-- - bids_inquiryId_supplierId_unique
-- - idx_bids_inquiry_supplier (this one is fine - it's non-unique)

-- Once you have the exact Key_name where Non_unique = 0, use that name in:
-- ALTER TABLE `bids` DROP INDEX `EXACT_KEY_NAME_FROM_ABOVE`;

