-- Quick check: See the current state of indexes on bids table
-- Run this first to understand what needs to be changed

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

-- What to look for:
-- 1. If you see an index with Non_unique = 0 → This is a UNIQUE constraint that needs to be dropped
-- 2. If you see an index with Non_unique = 1 → Duplicates are already allowed (good!)
-- 3. If idx_bids_inquiry_supplier exists with Non_unique = 1 → You're all set!

-- After running this, share the output and I can tell you exactly what to do next.

