Actions

Difference between revisions of "Tables/categories"

From Joomla! Documentation

< Tables
(Description:)
(Notes)
Line 69: Line 69:
 
|| 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 14:51, 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?
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