Difference between revisions of "Tables/categories"
From Joomla! Documentation
< Tables
(→Notes) |
(→Notes) |
||
Line 63: | Line 63: | ||
== Notes == | == Notes == | ||
+ | The default Joomla! installation includes a category with the value "uncategorised" for the following components: | ||
+ | |||
+ | * com_content | ||
+ | * com_banners | ||
+ | * com_contact | ||
+ | * com_newsfeeds | ||
+ | * com_weblinks | ||
+ | |||
{| border="1" | {| border="1" |
Revision as of 14:57, 30 August 2010
Usage:[edit]
- Since:
Description:[edit]
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[edit]
The default Joomla! installation includes a category with the value "uncategorised" for the following components:
- com_content
- com_banners
- com_contact
- com_newsfeeds
- com_weblinks
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