Tables/content

Usage

• Since:

Description

contents Table (#__contents)

Field	Type	Nullable	Default	Key	Extra	Comments
id	integer unsigned	NOT NULL		PK	auto_increment
asset_id	integer unsigned	NOT NULL	0			FK to the #__assets table.
title	varchar(255)	NOT NULL
alias	varchar(255)	NOT NULL
title_alias	varchar(255)	NOT NULL
introtext	mediumtext	NOT NULL
fulltext	mediumtext	NOT NULL
state	tinyint(3)	NOT NULL	0
sectionid	integer unsigned	NOT NULL	0
mask	integer unsigned	NOT NULL	0
catid	integer unsigned	NOT NULL	0
created	datetime	NOT NULL	'0000-00-00 00:00:00'
created_by	integer unsigned	NOT NULL	0
created_by_alias	varchar(255)	NOT NULL
modified	datetime	NOT NULL	'0000-00-00 00:00:00'
modified_by	integer unsigned	NOT NULL	0
checked_out	integer unsigned	NOT NULL	0
checked_out_time	datetime	NOT NULL	'0000-00-00 00:00:00'
publish_up	datetime	NOT NULL	'0000-00-00 00:00:00'
publish_down	datetime	NOT NULL	'0000-00-00 00:00:00'
images	text	NOT NULL
urls	text	NOT NULL
attribs	varchar(5120)	NOT NULL
version	integer unsigned	NOT NULL	1
parentid	integer unsigned	NOT NULL	0
ordering	integer	NOT NULL	0
metakey	text	NOT NULL
metadesc	text	NOT NULL
access	integer unsigned	NOT NULL	0
hits	integer unsigned	NOT NULL	0
metadata	text	NOT NULL
featured	tinyint(3) unsigned	NOT NULL	0			Flag indicating if article is featured.
language	char(7)	NOT NULL				The language code for the article.
xreference	varchar(50)	NOT NULL				A reference to enable linkages to external data sets.

Notes

Indices

Index Name	Column(s)	Unique?
idx_access	access	No
idx_checkout	checked_out	No
idx_state	state	No
idx_catid	catid	No
idx_createdby	created_by	No
idx_featured_cati	featured,catid	No
idx_language	language	No
idx_xreference	xreference	No

• Default character set: utf8