Tables/menu: Difference between revisions

Latest revision as of 12:58, 22 April 2015

**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
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
client_id	tinyint(4)	NOT NULL	0

**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

@@ Line 32: / Line 32: @@
 |-
 | 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
@@ Line 56: / Line 54: @@
 |-
 | language         || char(7)       || NOT NULL || '' ||  ||  ||
+|-
+| client_id         || tinyint(4)       || NOT NULL || 0 ||  ||  ||
 |}