Difference between revisions of "Tables/categories"
From Joomla! Documentation
< Tables
m (categorisation) |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | == Usage | + | == Usage == |
* Since: | * Since: | ||
| − | == Description | + | == Description == |
| − | {| border="1" | + | {| class="wikitable" border="1" |
|+ '''categories Table (#__categories)''' | |+ '''categories Table (#__categories)''' | ||
|- bgcolor="lightgrey" | |- bgcolor="lightgrey" | ||
| Line 63: | Line 63: | ||
== 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''' | ||
| + | |||
| + | <noinclude>[[Category:Database]]</noinclude> | ||
Latest revision as of 10:37, 16 March 2013
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 extensions:
- 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