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...)
 
(class="wikitable")
(5 intermediate revisions by one user not shown)
Line 4: Line 4:
 
== Description: ==
 
== Description: ==
  
{| border="1"
+
{| class="wikitable" border="1"
 
|+ '''categories Table (#__categories)'''
 
|+ '''categories Table (#__categories)'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
|| 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 || || || ||
 
|}
 
|}
  
 
== Notes ==
 
== Notes ==
 +
The default Joomla! installation includes a category with the value "uncategorised" for the following extensions:
  
{| border="1"
+
* com_content
 +
* com_banners
 +
* com_contact
 +
* com_newsfeeds
 +
* com_weblinks
 +
 
 +
{| class="wikitable" border="1"
 
|+ '''Indices'''
 
|+ '''Indices'''
 
|- bgcolor="lightgrey"
 
|- bgcolor="lightgrey"
 
|| Index Name || Column(s) || Unique?
 
|| Index Name || Column(s) || Unique?
 
|-
 
|-
 +
| cat_idx || extension,published,access || No
 +
|-
 +
| idx_access || access || No
 +
|-
 +
| idx_checkout || checked_out || No
 +
|-
 +
| idx_path || path || No
 +
|-
 +
| idx_left_right || lft, rgt || No
 +
|-
 +
| idx_alias || alias || No
 +
|-
 +
| idx_language || language || No
 
|}
 
|}
  
 
* Default character set: '''utf8'''
 
* Default character set: '''utf8'''

Revision as of 22:14, 24 September 2011

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

The default Joomla! installation includes a category with the value "uncategorised" for the following extensions:

  • com_content
  • com_banners
  • com_contact
  • com_newsfeeds
  • com_weblinks
Indices
Index Name Column(s) Unique?
cat_idx extension,published,access No
idx_access access No
idx_checkout checked_out No
idx_path path No
idx_left_right lft, rgt No
idx_alias alias No
idx_language language No
  • Default character set: utf8