🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: sys / schema_auto_increment_columns
10| Campo | Tipo | Null | Key | Default | Extra |
|---|
| table_schema | varchar(64) | NO | | | |
| table_name | varchar(64) | NO | | | |
| column_name | varchar(64) | NO | | | |
| data_type | varchar(64) | NO | | | |
| column_type | longtext | NO | | | |
| is_signed | int(1) | NO | | 0 | |
| is_unsigned | int(1) | NO | | 0 | |
| max_value | bigint(21) unsigned | YES | | | |
| auto_increment | bigint(21) unsigned | YES | | | |
| auto_increment_ratio | decimal(25,4) unsigned | YES | | | |
🔬 Muestra de datos
20 filas
| table_schema | table_name | column_name | data_type | column_type | is_signed | is_unsigned | max_value | auto_increment | auto_increment_ratio |
|---|
| caja_negra | categorias | id | tinyint | tinyint(3) unsigned | 0 | 1 | 255 | 9 | 0.0353 |
| prestashop | ps_group_reduction | id_group_reduction | mediumint | mediumint(8) unsigned | 0 | 1 | 16777215 | 1 | 0.0000 |
| prestashop | ps_shop_url | id_shop_url | int | int(11) | 1 | 0 | 2147483647 | 2 | 0.0000 |
| prestashop | ps_required_field | id_required_field | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_tax_rule | id_tax_rule | int | int(11) | 1 | 0 | 2147483647 | 5 | 0.0000 |
| prestashop | ps_import_match | id_import_match | int | int(10) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_tab_module_preference | id_tab_module_preference | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_lang | id_lang | int | int(11) | 1 | 0 | 2147483647 | 3 | 0.0000 |
| prestashop | ps_shop | id_shop | int | int(11) | 1 | 0 | 2147483647 | 2 | 0.0000 |
| prestashop | ps_order_carrier | id_order_carrier | int | int(11) | 1 | 0 | 2147483647 | 6 | 0.0000 |
| prestashop | ps_wishlist_product | id_wishlist_product | int | int(10) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_admin_filter | id | int | int(11) | 1 | 0 | 2147483647 | 6 | 0.0000 |
| prestashop | ps_translation | id_translation | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_module_history | id | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_attribute | id_attribute | int | int(11) | 1 | 0 | 2147483647 | 26 | 0.0000 |
| prestashop | ps_specific_price_priority | id_specific_price_priority | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_webservice_account | id_webservice_account | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_webservice_permission | id_webservice_permission | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_ganalytics | id_google_analytics | int | int(11) | 1 | 0 | 2147483647 | 1 | 0.0000 |
| prestashop | ps_emailsubscription | id | int | int(6) | 1 | 0 | 2147483647 | 1 | 0.0000 |