friends — Table describing users someone has listed as a "friend". Also details preferences on the friend item.
| 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) |
|---|---|---|
| friend | INDEX | |
| uniqrel | UNIQUE |