28,936
edits
Changes
m
no edit summary
Line 2:
Line 2:
= Content/Contenu/Contiendo =+
+
[[Category:Core]]
[[Category:Core]]
[[Category:Noyau]]
[[Category:Noyau]]
+[[Category:Básico]]
{{ListOfTables}}
{{ListOfTables}}
+= Content/Contenu/Contenido =
−{{Flag en}} Contains the menus. See also page [[Menus_system]]
+{{Flag fr}} Contient les menus. Voir aussi la page [[Système_de_menus]]
+
+{{Flag sp}} Contiene los menús.
= Structure =
= Structure =
−{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+== Table ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Field</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Type</b>
Line 21:
Line 27:
| rowid
| rowid
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| technical index
−|}
+|-
+| menu_handler
+| varchar(16)
+| NO
+| UNI
+|
+|
+| Menu handler name
+|-
+{{FieldEntity}}
+|-
+| module
+| varchar(64)
+| YES
+|
+| NULL
+|
+| module name if record is added by a module
+|-
+| type
+| varchar(4)
+| NO
+| MUL
+|
+|
+| type of menu (top or left)
+|-
+| mainmenu
+| varchar(100)
+| NO
+|
+|
+|
+| Name family/module (home, companies, etc.)
+|-
+| fk_menu
+| int(11)
+| NO
+| UNI
+|
+|
+| 0 or Id of parent menu line
+|-
+| position
+| int(11)
+| NO
+|
+|
+|
+| sort order of entry
+|-
+| url
+| varchar(255)
+| NO
+| UNI
+|
+|
+| relative (or absolute) url to go
+|-
+| target
+| varchar(100)
+| YES
+|
+| NULL
+|
+| target of url link
+|-
+| titre
+| varchar(255)
+| NO
+|
+|
+|
+| key for menu translation
+|-
+| langs
+| varchar(100)
+| YES
+|
+| NULL
+|
+| lang file to load for translation
+|-
+| level
+| smallint
+| YES
+|
+| NULL
+|
+| only used by auguria menu. Do not use
+|-
+| leftmenu
+| varchar(1)
+| YES
+|
+| 1
+|
+| Not used (deprecated)
+|-
+| perms
+| varchar(255)
+| YES
+|
+| NULL
+|
+| condition to show enabled or disabled (grayed menu) if field enabled is 1
+|-
+| enabled
+| varchar(255)
+| YES
+|
+| 1
+|
+| condition to show or hide (completely hidden)
+|-
+| usertype
+| int(11)
+| NO
+|
+| 0
+|
+| 0 if menu for all users, 1 for external only, 2 for internal only
+{{FieldTms}}
+|}
+== Keys ==
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|-
+| idx_menu_uk_menu
+| UNIQUE
+| menu_handler,fk_menu,url,entity
+|-
+| idx_menu_menuhandler_type
+| MULTIPLE
+| menu_handler,type
+|}