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
The ID from trainer.Id
The ID of spell being taught from Spell.dbc
The cost in copper for the spell being taught.
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 |
The minimum level of the rank required to be taught the spell.
The ID of the required spell from Spell.dbc
The required level before you can be taught the spell.