Back to the characters database list of tables.-to:Characters
The `character_social` table
...
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
int(1110) | unsigned | PRI | NO | 0 |
| Character Global Unique Identifier | |
int(1110) | unsigned | PRI | NO | 0 |
| Friend Global Unique Identifier | |
tinyint(13) | unsigned | PRI | NO | 0 |
| Friend Flags | |
varchar(4048) | 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).
Important note: There can be only 50 friend and 50 ignored characters. If you have problems with friends disappearing, try removing some of them first.