-- Alternative approach: Recreate the table without the unique constraint
-- WARNING: This will temporarily remove all data, so BACKUP FIRST!
-- Only use this if other methods fail

-- STEP 1: Backup the bids table (IMPORTANT!)
CREATE TABLE `bids_backup` AS SELECT * FROM `bids`;

-- STEP 2: Drop the original table
DROP TABLE `bids`;

-- STEP 3: Recreate the table without the unique constraint
-- (You'll need to get the full CREATE TABLE statement and modify it)
-- Remove the unique index from the CREATE TABLE statement
-- Then run the modified CREATE TABLE

-- STEP 4: Restore data
INSERT INTO `bids` SELECT * FROM `bids_backup`;

-- STEP 5: Drop backup table
DROP TABLE `bids_backup`;

-- This is a last resort approach - try other methods first!

