Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad : Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :
Sin título *
v Mostrar/Ocultar lista de tablas Ver en pantalla completa Añadir tablas de otras bases de datos Nueva página Abrir página Guardar página Guardar página como Borrar páginas Crear tabla Crear relación Elegir la columna a mostrar Cargar nuevamente Ayuda Enlaces angulares / Enlaces directos Cuadrícula magnética v Pequeño/grande todos Alterne entre pequeño y grande Alternar líneas de relación Exportar estructura > Mover el Menú > Fijar texto
v v
Número de tablas: 0
v csv3n wp_actionscheduler_actions
* action_id : bigint(20) unsigned
* hook : varchar(191)
* status : varchar(20)
* scheduled_date_gmt : datetime
* scheduled_date_local : datetime
* priority : tinyint(3) unsigned
* args : varchar(191)
* schedule : longtext
* group_id : bigint(20) unsigned
* attempts : int(11)
* last_attempt_gmt : datetime
* last_attempt_local : datetime
* claim_id : bigint(20) unsigned
* extended_args : varchar(8000)
v csv3n wp_actionscheduler_claims
* claim_id : bigint(20) unsigned
* date_created_gmt : datetime
v csv3n wp_actionscheduler_groups
* group_id : bigint(20) unsigned
* slug : varchar(255)
v csv3n wp_actionscheduler_logs
* log_id : bigint(20) unsigned
* action_id : bigint(20) unsigned
* message : text
* log_date_gmt : datetime
* log_date_local : datetime
v csv3n wp_catalog_exports
* id : bigint(20) unsigned
* context_hash : varchar(32)
* file_path : text
* layout : varchar(64)
* created_at : datetime
v csv3n wp_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v csv3n wp_comments
* comment_ID : bigint(20) unsigned
* comment_post_ID : bigint(20) unsigned
* comment_author : tinytext
* comment_author_email : varchar(100)
* comment_author_url : varchar(200)
* comment_author_IP : varchar(100)
* comment_date : datetime
* comment_date_gmt : datetime
* comment_content : text
* comment_karma : int(11)
* comment_approved : varchar(20)
* comment_agent : varchar(255)
* comment_type : varchar(20)
* comment_parent : bigint(20) unsigned
* user_id : bigint(20) unsigned
v csv3n wp_cs_home_events
* id : bigint(20) unsigned
* event_date : date
* event_datetime : datetime
* product_id : bigint(20) unsigned
* block_id : varchar(120)
* block_type : varchar(80)
* event_type : varchar(80)
* session_hash : varchar(64)
* context : varchar(120)
* created_at : datetime
v csv3n wp_cs_home_surface_daily
* id : bigint(20) unsigned
* metric_date : date
* block_id : varchar(120)
* block_type : varchar(80)
* product_id : bigint(20) unsigned
* impressions : bigint(20) unsigned
* clicks : bigint(20) unsigned
* add_to_cart : bigint(20) unsigned
* orders_count : bigint(20) unsigned
* units_sold : bigint(20) unsigned
* revenue : decimal(18,2)
* created_at : datetime
* updated_at : datetime
v csv3n wp_cs_product_metrics_daily
* id : bigint(20) unsigned
* metric_date : date
* product_id : bigint(20) unsigned
* views : bigint(20) unsigned
* search_hits : bigint(20) unsigned
* add_to_cart : bigint(20) unsigned
* orders_count : bigint(20) unsigned
* units_sold : bigint(20) unsigned
* revenue : decimal(18,2)
* created_at : datetime
* updated_at : datetime
v csv3n wp_cs_search_index
* id : bigint(20) unsigned
* object_id : bigint(20) unsigned
* object_type : varchar(20)
* title_norm : text
* sku_norm : varchar(200)
* codes_norm : text
* brand_norm : varchar(200)
* cats_norm : text
* attrs_norm : text
* in_stock : tinyint(1)
* pop_score : int(11)
* updated_at : datetime
v csv3n wp_cs_search_stats
* id : bigint(20) unsigned
* term : varchar(191)
* created_at : datetime
v csv3n wp_cs_search_stats_daily
* id : bigint(20) unsigned
* date : date
* country : varchar(2)
* object_id : bigint(20) unsigned
* object_type : varchar(20)
* clicks : int(10) unsigned
v csv3n wp_cs_tokens_log
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* delta : int(11)
* balance_after : int(11)
* type : varchar(20)
* note : text
* created_at : datetime
v csv3n wp_cs_viral_assets
* id : bigint(20) unsigned
* title : varchar(255)
* short_label : varchar(120)
* platform : varchar(50)
* video_url : text
* cover_image : text
* product_id : bigint(20) unsigned
* product_secondary_ids : text
* cta_label : varchar(120)
* cta_url : text
* is_active : tinyint(1)
* priority : int(11)
* editorial_boost : decimal(10,2)
* start_date : date
* end_date : date
* tags : text
* created_at : datetime
* updated_at : datetime
v csv3n wp_fsmpt_email_logs
* id : int(10) unsigned
* site_id : int(10) unsigned
* to : varchar(255)
* from : varchar(255)
* subject : varchar(255)
* body : longtext
* headers : longtext
* attachments : longtext
* status : varchar(20)
* response : text
* extra : text
* retries : int(10) unsigned
* resent_count : int(10) unsigned
* source : varchar(255)
* created_at : timestamp
* updated_at : timestamp
v csv3n wp_litespeed_url
* id : bigint(20)
* url : varchar(500)
* cache_tags : varchar(1000)
v csv3n wp_litespeed_url_file
* id : bigint(20)
* url_id : bigint(20)
* vary : varchar(32)
* filename : varchar(32)
* type : tinyint(4)
* mobile : tinyint(4)
* webp : tinyint(4)
* expired : int(11)
v csv3n wp_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v csv3n wp_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v csv3n wp_posts
* ID : bigint(20) unsigned
* post_author : bigint(20) unsigned
* post_date : datetime
* post_date_gmt : datetime
* post_content : longtext
* post_title : text
* post_excerpt : text
* post_status : varchar(20)
* comment_status : varchar(20)
* ping_status : varchar(20)
* post_password : varchar(255)
* post_name : varchar(200)
* to_ping : text
* pinged : text
* post_modified : datetime
* post_modified_gmt : datetime
* post_content_filtered : longtext
* post_parent : bigint(20) unsigned
* guid : varchar(255)
* menu_order : int(11)
* post_type : varchar(20)
* post_mime_type : varchar(100)
* comment_count : bigint(20)
v csv3n wp_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v csv3n wp_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v csv3n wp_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v csv3n wp_term_taxonomy
* term_taxonomy_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* taxonomy : varchar(32)
* description : longtext
* parent : bigint(20) unsigned
* count : bigint(20)
v csv3n wp_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v csv3n wp_users
* ID : bigint(20) unsigned
* user_login : varchar(60)
* user_pass : varchar(255)
* user_nicename : varchar(50)
* user_email : varchar(100)
* user_url : varchar(100)
* user_registered : datetime
* user_activation_key : varchar(255)
* user_status : int(11)
* display_name : varchar(250)
v csv3n wp_wc_admin_notes
* note_id : bigint(20) unsigned
* name : varchar(255)
* type : varchar(20)
* locale : varchar(20)
* title : longtext
* content : longtext
* content_data : longtext
* status : varchar(200)
* source : varchar(200)
* date_created : datetime
* date_reminder : datetime
* is_snoozable : tinyint(1)
* layout : varchar(20)
* image : varchar(200)
* is_deleted : tinyint(1)
* is_read : tinyint(1)
* icon : varchar(200)
v csv3n wp_wc_admin_note_actions
* action_id : bigint(20) unsigned
* note_id : bigint(20) unsigned
* name : varchar(255)
* label : varchar(255)
* query : longtext
* status : varchar(255)
* actioned_text : varchar(255)
* nonce_action : varchar(255)
* nonce_name : varchar(255)
v csv3n wp_wc_category_lookup
* category_tree_id : bigint(20) unsigned
* category_id : bigint(20) unsigned
v csv3n wp_wc_customer_lookup
* customer_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* username : varchar(60)
* first_name : varchar(255)
* last_name : varchar(255)
* email : varchar(100)
* date_last_active : timestamp
* date_registered : timestamp
* country : char(2)
* postcode : varchar(20)
* city : varchar(100)
* state : varchar(100)
v csv3n wp_wc_download_log
* download_log_id : bigint(20) unsigned
* timestamp : datetime
* permission_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* user_ip_address : varchar(100)
v csv3n wp_wc_orders
* id : bigint(20) unsigned
* status : varchar(20)
* currency : varchar(10)
* type : varchar(20)
* tax_amount : decimal(26,8)
* total_amount : decimal(26,8)
* customer_id : bigint(20) unsigned
* billing_email : varchar(320)
* date_created_gmt : datetime
* date_updated_gmt : datetime
* parent_order_id : bigint(20) unsigned
* payment_method : varchar(100)
* payment_method_title : text
* transaction_id : varchar(100)
* ip_address : varchar(100)
* user_agent : text
* customer_note : text
v csv3n wp_wc_orders_meta
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : text
v csv3n wp_wc_order_addresses
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* address_type : varchar(20)
* first_name : text
* last_name : text
* company : text
* address_1 : text
* address_2 : text
* city : text
* state : text
* postcode : text
* country : text
* email : varchar(320)
* phone : varchar(100)
v csv3n wp_wc_order_coupon_lookup
* order_id : bigint(20) unsigned
* coupon_id : bigint(20)
* date_created : datetime
* discount_amount : double
v csv3n wp_wc_order_operational_data
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* created_via : varchar(100)
* woocommerce_version : varchar(20)
* prices_include_tax : tinyint(1)
* coupon_usages_are_counted : tinyint(1)
* download_permission_granted : tinyint(1)
* cart_hash : varchar(100)
* new_order_email_sent : tinyint(1)
* order_key : varchar(100)
* order_stock_reduced : tinyint(1)
* date_paid_gmt : datetime
* date_completed_gmt : datetime
* shipping_tax_amount : decimal(26,8)
* shipping_total_amount : decimal(26,8)
* discount_tax_amount : decimal(26,8)
* discount_total_amount : decimal(26,8)
* recorded_sales : tinyint(1)
v csv3n wp_wc_order_product_lookup
* order_item_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* variation_id : bigint(20) unsigned
* customer_id : bigint(20) unsigned
* date_created : datetime
* product_qty : int(11)
* product_net_revenue : double
* product_gross_revenue : double
* coupon_amount : double
* tax_amount : double
* shipping_amount : double
* shipping_tax_amount : double
v csv3n wp_wc_order_stats
* order_id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* date_created : datetime
* date_created_gmt : datetime
* date_paid : datetime
* date_completed : datetime
* num_items_sold : int(11)
* total_sales : double
* tax_total : double
* shipping_total : double
* net_total : double
* returning_customer : tinyint(1)
* status : varchar(20)
* customer_id : bigint(20) unsigned
v csv3n wp_wc_order_tax_lookup
* order_id : bigint(20) unsigned
* tax_rate_id : bigint(20) unsigned
* date_created : datetime
* shipping_tax : double
* order_tax : double
* total_tax : double
v csv3n wp_wc_product_attributes_lookup
* product_id : bigint(20)
* product_or_parent_id : bigint(20)
* taxonomy : varchar(32)
* term_id : bigint(20)
* is_variation_attribute : tinyint(1)
* in_stock : tinyint(1)
v csv3n wp_wc_product_download_directories
* url_id : bigint(20) unsigned
* url : varchar(256)
* enabled : tinyint(1)
v csv3n wp_wc_product_meta_lookup
* product_id : bigint(20)
* sku : varchar(100)
* global_unique_id : varchar(100)
* virtual : tinyint(1)
* downloadable : tinyint(1)
* min_price : decimal(19,4)
* max_price : decimal(19,4)
* onsale : tinyint(1)
* stock_quantity : double
* stock_status : varchar(100)
* rating_count : bigint(20)
* average_rating : decimal(3,2)
* total_sales : bigint(20)
* tax_status : varchar(100)
* tax_class : varchar(100)
v csv3n wp_wc_rate_limits
* rate_limit_id : bigint(20) unsigned
* rate_limit_key : varchar(200)
* rate_limit_expiry : bigint(20) unsigned
* rate_limit_remaining : smallint(10)
v csv3n wp_wc_reserved_stock
* order_id : bigint(20)
* product_id : bigint(20)
* stock_quantity : double
* timestamp : datetime
* expires : datetime
v csv3n wp_wc_tax_rate_classes
* tax_rate_class_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
v csv3n wp_wc_webhooks
* webhook_id : bigint(20) unsigned
* status : varchar(200)
* name : text
* user_id : bigint(20) unsigned
* delivery_url : text
* secret : text
* topic : varchar(200)
* date_created : datetime
* date_created_gmt : datetime
* date_modified : datetime
* date_modified_gmt : datetime
* api_version : smallint(4)
* failure_count : smallint(10)
* pending_delivery : tinyint(1)
v csv3n wp_wm_blacklist
* id : int(10) unsigned
* date_created : varchar(255)
* meli_user_id : varchar(15)
* nickname : varchar(255)
* reason : varchar(5000)
* status : varchar(255)
v csv3n wp_wm_ext_qanda
* id : int(10) unsigned
* date : datetime
* question_id : varchar(255)
* answer : varchar(5000)
* date_created : varchar(255)
* deleted_from_listing : varchar(255)
* hold : varchar(255)
* item_id : varchar(255)
* seller_id : varchar(255)
* status : varchar(255)
* text : varchar(3000)
* from_user : varchar(255)
* from_user_extra : varchar(255)
* connect_ml : varchar(5)
* hidden : varchar(5)
* extra1 : varchar(255)
* extra2 : varchar(255)
v csv3n wp_wm_templatesync
* id : int(10) unsigned
* date : datetime
v csv3n wp_wm_templatesync_meta
* id : int(10) unsigned
* templatesync_id : int(10) unsigned
* templatesync_key : varchar(255)
* templatesync_value : longtext
v csv3n wp_woocommerce_api_keys
* key_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* description : varchar(200)
* permissions : varchar(10)
* consumer_key : char(64)
* consumer_secret : char(43)
* nonces : longtext
* truncated_key : char(7)
* last_access : datetime
v csv3n wp_woocommerce_attribute_taxonomies
* attribute_id : bigint(20) unsigned
* attribute_name : varchar(200)
* attribute_label : varchar(200)
* attribute_type : varchar(20)
* attribute_orderby : varchar(20)
* attribute_public : int(1)
v csv3n wp_woocommerce_downloadable_product_permissions
* permission_id : bigint(20) unsigned
* download_id : varchar(36)
* product_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* order_key : varchar(200)
* user_email : varchar(200)
* user_id : bigint(20) unsigned
* downloads_remaining : varchar(9)
* access_granted : datetime
* access_expires : datetime
* download_count : bigint(20) unsigned
v csv3n wp_woocommerce_log
* log_id : bigint(20) unsigned
* timestamp : datetime
* level : smallint(4)
* source : varchar(200)
* message : longtext
* context : longtext
v csv3n wp_woocommerce_order_itemmeta
* meta_id : bigint(20) unsigned
* order_item_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v csv3n wp_woocommerce_order_items
* order_item_id : bigint(20) unsigned
* order_item_name : text
* order_item_type : varchar(200)
* order_id : bigint(20) unsigned
v csv3n wp_woocommerce_payment_tokenmeta
* meta_id : bigint(20) unsigned
* payment_token_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v csv3n wp_woocommerce_payment_tokens
* token_id : bigint(20) unsigned
* gateway_id : varchar(200)
* token : text
* user_id : bigint(20) unsigned
* type : varchar(200)
* is_default : tinyint(1)
v csv3n wp_woocommerce_sessions
* session_id : bigint(20) unsigned
* session_key : char(32)
* session_value : longtext
* session_expiry : bigint(20) unsigned
v csv3n wp_woocommerce_shipping_zones
* zone_id : bigint(20) unsigned
* zone_name : varchar(200)
* zone_order : bigint(20) unsigned
v csv3n wp_woocommerce_shipping_zone_locations
* location_id : bigint(20) unsigned
* zone_id : bigint(20) unsigned
* location_code : varchar(200)
* location_type : varchar(40)
v csv3n wp_woocommerce_shipping_zone_methods
* zone_id : bigint(20) unsigned
* instance_id : bigint(20) unsigned
* method_id : varchar(200)
* method_order : bigint(20) unsigned
* is_enabled : tinyint(1)
v csv3n wp_woocommerce_tax_rates
* tax_rate_id : bigint(20) unsigned
* tax_rate_country : varchar(2)
* tax_rate_state : varchar(200)
* tax_rate : varchar(8)
* tax_rate_name : varchar(200)
* tax_rate_priority : bigint(20) unsigned
* tax_rate_compound : int(1)
* tax_rate_shipping : int(1)
* tax_rate_order : bigint(20) unsigned
* tax_rate_class : varchar(200)
v csv3n wp_woocommerce_tax_rate_locations
* location_id : bigint(20) unsigned
* location_code : varchar(200)
* tax_rate_id : bigint(20) unsigned
* location_type : varchar(40)
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación