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

Table: collection

Collections are groups of resources.

ColumnTypeNote
refint(11)Auto incrementing index
namevarchar(100)The collection display name.
userint(11)See table user
createddatetime
publicint(11)Set to '1' for public collections and featured collections.
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)
keywordstextOptional keywords entered by the user and indexed for collection searching.
savedsearchint(11)
home_page_publishint(11)
home_page_texttext
home_page_imageint(11)
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 Featured / Upload / Select
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.

Default contents are as follows.

refnameusercreatedpublicthemetheme2theme3allow_changescant_deletekeywordssavedsearchhome_page_publishhome_page_texthome_page_imagesession_iddescriptiontypeparentthumbnail_selection_methodbg_img_resource_ref
1Default Collection12008-01-01 10:00:00001

Please see the schema overview for context. This document was last updated on the 28th of November 2020 at 21:35 (Europe/London time).