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 | Description |
|---|---|
| 0 | Class trainer |
| 1 | Mount trainer |
| 2 | Tradeskill trainer |
| 3 | Pet 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.