The `trainer` table
This table contains all the trainer entries.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| TrainerId | int(10) | unsigned | PRI | NO | 0 | ||
| SpellId | int(10) | unsigned | PRI | NO | 0 | ||
| MoneyCost | int(10) | unsigned | NO | 0 | In copper | ||
| ReqSkillLine | int(10) | unsigned | NO | 0 | |||
| ReqSkillRank | int(10) | unsigned | NO | 0 | |||
| ReqAbility1 | int(10) | unsigned | NO | 0 | |||
| ReqAbility2 | int(10) | unsigned | NO | 0 | |||
| ReqAbility3 | int(10) | unsigned | NO | 0 | |||
| ReqLevel | tinyint(3) | unsigned | NO | 0 | |||
| VerifiedBuild | smallint(5) | YES | 0 |
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 ID | DisplayName |
|---|---|
| 129 | First Aid |
| 164 | Blacksmithing |
| 165 | Leatherworking |
| 171 | Alchemy |
| 182 | Herbalism |
| 185 | Cooking |
| 186 | Mining |
| 197 | Tailoring |
| 202 | Engineering |
| 333 | Enchanting |
| 356 | Fishing |
| 393 | Skinning |
| 633 | Lockpicking |
| 755 | Jewelcrafting |
| 776 | Runeforging |
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.