Actions

Difference between revisions of "Tables/categories"

From Joomla! Documentation

< Tables
(New page: == Usage: == * Since: == Description: == {| border="1" |+ '''categories Table (#__categories)''' |- bgcolor="lightgrey" || Field || Type || Nullable || Default || Key || Extra || Comment...)
 
(Description:)
Line 9: Line 9:
 
|| Field || Type || Nullable || Default || Key || Extra || Comments
 
|| Field || Type || Nullable || Default || Key || Extra || Comments
 
|-
 
|-
 +
| id int|| (11) || NOT NULL || || PK || auto_increment || Category identifier.
 +
|-
 +
| asset_id || INTEGER UNSIGNED || NOT NULL || 0 || || || FK to the #__assets table
 +
|-
 +
| parent_id || int(10) unsigned || NOT NULL|| 0 || || ||
 +
|-
 +
| lft || int(11) || NOT NULL || 0 || || ||
 +
|-
 +
| rgt || int(11) || NOT NULL || 0 || || ||
 +
|-
 +
| level || int(10) unsigned || NOT NULL || 0 || || ||
 +
|-
 +
| path || varchar(255) || NOT NULL || '' || || ||
 +
|-
 +
| extension || varchar(50) || NOT NULL || '' || || ||
 +
|-
 +
| title || varchar(255) || NOT NULL || || || ||
 +
|-
 +
| alias || varchar(255) || NOT NULL || '' || || ||
 +
|-
 +
| note || varchar(255) || NOT NULL || '' || || ||
 +
|-
 +
| description || varchar(5120) || NOT NULL || '' || || ||
 +
|-
 +
| published || tinyint(1) || NOT NULL || 0 || || ||
 +
|-
 +
| checked_out || int(11) unsigned || NOT NULL || 0 || || ||
 +
|-
 +
| checked_out_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
 +
|-
 +
| access || tinyint(3) unsigned || NOT NULL || 0 || || ||
 +
|-
 +
| params || varchar(2048) || NOT NULL || '' || || ||
 +
|-
 +
| metadesc || varchar(1024) || NOT NULL || || || || The meta description for the page.
 +
|-
 +
| metakey || varchar(1024) || NOT NULL || || || || The meta keywords for the page.
 +
|-
 +
| metadata || varchar(2048) || NOT NULL || || || || JSON-encoded metadata properties.
 +
|-
 +
| created_user_id || int(10) unsigned || NOT NULL || 0 || || ||
 +
|-
 +
| created_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
 +
|-
 +
| modified_user_id || int(10) unsigned || NOT NULL || 0 || || ||
 +
|-
 +
| modified_time || datetime || NOT NULL || '0000-00-00 00:00:00' || || ||
 +
|-
 +
| hits || int(10) unsigned || NOT NULL || 0 || || ||
 +
|-
 +
| language || char(7) || NOT NULL || || || ||
 
|}
 
|}
  

Revision as of 14:48, 30 August 2010

Usage:

  • Since:

Description:

categories Table (#__categories)
Field Type Nullable Default Key Extra Comments
id int (11) NOT NULL PK auto_increment Category identifier.
asset_id INTEGER UNSIGNED NOT NULL 0 FK to the #__assets table
parent_id int(10) unsigned NOT NULL 0
lft int(11) NOT NULL 0
rgt int(11) NOT NULL 0
level int(10) unsigned NOT NULL 0
path varchar(255) NOT NULL
extension varchar(50) NOT NULL
title varchar(255) NOT NULL
alias varchar(255) NOT NULL
note varchar(255) NOT NULL
description varchar(5120) NOT NULL
published tinyint(1) NOT NULL 0
checked_out int(11) unsigned NOT NULL 0
checked_out_time datetime NOT NULL '0000-00-00 00:00:00'
access tinyint(3) unsigned NOT NULL 0
params varchar(2048) NOT NULL
metadesc varchar(1024) NOT NULL The meta description for the page.
metakey varchar(1024) NOT NULL The meta keywords for the page.
metadata varchar(2048) NOT NULL JSON-encoded metadata properties.
created_user_id int(10) unsigned NOT NULL 0
created_time datetime NOT NULL '0000-00-00 00:00:00'
modified_user_id int(10) unsigned NOT NULL 0
modified_time datetime NOT NULL '0000-00-00 00:00:00'
hits int(10) unsigned NOT NULL 0
language char(7) NOT NULL

Notes

Indices
Index Name Column(s) Unique?
  • Default character set: utf8