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.

TypeDescription
0Class trainer
1Mount trainer
2Tradeskill trainer
3Pet trainer

Requirement

UNK

Greeting

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