🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: prestashop / ps_store
13| Campo | Tipo | Null | Key | Default | Extra |
|---|
| id_store | int(10) unsigned | NO | PRI | | auto_increment |
| id_country | int(10) unsigned | NO | | | |
| id_state | int(10) unsigned | YES | | | |
| city | varchar(64) | NO | | | |
| postcode | varchar(12) | NO | | | |
| latitude | decimal(13,8) | YES | | | |
| longitude | decimal(13,8) | YES | | | |
| phone | varchar(16) | YES | | | |
| fax | varchar(16) | YES | | | |
| email | varchar(255) | YES | | | |
| active | tinyint(1) unsigned | NO | | 0 | |
| date_add | datetime | NO | | | |
| date_upd | datetime | NO | | | |
🔬 Muestra de datos
5 filas
| id_store | id_country | id_state | city | postcode | latitude | longitude | phone | fax | email | active | date_add | date_upd |
|---|
| 1 | 21 | 12 | Miami | 33135 | 25.76500500 | -80.24379700 | | | | 1 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 |
| 2 | 21 | 12 | Miami | 33304 | 26.13793600 | -80.13943500 | | | | 1 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 |
| 3 | 21 | 12 | Miami | 33026 | 26.00998700 | -80.29447200 | | | | 1 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 |
| 4 | 21 | 12 | Miami | 33133 | 25.73629600 | -80.24479700 | | | | 1 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 |
| 5 | 21 | 12 | Miami | 33181 | 25.88674000 | -80.16329200 | | | | 1 | 2026-06-11 14:36:44 | 2026-06-11 14:36:44 |