-- 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);