Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id_layered_category | int(10) unsigned | NO | PRI | auto_increment | |
| id_shop | int(11) unsigned | NO | |||
| controller | varchar(64) | NO | |||
| id_category | int(10) unsigned | NO | MUL | ||
| id_value | int(10) unsigned | YES | 0 | ||
| type | enum('category','id_feature','id_attribute_group','availability','condition','manufacturer','weight','price','extras') | NO | |||
| position | int(10) unsigned | NO | |||
| filter_type | int(10) unsigned | NO | 0 | ||
| filter_show_limit | int(10) unsigned | NO | 0 |
| id_layered_category | id_shop | controller | id_category | id_value | type | position | filter_type | filter_show_limit |
|---|---|---|---|---|---|---|---|---|
| 1 | 1 | category | 2 | availability | 1 | 0 | 0 | |
| 2 | 1 | category | 2 | extras | 2 | 0 | 0 | |
| 3 | 1 | category | 2 | price | 3 | 0 | 0 | |
| 4 | 1 | category | 2 | category | 4 | 0 | 0 | |
| 5 | 1 | category | 2 | 1 | id_attribute_group | 5 | 0 | 0 |
| 6 | 1 | category | 2 | 2 | id_attribute_group | 6 | 0 | 0 |
| 7 | 1 | category | 2 | 1 | id_feature | 7 | 0 | 0 |
| 8 | 1 | category | 2 | 2 | id_feature | 8 | 0 | 0 |
| 9 | 1 | category | 2 | manufacturer | 9 | 0 | 0 | |
| 10 | 1 | category | 2 | condition | 10 | 0 | 0 | |
| 11 | 1 | category | 2 | weight | 11 | 0 | 0 | |
| 12 | 1 | category | 2 | 3 | id_attribute_group | 12 | 0 | 0 |
| 13 | 1 | category | 2 | 4 | id_attribute_group | 13 | 0 | 0 |
| 14 | 1 | category | 3 | availability | 1 | 0 | 0 | |
| 15 | 1 | category | 3 | extras | 2 | 0 | 0 | |
| 16 | 1 | category | 3 | price | 3 | 0 | 0 | |
| 17 | 1 | category | 3 | category | 4 | 0 | 0 | |
| 18 | 1 | category | 3 | 1 | id_attribute_group | 5 | 0 | 0 |
| 19 | 1 | category | 3 | 2 | id_attribute_group | 6 | 0 | 0 |
| 20 | 1 | category | 3 | 1 | id_feature | 7 | 0 | 0 |