This table is used to store the content of your Joomla! core articles.
Description[edit]
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.
|
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