-- 1. Convertir la table en utf8mb4
ALTER TABLE chat_icons CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 2. Vider et réinsérer
TRUNCATE TABLE chat_icons;

INSERT INTO chat_icons (emoji, label, category, required_tier, required_points, sort_order) VALUES
('😄','Sourire','general','free',0,1),
('😂','Rires','general','free',0,2),
('👍','Pouce','general','free',0,3),
('🔥','Feu','general','free',0,4),
('🎯','Cible','general','free',0,5),
('👀','Yeux','general','free',0,6),
('🤔','Pensif','general','free',0,7),
('😱','Choc','general','free',0,8),
('⚡','Éclair','general','free',50,10),
('🏆','Trophée','general','free',100,11),
('💎','Diamant','general','free',200,12),
('🎲','Dé','general','free',300,13),
('👑','Couronne','premium','premium',0,20),
('🌟','Étoile','premium','premium',0,21),
('🎭','Masque','premium','premium',0,22),
('🦁','Lion','premium','premium',0,23),
('🚀','Fusée','premium','premium',0,24),
('💫','Étincelle','premium','premium',0,25),
('🌈','Arc-en-ciel','premium_plus','premium_plus',0,30),
('🔮','Boule cristal','premium_plus','premium_plus',0,31),
('🎪','Cirque','premium_plus','premium_plus',0,32),
('🦋','Papillon','premium_plus','premium_plus',0,33);
