-- Faster troop training rules. Safe/idempotent: updates existing troop-rule rows only.
-- Does not delete players, troops, queues, or training progress.
-- Values are seconds per unit.
UPDATE admin_game_troops SET seconds_per_unit = 30  WHERE troop_key = 'infantry';
UPDATE admin_game_troops SET seconds_per_unit = 36  WHERE troop_key = 'spearman';
UPDATE admin_game_troops SET seconds_per_unit = 45  WHERE troop_key = 'archer';
UPDATE admin_game_troops SET seconds_per_unit = 60  WHERE troop_key = 'cavalry';
UPDATE admin_game_troops SET seconds_per_unit = 120 WHERE troop_key = 'catapult';
UPDATE admin_game_troops SET seconds_per_unit = 110 WHERE troop_key = 'ballista';
UPDATE admin_game_troops SET seconds_per_unit = 100 WHERE troop_key = 'ram';