-- 创建测试优惠券数据（简化版本）
INSERT INTO coupons (
  code,
  name,
  description,
  type,
  discount_value,
  min_purchase_amount,
  max_discount_amount,
  start_date,
  end_date,
  total_quantity,
  used_quantity,
  per_user_limit,
  scope,
  status
) VALUES 
(
  'WELCOME2025',
  '新用户专享优惠券',
  '首次购物立减50元，欢迎加入我们的大家庭！',
  'percentage',
  50,
  200,
  50,
  NOW(),
  NOW() + INTERVAL '30 days',
  1000,
  0,
  1,
  'all',
  'active'
),
(
  'SPRING888',
  '春季大促8.8折',
  '全场商品8.8折优惠，享受春季购物盛宴',
  'percentage',
  88,
  100,
  200,
  NOW(),
  NOW() + INTERVAL '60 days',
  500,
  0,
  3,
  'all',
  'active'
),
(
  'PHONE100',
  '手机专区满减券',
  '购买手机类商品满1000减100',
  'percentage',
  100,
  1000,
  100,
  NOW(),
  NOW() + INTERVAL '45 days',
  300,
  0,
  2,
  'all',
  'active'
);