Skip to content

npc_trainer Table

Defines spells taught by specific NPC trainers (per creature entry, or shared via npc_trainer_template).


Schema Summary

Field Type Key Null Default Extra
entry mediumint(8) unsigned PRI NO 0
spell smallint(5) unsigned PRI NO 0
spellcost int(10) unsigned NO 0
reqskill smallint(5) unsigned NO 0
reqskillvalue smallint(5) unsigned NO 0
reqlevel tinyint(3) unsigned NO 0
build_min smallint(4) unsigned NO 0
build_max smallint(4) unsigned PRI NO 5875

Field Breakdown

  • entry - NPC entry ID (creature_template.entry).
  • spell - Spell ID to teach (spell_template.entry).
  • spellcost - Cost to learn (copper).
  • reqskill - Required skill ID.
  • reqskillvalue - Required skill level.
  • reqlevel - Required character level.
  • build_min / build_max - Client build range.