Actions

Tables/content

From Joomla! Documentation

< Tables
Revision as of 16:36, 30 August 2010 by Dsiders (Talk | contribs)

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