trainer_spell

The `trainer` table

This table contains all the trainer entries.

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
TrainerIdint(10)unsignedPRINO0

SpellIdint(10)unsignedPRINO0

MoneyCostint(10)unsigned
NO0
In copper
ReqSkillLineint(10)unsigned
NO0

ReqSkillRankint(10)unsigned
NO0

ReqAbility1int(10)unsigned
NO0

ReqAbility2int(10)unsigned
NO0

ReqAbility3int(10)unsigned
NO0

ReqLeveltinyint(3)unsigned
NO0

VerifiedBuildsmallint(5)

YES0

Description of the fields

TrainerId

The ID from trainer.Id

SpellId

The ID of spell being taught from Spell.dbc

MoneyCost

The cost in copper for the spell being taught.

ReqSkillLine

The ID of the Skill from SkillLine.dbc


A short list of known SkillLine Ids

Skill IDDisplayName
129First Aid
164Blacksmithing
165Leatherworking
171Alchemy
182Herbalism
185Cooking
186Mining
197Tailoring
202Engineering
333Enchanting
356Fishing
393Skinning
633Lockpicking
755Jewelcrafting
773Inscription
776Runeforging

ReqSkillRank

The minimum level of the rank required to be taught the spell.

ReqAbility1-3

The ID of the required spell from Spell.dbc

ReqLevel

The required level before you can be taught the spell.