-- Ultimate solution: Try all possible methods
-- Run these in order:

-- METHOD 1: Try with FK checks disabled and modify columns
SET FOREIGN_KEY_CHECKS = 0;

-- Try modifying columns to remove inline foreign keys
ALTER TABLE `bids` 
  MODIFY COLUMN `inquiryId` INT NOT NULL,
  MODIFY COLUMN `supplierId` INT NOT NULL;

-- Now try dropping the unique index
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;

SET FOREIGN_KEY_CHECKS = 1;

-- METHOD 2: If METHOD 1 fails, we need the full CREATE TABLE statement
-- Run: SHOW CREATE TABLE `bids`\G
-- And share the complete output

-- METHOD 3: Recreate foreign keys after dropping index
ALTER TABLE `bids` 
  ADD CONSTRAINT `bids_inquiryId_fk` FOREIGN KEY (`inquiryId`) REFERENCES `inquiries` (`id`) ON DELETE CASCADE;

ALTER TABLE `bids` 
  ADD CONSTRAINT `bids_supplierId_fk` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE;

