trainer

The `trainer` table

This table contains all the trainer entries.

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
Idint(10)unsignedPRINO0

Typetinyint(2)unsigned
NO2

Requirementmediumint(8)unsigned
NO0

Greetingtext

YESNULL

VerifiedBuildsmallint(5)signed
YES0

Description of the fields

Id

For trainer, this field signifies a unique trainer ID. It is to this ID that all spells are tied to in trainer_spell.

Type

The following table contains the types a trainer can be.

Type IDDescriptionRequirements Type
0Class trainerID from ChrClasses.dbc
1Mount trainerID from ChrRaces.dbc
2Tradeskill trainerID for the spell from Spell.dbc
3Pet trainerUnknown

Requirement

A list of known requirement IDs

Type IDRequirement IDDescription
01Warrior
02Paladin
03Hunter
04Rogue
05Priest
06Death Knight
07Shaman
08Mage
09Warlock
011Druid
11Human
12Orc
13Dwarf
14Night Elf
15Undead
16Tauren
17Gnome
18Troll
19Goblin
110Blood Elf
111Draenei
112Fel Orc
113Naga
114Broken
115Skeleton
116Vrykul
117Tuskarr
118Forest Troll
119Taunka
120Northrend Skeleton
121Ice Troll
2Spell ID



Greeting

This is the text shown, once a trainer window has been opened in the top. This is not the gossip text.