JoomlaWikiBot: categorisation

2013-03-16T15:37:58Z

categorisation

Cadrlp: class="wikitable"

2011-09-25T03:21:37Z

class="wikitable"

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''menu Table (#__menu)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | id ...

2010-08-31T15:56:29Z

New page: == Usage: == * Since: == Description: == {| border="1" |+ '''menu Table (#__menu)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | id ...

New page

== Usage: ==
* Since:

== Description: ==

{| 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 ==

{| 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'''

@@ Line 1: / Line 1: @@
-== Usage: ==
+== Usage ==
 * Since:
-== Description: ==
+== Description ==
 {| class="wikitable" border="1"
@@ Line 81: / Line 81: @@
 * Default character set: '''utf8'''

@@ Line 4: / Line 4: @@
 == Description: ==
-{| border="1"
+{| class="wikitable" border="1"
 |+ '''menu Table (#__menu)'''
 |- bgcolor="lightgrey"
@@ Line 60: / Line 60: @@
 == Notes ==
-{| border="1"
+{| class="wikitable" border="1"
 |+ '''Indices'''
 |- bgcolor="lightgrey"

Tables/menu - Revision history

JoomlaWikiBot: categorisation

Cadrlp: class="wikitable"

Dsiders: New page: == Usage: == * Since: == Description: == {| border="1" |+ '''menu Table (#__menu)''' |- bgcolor="lightgrey" | Field || Type || Nullable || Default || Key || Extra || Comments |- | id ...