-- Add New Time-Based and Performance Badges
INSERT INTO badges (name, description, badge_type, criteria, xp_reward) VALUES
('Early Bird', 'Completed an investigation in the early morning (5 AM - 8 AM).', 'special', '{"time_range": "early_bird"}', 100),
('Night Owl', 'Completed an investigation late at night (12 AM - 4 AM).', 'special', '{"time_range": "night_owl"}', 100),
('Day Walker', 'Completed an investigation during typical business hours (9 AM - 5 PM).', 'special', '{"time_range": "day_walker"}', 50),
('Lunch Break Hacker', 'Completed an investigation during lunch hour (12 PM - 1 PM).', 'special', '{"time_range": "lunch_break"}', 75),
('Speed Demon', 'Solved an investigation in under 10 minutes.', 'special', '{"performance": "speed_demon", "threshold_minutes": 10}', 200),
('First Blood', 'First user to solve a specific alert.', 'special', '{"performance": "first_blood"}', 500);
