friends

friends — Global. Stores data of which users someone has listed as a "friend". Also stores the preferences on the friend item.

friends

Column name Type Null Default Description
userid int unsigned   0 The userid of the user who added the friend.
friendid int unsigned   0 The user.userid of the friend to watch/trust.
fgcolor mediumint unsigned   0 The foreground color used in the friends view events.
bgcolor mediumint unsigned   16777215 The background color used in the friends view events.
groupmask int unsigned   1 A bitmask of 1 (1 << 0) OR'ed with (1 << friendgroup.groupnum) for each friendgroup this friend belongs to.
showbydefault enum('1','0')   1 Unused.
Key name Type Column(s)
PRIMARY PRIMARY
friendid INDEX