Fields (29)
| Name | Type | Null | Key | Default | Extra |
| id | int(11) unsigned | NO | PRI | NULL | auto_increment |
| parent | int(11) unsigned | YES | MUL | NULL | |
| path | varchar(255) | YES | | NULL | |
| description | varchar(255) | NO | MUL | NULL | |
| position | int(11) unsigned | YES | MUL | 0 | |
| left | int(11) unsigned | NO | MUL | NULL | |
| right | int(11) unsigned | NO | | NULL | |
| level | int(11) unsigned | NO | MUL | NULL | |
| added | datetime | NO | | NULL | |
| changed | datetime | NO | | NULL | |
| metakeywords | mediumtext | YES | | NULL | |
| metadescription | mediumtext | YES | | NULL | |
| cmsheadline | varchar(255) | YES | | NULL | |
| cmstext | mediumtext | YES | | NULL | |
| template | varchar(255) | YES | | NULL | |
| active | int(1) | NO | | NULL | |
| blog | int(11) | NO | | NULL | |
| external | varchar(255) | YES | | NULL | |
| hidefilter | int(1) | NO | | NULL | |
| hidetop | int(1) | NO | | NULL | |
| mediaID | int(11) unsigned | YES | | NULL | |
| product_box_layout | varchar(50) | YES | | NULL | |
| meta_title | varchar(255) | YES | | NULL | |
| stream_id | int(11) unsigned | YES | MUL | NULL | |
| hide_sortings | int(1) | NO | | 0 | |
| sorting_ids | text | YES | | NULL | |
| facet_ids | text | YES | | NULL | |
| external_target | varchar(32) | YES | | | |
| shops | varchar(255) | YES | | NULL | |
Indexes (8)
| Name | Columns | Unique |
| active_query_builder | parent,position,id | No |
| description | description | No |
| left | left,right | No |
| level | level | No |
| parent | parent | No |
| position | position | No |
| PRIMARY | id | Yes |
| stream_id | stream_id | No |