Skip to end of metadata
Go to start of metadata

On this page the entire database structure of CONTENIDO is explained. Usually, a MySQL database is used to store all required information.
By clicking on the name of a specfic database table you can get more information about it.

Database structure of the latest version

Third party plugins may add or change database tables. Their database tables and changes are not listed in this documentation. Please have a look for the plugins documentation in that cases.

Usually, all database tables begin with the prefix con_. This prefix can bet set during installation.

Name of database tableName of corresponding ItemCollection className of corresponding Item class
actionlogcApiActionLogCollectioncApiActionLog
actionscApiActionCollectioncApiAction
areacApiAreaCollectioncApiArea
artcApiArticleCollectioncApiArticle
art_langcApiArticleLanguageCollectioncApiArticleLanguage
art_speccApiArticleSpecificationCollectioncApiArticleSpecification
catcApiCategoryCollectioncApiCategory
cat_artcApiCategoryArticleCollectioncApiCategoryArticle
cat_langcApiCategoryLanguageCollectioncApiCategoryLanguage
cat_treecApiCategoryTreeCollectioncApiCategoryTree
clientscApiClientCollectioncApiClient
clients_langcApiClientLanguageCollectioncApiClientLanguage
communicationscApiCommunicationCollectioncApiCommunication
containercApiContainerCollectioncApiContainer
container_confcApiContainerConfigurationCollectioncApiContainerConfiguration
contentcApiContentCollectioncApiContent
dbfscApiDbfsCollectioncApiDbfs
filescApiFileCollectioncApiFile
file_informationcApiFileInformationCollectioncApiFileInformation
frame_filescApiFrameFileCollectioncApiFrameFile
frontendgroupmemberscApiFrontendGroupMemberCollectioncApiFrontendGroupMember
frontendgroupscApiFrontendGroupCollectioncApiFrontendGroup
frontendpermissionscApiFrontendPermissionCollectioncApiFrontendPermission
frontenduserscApiFrontendUserCollectioncApiFrontendUser
groupmemberscApiGroupMemberCollectioncApiGroupMember
groupscApiGroupCollectioncApiGroup
group_propcApiGroupPropertyCollectioncApiGroupProperty
inusecApiInuseCollectioncApiInuse
iso_639_2cApiIso6392CollectioncApiIso6392
iso_3166cApiIso3166CollectioncApiIso3166
keywordscApiKeywordCollectioncApiKeyword
langcApiLanguageCollectioncApiLanguage
laycApiLayoutCollectioncApiLayout
mail_logcApiMailLogCollectioncApiMailLog
mail_log_successcApiMailLogSuccessCollectioncApiMailLogSuccess
meta_tagcApiMetaTagCollectioncApiMetaTag
meta_typecApiMetaTypeCollectioncApiMetaType
modcApiModuleCollectioncApiModule
nav_maincApiNavMainCollectioncApiNavMain
nav_subcApiNavSubCollectioncApiNavSub
online_usercApiOnlineUserCollectioncApiOnlineUser
propertiescApiPropertyCollectioncApiProperty
rightscApiRightCollectioncApiRight
search_trackingcApiSearchTrackingCollectioncApiSearchTracking
statcApiStatCollectioncApiStat
stat_archive--
system_propcApiSystemPropertyCollectioncApiSystemProperty
templatecApiTemplateCollectioncApiTemplate
template_confcApiTemplateConfigurationCollectioncApiTemplateConfiguration
typecApiTypeCollectioncApiType
uplcApiUploadCollectioncApiUpload
upl_metacApiUploadMetaCollectioncApiUploadMeta
usercApiUserCollectioncApiUser
user_propcApiUserPropertyCollectioncApiUserProperty

Previous changes to database structure

In the past database tables were changed or removed. This table lists all changes (adding a new table excluded) made to the database structure. The change of single table fields are available in the specific database table detail page in this documentation.

Name of database tableExplanation of modificationChanges made in
mod_translationsThe table was removed.4.9.0 RC 1
codeThe table was removed.4.9.0 RC 1
chartableThe table was removed.4.9.0 RC 1
phplib_auth_user_md5The table was renamed to user.4.9.0 Beta 1
newsThe table was renamed to pi_news4.9.0 Beta 1
news_groupmembersThe table was renamed to pi_news_groupmembers4.9.0 Beta 1
news_groupsThe table was renamed to pi_news_groups4.9.0 Beta 1
news_jobsThe table was renamed to pi_news_jobs4.9.0 Beta 1
news_logThe table was renamed to pi_news_log4.9.0 Beta 1
news_rcpThe table was renamed to pi_news_rcp4.9.0 Beta 1
phplib_active_sessionsThe table was removed.4.9.0 Alpha 3
configThe table was removed.4.9.0 Alpha 2
client_configThe table was removed.4.9.0 Alpha 2
dataThe table was removed.4.9.0 Alpha 2
linkThe table was removed.4.9.0 Alpha 2
statusThe table was removed.4.9.0 Alpha 2
sequenceThe table was removed.4.9.0 Alpha 1