Actions

Difference between revisions of "Tables/content"

From Joomla! Documentation

< Tables
(New page: == Usage: == * Since: == Description: == {| border="1" |+ '''contents Table (#__contents)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- ...)
 
m (categorisation)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Usage: ==
+
== Usage ==
 
* Since:
 
* Since:
  
== Description: ==
+
== Description ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''contents Table (#__contents)'''
 
|+ '''contents Table (#__contents)'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
| Field || Type || Nullable || Default || Key || Extra || Comments
 
| 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 ==
 
== Notes ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''Indices'''
 
|+ '''Indices'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
Line 37: Line 103:
  
 
* Default character set: '''utf8'''
 
* Default character set: '''utf8'''
 +
 +
<noinclude>[[Category:Database]]</noinclude>

Latest revision as of 10:37, 16 March 2013

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