This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.
ALTER TABLE rewards
ADD COLUMN description VARCHAR(500) NOT NULL DEFAULT '' AFTER stock;
UPDATE rewards
SET stock = CASE id
WHEN 'reward_001' THEN 30
WHEN 'reward_002' THEN 50
WHEN 'reward_003' THEN 20
WHEN 'reward_004' THEN 80
ELSE stock
END,
description = CASE id
WHEN 'reward_001' THEN '适用于校区公开试听课，审核通过后生成课程券码，30 天内到店核销。'
WHEN 'reward_002' THEN '由课程顾问提供一次学习规划沟通，适合新生测评后使用。'
WHEN 'reward_003' THEN '报名正价课程时抵扣 100 元，不可叠加现金活动使用。'
WHEN 'reward_004' THEN '兑换后安排一次阶段测评报告解读，帮助家长了解学习状态。'
ELSE description
END;
