🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_country
11| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_country | int(10) unsigned | NO | PRI | | auto_increment |
| id_zone | int(10) unsigned | NO | MUL | | |
| id_currency | int(10) unsigned | NO | | 0 | |
| iso_code | varchar(3) | NO | MUL | | |
| call_prefix | int(10) | NO | | 0 | |
| active | tinyint(1) unsigned | NO | | 0 | |
| contains_states | tinyint(1) | NO | | 0 | |
| need_identification_number | tinyint(1) | NO | | 0 | |
| need_zip_code | tinyint(1) | NO | | 1 | |
| zip_code_format | varchar(12) | NO | | | |
| display_tax_label | tinyint(1) | NO | | | |
🔬 Muestra de datos
20 filas
| id_country | id_zone | id_currency | iso_code | call_prefix | active | contains_states | need_identification_number | need_zip_code | zip_code_format | display_tax_label |
|---|
| 1 | 1 | 0 | DE | 49 | 0 | 0 | 0 | 1 | NNNNN | 1 |
| 2 | 1 | 0 | AT | 43 | 0 | 0 | 0 | 1 | NNNN | 1 |
| 3 | 1 | 0 | BE | 32 | 0 | 0 | 0 | 1 | NNNN | 1 |
| 4 | 2 | 0 | CA | 1 | 0 | 1 | 0 | 1 | LNL NLN | 0 |
| 5 | 3 | 0 | CN | 86 | 0 | 0 | 0 | 1 | NNNNNN | 1 |
| 6 | 1 | 0 | ES | 34 | 0 | 0 | 1 | 1 | NNNNN | 1 |
| 7 | 1 | 0 | FI | 358 | 0 | 0 | 0 | 1 | NNNNN | 1 |
| 8 | 1 | 0 | FR | 33 | 1 | 0 | 0 | 1 | NNNNN | 1 |
| 9 | 1 | 0 | GR | 30 | 0 | 0 | 0 | 1 | NNNNN | 1 |
| 10 | 1 | 0 | IT | 39 | 0 | 1 | 0 | 1 | NNNNN | 1 |
| 11 | 3 | 0 | JP | 81 | 0 | 1 | 0 | 1 | NNN-NNNN | 1 |
| 12 | 1 | 0 | LU | 352 | 0 | 0 | 0 | 1 | NNNN | 1 |
| 13 | 1 | 0 | NL | 31 | 0 | 0 | 0 | 1 | NNNN LL | 1 |
| 14 | 1 | 0 | PL | 48 | 0 | 0 | 0 | 1 | NN-NNN | 1 |
| 15 | 1 | 0 | PT | 351 | 0 | 0 | 0 | 1 | NNNN-NNN | 1 |
| 16 | 1 | 0 | CZ | 420 | 0 | 0 | 0 | 1 | NNN NN | 1 |
| 17 | 7 | 0 | GB | 44 | 0 | 0 | 0 | 1 | | 1 |
| 18 | 1 | 0 | SE | 46 | 0 | 0 | 0 | 1 | NNN NN | 1 |
| 19 | 7 | 0 | CH | 41 | 0 | 0 | 0 | 1 | NNNN | 1 |
| 20 | 1 | 0 | DK | 45 | 0 | 0 | 0 | 1 | NNNN | 1 |