trainer_spell

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
TrainerId	int	unsigned	PRI	NO	0
SpellId	int	unsigned	PRI	NO	0
MoneyCost	int	unsigned		NO	0
ReqSkillLine	int	unsigned		NO	0
ReqSkillRank	int	unsigned		NO	0
ReqAbility1	int	unsigned		NO	0
ReqAbility2	int	unsigned		NO	0
ReqAbility3	int	unsigned		NO	0
ReqLevel	tinyint	unsigned		NO	0
VerifiedBuild	int	signed		NO	0

Description of fields

TrainerId

ID referencing trainer.Id  

SpellId

The ID of spell being taught from Spell.db2  

MoneyCost

The cost in copper for the spell being taught.  

ReqSkillLine

The ID of the skill from SkillLine.db2  

ReqSkillRank

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

ReqAbility1

Required ability 1, referencing spell from Spell.db2  

ReqAbility2

Required ability 2, referencing spell from Spell.db2  

ReqAbility3

Required ability 3, referencing spell from Spell.db2  

ReqLevel

The required level before you can be taught the spell.  

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.