-- Migration: Fix talent stat bonuses
-- Problem: armor_bonus column doesn't exist in talents table,
-- causing getTalentDefinitions() to silently fail and ALL talent bonuses to be 0.

-- 1. Add missing armor_bonus column
ALTER TABLE talents ADD COLUMN IF NOT EXISTS armor_bonus INT DEFAULT 0 AFTER magic_resistance_bonus;

-- 2. Set armor values for talents that should have armor bonuses
-- (based on talent descriptions in SpellDatabase.cs)
-- ice_3 "Fraîcheur mordante": +5 INT, +5 Armure
UPDATE talents SET armor_bonus = 5 WHERE id = 'ice_3';
