-- Add Mobile Exclusive Badges
INSERT INTO badges (name, description, icon_url, badge_type, xp_reward, created_at, criteria)
SELECT 'Field Operative', 'Awarded for completing your first mobile investigation.', '📱', 'milestone', 100, NOW(), '{"manual": true}'
WHERE NOT EXISTS (SELECT 1 FROM badges WHERE name = 'Field Operative');

INSERT INTO badges (name, description, icon_url, badge_type, xp_reward, created_at, criteria)
SELECT 'On The Go', 'Awarded for completing 10 investigations on mobile.', '⚡', 'milestone', 300, NOW(), '{"manual": true}'
WHERE NOT EXISTS (SELECT 1 FROM badges WHERE name = 'On The Go');