character_social Table¶
Friends and ignores of each character.
Schema Summary¶
| Field | Type | Key | Null | Default | Extra |
|---|---|---|---|---|---|
guid |
int(11) unsigned | PRI | NO | 0 | |
friend |
int(11) unsigned | PRI | NO | 0 | |
flags |
tinyint(1) unsigned | PRI | NO | 0 |
Field Breakdown¶
guid- Primary Key. Character owning the social entry (characters.guid).friend- Primary Key. The other character's guid (characters.guid).flags- Relationship bitmask:1= friend,2= ignored (both possible, e.g.3). One row per character pair; adding a second relationship updates the existing row instead of inserting a new one.