...
Field | Type | Attributes | Key | Null | Default | Extra | Comment | |||||
int(10) | unsigned | PRI | NO | NULL | Auto increment | Global Unique Identifier | ||||||
mediumint(8) | unsigned |
| NO | 0 | Gameobject Identifier | |||||||
smallint(5) | unsigned |
| NO | 0 |
| Map Identifier | ||||||
tinyint(3) | unsigned | NO | 1 | |||||||||
| smallint(5) | unsigned | NO | 1 |
|
| ||||||
float | signed | NO | 0 |
|
| |||||||
float | signed |
| NO | 0 |
|
| ||||||
float | signed |
| NO | 0 |
|
| ||||||
float | signed | NO | 0 | |||||||||
| float | signed | NO | 0 | ||||||||
| float | signed | NO | 0 |
| |||||||
float | signed |
| NO | 0 |
|
| ||||||
float | signed | NO | 0 | |||||||||
| int(11) | signed | NO | 0 | ||||||||
| tinyint(3) | unsigned |
| NO | 0 |
|
| |||||
tinyint(3) | unsigned |
| NO | 1 |
|
|
Description of the fields
...
The global unique identifier for the game object. This field must be unique among all game objects.
guid ranges:
1.x - 3.3.5 (Vanilla - Wrath of the Lich King)
1 - 199999
4.x (Cataclysm)
200000 - 299999
6.x (Warlords of Draenor)
300000 - 399999
7.x (Legion)
400000 - 499999
8.x (Battle for Azeroth)
500000 - 599999
9.x (Shadowlands)
600000- (specified later)
id
The template ID of the gameobject. See gameobject_template.entry
...