Actions

Tables/menu

From Joomla! Documentation

< Tables
Revision as of 09:56, 31 August 2010 by Dsiders (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Usage:

  • Since:

Description:

menu Table (#__menu)
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

Indices
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