-- ═══════════════════════════════════════════════════════════════
-- Migration 005 — Link auction winners to bookings
-- ═══════════════════════════════════════════════════════════════
ALTER TABLE bookings
    ADD COLUMN IF NOT EXISTS auction_id CHAR(36) NULL AFTER campaign_id,
    ADD INDEX  IF NOT EXISTS idx_bookings_auction (auction_id);

ALTER TABLE auctions
    ADD COLUMN IF NOT EXISTS booking_id CHAR(36) NULL AFTER winning_bid_id,
    ADD INDEX  IF NOT EXISTS idx_auctions_booking (booking_id);
