🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_category
11| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_category | int(10) unsigned | NO | PRI | | auto_increment |
| id_parent | int(10) unsigned | NO | MUL | | |
| id_shop_default | int(10) unsigned | NO | | 1 | |
| level_depth | tinyint(3) unsigned | NO | MUL | 0 | |
| nleft | int(10) unsigned | NO | MUL | 0 | |
| nright | int(10) unsigned | NO | MUL | 0 | |
| active | tinyint(1) unsigned | NO | MUL | 0 | |
| date_add | datetime | NO | | | |
| date_upd | datetime | NO | | | |
| position | int(10) unsigned | NO | | 0 | |
| is_root_category | tinyint(1) | NO | | 0 | |
🔬 Muestra de datos
9 filas
| id_category | id_parent | id_shop_default | level_depth | nleft | nright | active | date_add | date_upd | position | is_root_category |
|---|
| 1 | 0 | 1 | 0 | 1 | 18 | 1 | 2026-06-11 14:35:45 | 2026-06-11 14:35:45 | 0 | 0 |
| 2 | 1 | 1 | 1 | 2 | 17 | 1 | 2026-06-11 14:35:45 | 2026-06-11 14:35:45 | 0 | 1 |
| 3 | 2 | 1 | 2 | 3 | 8 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 0 |
| 4 | 3 | 1 | 3 | 4 | 5 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 0 |
| 5 | 3 | 1 | 3 | 6 | 7 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |
| 6 | 2 | 1 | 2 | 9 | 14 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |
| 7 | 6 | 1 | 3 | 10 | 11 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 0 | 0 |
| 8 | 6 | 1 | 3 | 12 | 13 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 1 | 0 |
| 9 | 2 | 1 | 2 | 15 | 16 | 1 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 2 | 0 |