friends

friends — Table describing users someone has listed as a "friend". Also details preferences on the friend item.

friends

Column nameTypeNullDefaultDescription
useridint unsigned0The userid of the user who added the friend.
friendidint unsigned0The user.userid of the friend to watch/trust.
fgcolormediumint unsigned0The foreground color used in the friends view events.
bgcolormediumint unsigned16777215The background color used in the friends view events.
groupmaskint unsigned1A bitmask of 1 (1 << 0) OR'ed with (1 << friendgroup.groupnum) for each friendgroup this friend belongs to.
showbydefaultenum('1','0')1Unused.
Key nameTypeColumn(s)
friendINDEX
uniqrelUNIQUE