-- =============================================
-- Rework rewards : zones = drops, monstres = XP
-- =============================================

-- 1. Supprimer tous les drops des monstres
DELETE FROM enemy_rewards;

-- 2. Supprimer toutes les récompenses de zones
DELETE FROM area_rewards;

-- 3. Réinsérer : zones 1-4 = Fourrure (26) + Or
INSERT INTO area_rewards (area_id, resource_id, amount_min, amount_max, probability) VALUES
(1, 26, 1, 1, 20),
(1, 0, 2, 10, 50),
(2, 26, 1, 1, 35),
(2, 0, 7, 22, 50),
(3, 26, 1, 1, 50),
(3, 0, 20, 40, 50),
(4, 26, 1, 1, 65),
(4, 0, 30, 60, 50),

-- zones 5-8 = Écailles (27) + Or
(5, 27, 1, 1, 20),
(5, 0, 42, 85, 50),
(6, 27, 1, 1, 35),
(6, 0, 57, 115, 50),
(7, 27, 1, 1, 50),
(7, 0, 75, 150, 50),
(8, 27, 1, 1, 65),
(8, 0, 95, 190, 50),

-- zones 9-10 = Côtes (28) + Or
(9, 28, 1, 1, 20),
(9, 0, 117, 235, 50),
(10, 28, 1, 1, 35),
(10, 0, 142, 285, 50);
