Collections functions
Encryption functions
General functions
Render functions
Theme permission functions
Video functions
Resource functions

Table: usergroup

Defines user groups.

refint(11)Auto incrementing index
permissionstextA list of permissions that this user group has - see /documentation/permissions.txt
parentvarchar(50)An optional parent group ID - allows for group heirarchy and for groups to manage subgroups
search_filtertextDeprecated - string form of filters, being replace by search_filter_id and the filter table
edit_filtertextDeprecated - string form of filters, being replace by edit_filter_id and the filter table
derestrict_filtertextDeprecated - string form of filters, being replace by derestrict_filter_id and the filter table
ip_restricttextA list of IP addresses that the users can log in from (optional)
config_optionstextAdditional configuration options that apply to this user group - like include/config.php - accepts PHP
request_modeint(11)A code indicating how resource requests are handled for this group: 0 = unmanaged/e-mail only, 1 = managed via the admin UI, 2 = payment via PayPal, 3 = payment but they pay later via a manual/offline process
group_specific_logotextAn optional header logo to use instead for this user group only
search_filter_idint(11)The metadata filter to apply to determine if users in this usergroup can see a resource in search results
edit_filter_idint(11)The metadata filter to apply to determine if users in this usergroup can edit a resource
derestrict_filter_idint(11)The metadata filter to apply to determine if users in this usergroup can bypass the restricted access level of a resource and download it without going through the request process

Default contents are as follows.

2General Userss,e-1,e-2,g,d,q,n,f*,j*,z1,z2,z3011
3Super Admins,g,c,a,t,h,hdt_ug,u,r,i,e-2,e-1,e0,e1,e2,e3,o,m,g,v,q,n,f*,j*,k,R,Ra,x,ex010
5Restricted User - Requests Emailed (manual fulfilment)s,f*,j*,q,dtu,z1,z2,z3000
6Restricted User - Requests Manageds,f*,j*,q,dtu,z1,z2,z3010
7Restricted User - Payment Immediates,f*,j*,q,dtu,z1,z2,z3020
8Restricted User - Payment Invoices,f*,j*,q,dtu,z1,z2,z3030

Please see the schema overview for context. This document was last updated on the 2nd of March 2021 at 17:05 (Europe/London time).