friendgroup

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.

friendgroup

Column nameTypeNullDefaultDescription
useridint unsigned0The userid of the user who this friends group belongs to.
groupnumtinyint unsigned0The group number. Can be 1-30.
groupnamevarchar(60)Name given to the friend group.
sortordertinyint unsigned50The sorting order.
is_publicenum('0','1')0Determines if the group can be seen by anyone, or just the owner.
Key nameTypeColumn(s)
PRIMARYPRIMARY