Back-to:Characters
The `character_equipmentsets` table
This table holds info about player's equipment manager settings.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(10) |
signed |
|
NO |
0 |
|
|
|
bigint(20) |
signed |
PRI |
NO |
|
Auto Increment |
|
|
tinyint(3) |
signed |
|
NO |
0 |
|
|
|
varchar(31) |
signed |
|
NO |
" |
|
|
|
varchar(100) |
signed |
|
NO |
" |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
|
int(11) |
unsigned |
|
NO |
0 |
|
|
Description of the fields
guid
Player's GUID. See characters.guid
setguid
First free guid.
setindex
Set index, values from 0 to 9 are used.
name
Individual. Name is set by player.
iconname
Name taken from ItemDisplayInfo.dbc, column 6
ignore_mask
field-no-description|6
item0-18
Values taken from item_instance.guid
0. Head
- Neck
- Shoulder
- Shirt
- Chest
- Waist
- Legs
- Feet
- Wrist
- Hands
- Ring 1
- Ring 2
- Trinket 1
- Trinket 2
- Back
- Main Hand
- Off Hand
- Relic
- Tabard