Collections functions
Encryption functions
General functions
Theme permission 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)

Default contents are as follows.

refnameusercreatedpublicthemetheme2theme3allow_changescant_deletekeywordssavedsearchhome_page_publishhome_page_texthome_page_imagesession_iddescriptiontype
1Default Collection12008-01-01 10:00:000011

Please see the schema overview for context. This document was last updated on the 14th of July 2020 at 00:05 (Europe/London time).