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_product | int(10) unsigned | NO | PRI | ||
| id_shop | int(10) unsigned | NO | PRI | ||
| id_category_default | int(10) unsigned | YES | MUL | ||
| id_tax_rules_group | int(11) unsigned | NO | |||
| on_sale | tinyint(1) unsigned | NO | 0 | ||
| online_only | tinyint(1) unsigned | NO | 0 | ||
| ecotax | decimal(17,6) | NO | 0.000000 | ||
| minimal_quantity | int(10) unsigned | NO | 1 | ||
| low_stock_threshold | int(10) | YES | |||
| low_stock_alert | tinyint(1) | NO | 0 | ||
| price | decimal(20,6) | NO | 0.000000 | ||
| wholesale_price | decimal(20,6) | NO | 0.000000 | ||
| unity | varchar(255) | YES | |||
| unit_price | decimal(20,6) | NO | 0.000000 | ||
| unit_price_ratio | decimal(20,6) | NO | 0.000000 | ||
| additional_shipping_cost | decimal(20,6) | NO | 0.000000 | ||
| customizable | tinyint(2) | NO | 0 | ||
| uploadable_files | tinyint(4) | NO | 0 | ||
| text_fields | tinyint(4) | NO | 0 | ||
| active | tinyint(1) unsigned | NO | 0 | ||
| redirect_type | enum('','404','410','301-product','302-product','301-category','302-category','200-displayed','404-displayed','410-displayed','default') | NO | default | ||
| id_type_redirected | int(10) unsigned | NO | 0 | ||
| available_for_order | tinyint(1) | NO | 1 | ||
| available_date | date | YES | |||
| show_condition | tinyint(1) | NO | 1 | ||
| condition | enum('new','used','refurbished') | NO | new | ||
| show_price | tinyint(1) | NO | 1 | ||
| indexed | tinyint(1) | NO | MUL | 0 | |
| visibility | enum('both','catalog','search','none') | NO | both | ||
| cache_default_attribute | int(10) unsigned | YES | |||
| advanced_stock_management | tinyint(1) | NO | 0 | ||
| date_add | datetime | NO | MUL | ||
| date_upd | datetime | NO | |||
| pack_stock_type | int(11) unsigned | NO | 3 |
| id_product | id_shop | id_category_default | id_tax_rules_group | on_sale | online_only | ecotax | minimal_quantity | low_stock_threshold | low_stock_alert | price | wholesale_price | unity | unit_price | unit_price_ratio | additional_shipping_cost | customizable | uploadable_files | text_fields | active | redirect_type | id_type_redirected | available_for_order | available_date | show_condition | condition | show_price | indexed | visibility | cache_default_attribute | advanced_stock_management | date_add | date_upd | pack_stock_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 4 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 23.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 1 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 2 | 1 | 5 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 35.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 404 | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 9 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 3 | 1 | 9 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 29.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 13 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 4 | 1 | 9 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 29.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 404 | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 16 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 5 | 1 | 9 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 29.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 19 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 6 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 11.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 7 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 11.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 8 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 11.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 404 | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 9 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 18.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 22 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 10 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 18.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 24 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 11 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 18.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 26 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 12 | 1 | 9 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 9.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 13 | 1 | 9 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 9.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 14 | 1 | 9 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 9.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 15 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 35.000000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 16 | 1 | 7 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 28 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 17 | 1 | 7 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 32 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 18 | 1 | 7 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 12.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 0 | 0 | 0 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 36 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 | |
| 19 | 1 | 8 | 1 | 0 | 0 | 0.000000 | 1 | 0 | 0 | 13.900000 | 5.490000 | 0.000000 | 0.000000 | 0.000000 | 1 | 0 | 1 | 1 | 301-category | 0 | 1 | 0000-00-00 | 0 | new | 1 | 1 | both | 0 | 0 | 2026-06-11 14:36:42 | 2026-06-11 14:36:42 | 3 |