-- Step 1: Check all indexes on the bids table
SHOW INDEX FROM `bids` WHERE Column_name IN ('inquiryId', 'supplierId');

-- Look at the output:
-- - Key_name: The name of the index
-- - Non_unique: 0 = UNIQUE, 1 = NOT UNIQUE (allows duplicates)
-- - Column_name: Which column is in the index

-- Step 2: Find the UNIQUE index (Non_unique = 0)
-- Look for a Key_name where Non_unique = 0
-- This is the one we need to drop

-- Step 3: Drop the UNIQUE index
-- Replace 'UNIQUE_INDEX_NAME' with the actual Key_name from Step 2
-- Common names might be:
--   - bids_inquiry_id_supplier_id
--   - bids_inquiryId_supplierId
--   - bids_inquiryId_supplierId_unique
--   - Or something else

-- Example (uncomment and modify):
-- ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;

-- Step 4: Verify the non-unique index exists (it should already be there)
-- The index idx_bids_inquiry_supplier should already exist with Non_unique = 1
-- If it doesn't exist, create it:
-- CREATE INDEX `idx_bids_inquiry_supplier` ON `bids` (`inquiryId`, `supplierId`);
