Coding standards
Security in ResourceSpace
Developer reference
Database
Action functions
Admin functions
Ajax functions
Annotation functions
API functions
Collections functions
Comment functions
Config functions
CSV export functions
Dash functions
Debug functions
Encryption functions
Facial recognition functions
File functions
General functions
Language functions
Log functions
Login functions
Message functions
Migration functions
Node functions
PDF functions
Plugin functions
Render functions
Reporting functions
Request functions
Research functions
Slideshow functions
Theme permission functions
User functions
Video functions
Database functions
Metadata functions
Resource functions
Search functions
Map functions
Job functions
Tab functions
Test 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_defaultstextDefault metadata values for created resources. Uses fieldname=value syntax
config_optionstextAdditional configuration options that apply to this user group - like include/config.php - accepts PHP
welcome_messagetextWelcome message text
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
allow_registration_selectionint(11)Allow selection of group for user account requests?
group_specific_logotextAn optional header logo to use instead for this user group only
inherit_flagstextComma separated list of column names that will be inherited from parent groups
search_filter_idint(11)The metadata filter to apply to determine if users in this usergroup can see a resource in search results
download_limitsmallintMaximum number of resources a user can download
download_log_dayssmallintNumber of days after which download limit expires
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,f*,j*,k,R,Ra,Rb,x,hdta,lm,cm010
2General Userss,e-1,e-2,g,d,q,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,f*,j*,k,R,Ra,x,ex010
4Archivistss,g,c,t,h,r,u,i,e1,e2,e3,v,q,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

Please see the schema overview for context. This document was last updated on the 5th of December 2024 at 07:05 (Europe/London time).