Difference between revisions of "Tables/menu"
From Joomla! Documentation
< Tables
(class="wikitable") |
m (categorisation) |
||
Line 1: | Line 1: | ||
− | == Usage | + | == Usage == |
* Since: | * Since: | ||
− | == Description | + | == Description == |
{| class="wikitable" border="1" | {| class="wikitable" border="1" | ||
Line 81: | Line 81: | ||
* Default character set: '''utf8''' | * Default character set: '''utf8''' | ||
+ | |||
+ | <noinclude>[[Category:Database]]</noinclude> |
Revision as of 10:37, 16 March 2013
Usage[edit]
- Since:
Description[edit]
Field | Type | Nullable | Default | Key | Extra | Comments |
id | integer | NOT NULL | PK | auto_increment | ||
menutype | varchar(24) | NOT NULL | The type of menu for the item. FK to #__menu_types.menutype | |||
title | varchar(255) | NOT NULL | The display title for the menu item. | |||
alias | varchar(255) | NOT NULL | The SEF alias for the menu item. | |||
note | varchar(255) | NOT NULL | ||||
path | varchar(1024) | NOT NULL | The computed path for the menu item based on the alias field. | |||
link | varchar(1024) | NOT NULL | The actually link that the menu item references. | |||
type | varchar(16) | NOT NULL | The type of link: Component, URL, Alias, Separator. | |||
published | tinyint(4) | NOT NULL | 0 | The published state of the menu link. | ||
parent_id | integer unsigned | NOT NULL | 1 | The parent menu item in the menu tree. | ||
level | integer unsigned | NOT NULL | 0 | The relative level in the menu tree. | ||
component_id | integer unsigned | NOT NULL | 0 | FK to #__extensions.id | ||
ordering | integer | NOT NULL | 0 | The relative ordering of the menu item in the tree. | ||
checked_out | integer unsigned | NOT NULL | 0 | FK to #__users.id | ||
checked_out_time | timestamp | NOT NULL | '0000-00-00 00:00:00' | The time the menu item was checked out. | ||
browserNav | tinyint(4) | NOT NULL | 0 | The click behaviour for the link. | ||
access | tinyint(3) unsigned | NOT NULL | 0 | The access level required to view the menu item. | ||
img | varchar(255) | NOT NULL | The image of the menu item. | |||
template_style_id | integer unsigned | NOT NULL | 0 | |||
params | varchar(10240) | NOT NULL | JSON-encoded data for the menu item. | |||
lft | integer | NOT NULL | 0 | Nested set lft. | ||
rgt | integer | NOT NULL | 0 | Nested set rgt. | ||
home | tinyint(3) unsigned | NOT NULL | 0 | Indicates if this menu item is the home or default page. | ||
language | char(7) | NOT NULL |
Notes[edit]
Index Name | Column(s) | Unique? |
idx_alias_parent_id | alias, parent_id | Yes |
idx_componentid | component_id, menutype, published,access | No |
idx_menutype | menutype | No |
idx_left_right | lft, rgt | No |
idx_alias | alias | No |
idx_path | path(333) | No |
idx_language | language | No |
- Default character set: utf8