Joomla! Documentation - User contributions [en]

Tables/menu

2015-04-22T12:58:38Z

Mickael Noel:

== Usage ==
* Since:

== Description ==

{| class="wikitable" border="1"
|+ '''menu Table (#__menu)'''
|- bgcolor="lightgrey"
| 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 || || ||
|}

== Notes ==

{| class="wikitable" border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| 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'''

<noinclude>[[Category:Database]]</noinclude>

Tables/menu

2015-04-22T12:57:26Z

Mickael Noel:

== Usage ==
* Since:

== Description ==

{| class="wikitable" border="1"
|+ '''menu Table (#__menu)'''
|- bgcolor="lightgrey"
| 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 ==

{| class="wikitable" border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| 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'''

<noinclude>[[Category:Database]]</noinclude>

Tables/menu

2015-04-22T12:57:02Z

Mickael Noel:

== Usage ==
* Since:

== Description ==

{| class="wikitable" border="1"
|+ '''menu Table (#__menu)'''
|- bgcolor="lightgrey"
| 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 || || ||
|-
}

== Notes ==

{| class="wikitable" border="1"
|+ '''Indices'''
|- bgcolor="lightgrey"
| 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'''

<noinclude>[[Category:Database]]</noinclude>