-- Insertion des 20 avatars de base dans la table avatars

INSERT IGNORE INTO avatars (code, category, file_path, price, display_order) VALUES
('base-01', 'base', 'base/base-01.png', 0, 1),
('base-02', 'base', 'base/base-02.png', 0, 2),
('base-03', 'base', 'base/base-03.png', 0, 3),
('base-04', 'base', 'base/base-04.png', 0, 4),
('base-05', 'base', 'base/base-05.png', 0, 5),
('base-06', 'base', 'base/base-06.png', 0, 6),
('base-07', 'base', 'base/base-07.png', 0, 7),
('base-08', 'base', 'base/base-08.png', 0, 8),
('base-09', 'base', 'base/base-09.png', 0, 9),
('base-10', 'base', 'base/base-10.png', 0, 10),
('base-11', 'base', 'base/base-11.png', 0, 11),
('base-12', 'base', 'base/base-12.png', 0, 12),
('base-13', 'base', 'base/base-13.png', 0, 13),
('base-14', 'base', 'base/base-14.png', 0, 14),
('base-15', 'base', 'base/base-15.png', 0, 15),
('base-16', 'base', 'base/base-16.png', 0, 16),
('base-17', 'base', 'base/base-17.png', 0, 17),
('base-18', 'base', 'base/base-18.png', 0, 18),
('base-19', 'base', 'base/base-19.png', 0, 19),
('base-20', 'base', 'base/base-20.png', 0, 20);

SELECT COUNT(*) as total_avatars FROM avatars WHERE category = 'base';
