====== character_social 表 ======
----
[[数据库:characters数据库:首页|<-返回:Characters 数据库]]

Contains data about character's friends/ignored list.

**表结构**
^Field^Type^Attributes^Key^Null^Default^extra^Comment^
|[[#guid|guid]]|INT|UNSIGNED|PRI|NO|0| |Character Global Unique Identifier|
|[[#friend|friend]]|INT|UNSIGNED|PRI|NO|0| |Friend Global Unique Identifier|
|[[#flags|flags]]|TINYINT|UNSIGNED|PRI|NO|0| |Friend Flags|
|[[#note|note]]|VARCHAR(48)|SIGNED| |NO|' '| |Friend Note|



===== 字段说明 =====
----

==== guid ====

The character guid. See characters.guid.

==== friend ====

The GUID of the friend/ignored. See characters.guid.

==== flags ====

^Value^Description^
|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.