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: collection

Collections are groups of resources.

ColumnTypeNote
refint(11)Auto incrementing index
namevarchar(100)The collection display name.
userint(11)User ID
createddatetime
publicint(11)Set to '1' for public collections and featured collections (deprecated - use type instead).
themevarchar(100)The first level theme category. Defined for multi-level featured collections.
theme2varchar(100)The second level theme category. Defined for multi-level featured collections.
theme3varchar(100)The third level theme category. Defined for multi-level featured collections.
allow_changesint(11)
cant_deleteint(11)Prevent collection from being deleted (used for e.g. user 'New uploads' collections)
keywordstextOptional keywords entered by the user and indexed for collection searching.
savedsearchint(11)
home_page_publishint(11)(legacy) used if $home_dash=false
home_page_texttext(legacy) used if $home_dash=false
home_page_imageint(11)(legacy) used if $home_dash=false
session_idint(11)Used for anonymous access with collections enabled - the session ID cookie used by the anonymous user, as a single user is used for all accesses.
descriptiontextTextual description.
typeint(11)Collection type such as Public / Featured / Upload / Select (see include/definition.php)
parentint(11)The parent collection for collections existing within a tree structure such as Featured Collections.
thumbnail_selection_methodint(11)How do we select the thumbnails to show on the tile for this collection?
bg_img_resource_refint(11)The resource ID of the preview image.
order_byint(11)YES,,0,The order by of the collection. Used only by Featured Collections at the moment.

Default contents are as follows.

refnameusercreatedpublicthemetheme2theme3allow_changescant_deletekeywordssavedsearchhome_page_publishhome_page_texthome_page_imagesession_iddescriptiontypeparentthumbnail_selection_methodbg_img_resource_reforder_by
1Default Collection12008-01-01 10:00:0000100

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