friendgroup — Table describing a user's friends groups. Friends groups are used to restrict who can see an individual post, or to filter the friends view.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| userid | int unsigned | 0 | The userid of the user who this friends group belongs to. | |
| groupnum | tinyint unsigned | 0 | The group number. Can be 1-30. | |
| groupname | varchar(60) | Name given to the friend group. | ||
| sortorder | tinyint unsigned | 50 | The sorting order. | |
| is_public | enum('0','1') | 0 | Determines if the group can be seen by anyone, or just the owner. |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY |