Back to the characters database list of tables.
The `character_social` table
Contains data about characters' friends/ignored list.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(11) |
unsigned |
PRI |
NO |
0 |
|
Character Global Unique Identifier |
|
int(11) |
unsigned |
PRI |
NO |
0 |
|
Friend Global Unique Identifier |
|
tinyint(1) |
unsigned |
PRI |
NO |
0 |
|
Friend Flags |
|
varchar(40) |
signed |
|
NO |
NULL |
|
Friend Note |
Description of the fields
guid
The GUID of the character. See character.guid
friend
The GUID of the friend/ignored. See characters.guid
flags
0 |
Unused entry - previously listed as friend or blocked (removed/unblocked) |
1 |
Added as friend |
2 |
Added as blocked user |
3 |
Added as friend, and in ignorelist as well |
note
Note about the friend (which appears beside the friend's name in friend list in Client).