The `trainer` table
This table contains all the trainer entries.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| Id | int(10) | unsigned | PRI | NO | 0 | ||
| Type | tinyint(2) | unsigned | NO | 2 | |||
| Requirement | mediumint(8) | unsigned | NO | 0 | |||
| Greeting | text | YES | NULL | ||||
| VerifiedBuild | smallint(5) | signed | YES | 0 |
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 ID | Description | Requirements Type |
|---|---|---|
| 0 | Class trainer | ID from ChrClasses.dbc |
| 1 | Mount trainer | ID from ChrRaces.dbc |
| 2 | Tradeskill trainer | ID for the spell from Spell.dbc |
| 3 | Pet trainer | Unknown |
Requirement
A list of known requirement IDs
| Type ID | Requirement ID | Description |
|---|---|---|
| 0 | 1 | Warrior |
| 0 | 2 | Paladin |
| 0 | 3 | Hunter |
| 0 | 4 | Rogue |
| 0 | 5 | Priest |
| 0 | 6 | Death Knight |
| 0 | 7 | Shaman |
| 0 | 8 | Mage |
| 0 | 9 | Warlock |
| 0 | 11 | Druid |
| 1 | 1 | Human |
| 1 | 2 | Orc |
| 1 | 3 | Dwarf |
| 1 | 4 | Night Elf |
| 1 | 5 | Undead |
| 1 | 6 | Tauren |
| 1 | 7 | Gnome |
| 1 | 8 | Troll |
| 1 | 9 | Goblin |
| 1 | 10 | Blood Elf |
| 1 | 11 | Draenei |
| 1 | 12 | Fel Orc |
| 1 | 13 | Naga |
| 1 | 14 | Broken |
| 1 | 15 | Skeleton |
| 1 | 16 | Vrykul |
| 1 | 17 | Tuskarr |
| 1 | 18 | Forest Troll |
| 1 | 19 | Taunka |
| 1 | 20 | Northrend Skeleton |
| 1 | 21 | Ice Troll |
| 2 | Spell ID | |
Greeting
This is the text shown, once a trainer window has been opened in the top. This is not the gossip text.