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

Table: usergroup

Defines user groups.

ColumnTypeNote
refint(11)Auto incrementing index
namevarchar(100)
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)
resource_defaultstext
config_optionstextAdditional configuration options that apply to this user group - like include/config.php - accepts PHP
welcome_messagetext
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
allow_registration_selectionint(11)
group_specific_logotextAn optional header logo to use instead for this user group only
inherit_flagstext
search_filter_idint(11)The metadata filter to apply to determine if users in this usergroup can see a resource in search results
download_limitsmallint
download_log_dayssmallint
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.

refnamepermissionsparentsearch_filteredit_filterderestrict_filterip_restrictresource_defaultsconfig_optionswelcome_messagerequest_modeallow_registration_selectiongroup_specific_logoinherit_flagssearch_filter_iddownload_limitdownload_log_daysedit_filter_idderestrict_filter_id
1Administratorss,g,c,t,h,r,u,i,e-2,e-1,e0,e1,e3,v,o,m,q,n,f*,j*,k,R,Ra,Rb,x,hdta010
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
4Archivistss,g,c,t,h,r,u,i,e1,e2,e3,v,q,n,f*,j*010
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 30th of November 2020 at 02:05 (Europe/London time).