bindbox-game/migrations/20260121_add_order_coupon_unique_index.sql

-- Add unique index to order_coupons table to prevent duplicate deductions for the same order and coupon
ALTER TABLE order_coupons ADD UNIQUE INDEX idx_order_user_coupon (order_id, user_coupon_id);