-- Alternative approach: If foreign keys don't exist or are named differently
-- Try these approaches:

-- APPROACH 1: Try to drop the index directly (sometimes works even with FK)
-- If this gives an error about foreign key, we'll need the FK name from SHOW CREATE TABLE
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;

-- APPROACH 2: If APPROACH 1 fails, we need to see the table structure:
-- Run: SHOW CREATE TABLE `bids`;
-- This will show the exact foreign key names in the output

-- APPROACH 3: Try dropping all possible foreign key names:
-- (Run these one by one, ignore errors if they don't exist)
ALTER TABLE `bids` DROP FOREIGN KEY `bids_ibfk_1`;
ALTER TABLE `bids` DROP FOREIGN KEY `bids_ibfk_2`;
ALTER TABLE `bids` DROP FOREIGN KEY `bids_ibfk_3`;
ALTER TABLE `bids` DROP FOREIGN KEY `bids_inquiryId_foreign_idx`;
ALTER TABLE `bids` DROP FOREIGN KEY `bids_supplierId_foreign_idx`;

-- Then try dropping the index again:
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;

