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 db_cnasv red_ahm_download_stats
* id : int(11)
* pid : int(11)
* uid : int(11)
* oid : varchar(100)
* year : int(4)
* month : int(2)
* day : int(2)
* timestamp : int(11)
* ip : varchar(20)
v db_cnasv red_ahm_emails
* id : int(11)
* email : varchar(255)
* pid : int(11)
* date : int(11)
* custom_data : text
* request_status : int(1)
v db_cnasv red_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv red_comments
* comment_ID : bigint(20) unsigned
* comment_post_ID : bigint(20) unsigned
* comment_author : text
* comment_author_email : varchar(100)
* comment_author_url : varchar(200)
* comment_author_IP : varchar(100)
* comment_date : datetime
* comment_date_gmt : datetime
* comment_content : mediumtext
* 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 db_cnasv red_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v db_cnasv red_popularpostsdata
* postid : bigint(20)
* day : datetime
* last_viewed : datetime
* pageviews : bigint(20)
v db_cnasv red_popularpostssummary
* ID : bigint(20)
* postid : bigint(20)
* pageviews : bigint(20)
* view_date : date
* view_datetime : datetime
v db_cnasv red_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv red_posts
* ID : bigint(20) unsigned
* post_author : bigint(20) unsigned
* post_date : datetime
* post_date_gmt : datetime
* post_content : longtext
* post_title : mediumtext
* post_excerpt : mediumtext
* post_status : varchar(20)
* comment_status : varchar(20)
* ping_status : varchar(20)
* post_password : varchar(255)
* post_name : varchar(200)
* to_ping : mediumtext
* pinged : mediumtext
* 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 db_cnasv red_showbiz_settings
* id : int(9)
* wildcards : text
* general : text
* params : text
v db_cnasv red_showbiz_sliders
* id : int(9)
* title : tinytext
* alias : tinytext
* params : text
v db_cnasv red_showbiz_slides
* id : int(9)
* slider_id : int(9)
* slide_order : int(11)
* params : text
v db_cnasv red_showbiz_templates
* id : int(9)
* title : tinytext
* type : tinytext
* content : text
* css : text
* ordering : int(11)
* params : text
v db_cnasv red_statistics_exclusions
* ID : int(11)
* date : date
* reason : varchar(255)
* count : bigint(20)
v db_cnasv red_statistics_historical
* ID : bigint(20)
* category : varchar(25)
* page_id : bigint(20)
* uri : varchar(255)
* value : bigint(20)
v db_cnasv red_statistics_pages
* page_id : bigint(20)
* uri : varchar(255)
* type : varchar(255)
* date : date
* count : int(11)
* id : int(11)
v db_cnasv red_statistics_useronline
* ID : int(11)
* ip : varchar(60)
* created : int(11)
* timestamp : int(10)
* date : datetime
* referred : text
* agent : varchar(255)
* platform : varchar(255)
* version : varchar(255)
* location : varchar(10)
* user_id : bigint(48)
* page_id : bigint(48)
* type : varchar(100)
v db_cnasv red_statistics_visit
* ID : int(11)
* last_visit : datetime
* last_counter : date
* visit : int(10)
v db_cnasv red_statistics_visitor
* ID : int(11)
* last_counter : date
* referred : text
* agent : varchar(255)
* platform : varchar(255)
* version : varchar(255)
* UAString : varchar(255)
* ip : varchar(60)
* location : varchar(10)
* hits : int(11)
* honeypot : int(11)
v db_cnasv red_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv red_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v db_cnasv red_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v db_cnasv red_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 db_cnasv red_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv red_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 db_cnasv red_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 db_cnasv red_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 db_cnasv red_woocommerce_downloadable_product_permissions
* permission_id : bigint(20) unsigned
* download_id : varchar(32)
* 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 db_cnasv red_woocommerce_log
* log_id : bigint(20) unsigned
* timestamp : datetime
* level : smallint(4)
* source : varchar(200)
* message : longtext
* context : longtext
v db_cnasv red_woocommerce_order_itemmeta
* meta_id : bigint(20) unsigned
* order_item_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv red_woocommerce_order_items
* order_item_id : bigint(20) unsigned
* order_item_name : text
* order_item_type : varchar(200)
* order_id : bigint(20) unsigned
v db_cnasv red_woocommerce_payment_tokenmeta
* meta_id : bigint(20) unsigned
* payment_token_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv red_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 db_cnasv red_woocommerce_sessions
* session_id : bigint(20) unsigned
* session_key : char(32)
* session_value : longtext
* session_expiry : bigint(20) unsigned
v db_cnasv red_woocommerce_shipping_zones
* zone_id : bigint(20) unsigned
* zone_name : varchar(200)
* zone_order : bigint(20) unsigned
v db_cnasv red_woocommerce_shipping_zone_locations
* location_id : bigint(20) unsigned
* zone_id : bigint(20) unsigned
* location_code : varchar(200)
* location_type : varchar(40)
v db_cnasv red_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 db_cnasv red_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 db_cnasv red_woocommerce_tax_rate_locations
* location_id : bigint(20) unsigned
* location_code : varchar(200)
* tax_rate_id : bigint(20) unsigned
* location_type : varchar(40)
v db_cnasv red_wpgmza
* id : int(11)
* map_id : int(11)
* address : varchar(700)
* description : mediumtext
* pic : varchar(700)
* icon : varchar(700)
* lat : varchar(100)
* lng : varchar(100)
* anim : varchar(3)
* title : varchar(700)
* infoopen : varchar(3)
* category : varchar(500)
* approved : tinyint(1)
* retina : tinyint(1)
v db_cnasv red_wpgmza_categories
* id : int(11)
* active : tinyint(1)
* category_name : varchar(50)
* category_icon : varchar(700)
* retina : tinyint(1)
v db_cnasv red_wpgmza_category_maps
* id : int(11)
* cat_id : int(11)
* map_id : int(11)
v db_cnasv red_wpgmza_maps
* id : int(11)
* map_title : varchar(50)
* map_width : varchar(6)
* map_height : varchar(6)
* map_start_lat : varchar(700)
* map_start_lng : varchar(700)
* map_start_location : varchar(700)
* map_start_zoom : int(10)
* default_marker : varchar(700)
* type : int(10)
* alignment : int(10)
* directions_enabled : int(10)
* styling_enabled : int(10)
* styling_json : mediumtext
* active : int(1)
* kml : varchar(700)
* bicycle : int(10)
* traffic : int(10)
* dbox : int(10)
* dbox_width : varchar(10)
* listmarkers : int(10)
* listmarkers_advanced : int(10)
* filterbycat : tinyint(1)
* ugm_enabled : int(10)
* ugm_category_enabled : tinyint(1)
* fusion : varchar(100)
* map_width_type : varchar(3)
* map_height_type : varchar(3)
* mass_marker_support : int(10)
* ugm_access : int(10)
* order_markers_by : int(10)
* order_markers_choice : int(10)
* show_user_location : int(3)
* default_to : varchar(700)
* other_settings : longtext
v db_cnasv red_wpgmza_polygon
* id : int(11)
* map_id : int(11)
* polydata : longtext
* linecolor : varchar(7)
* lineopacity : varchar(7)
* fillcolor : varchar(7)
* opacity : varchar(3)
* title : varchar(250)
* ohfillcolor : varchar(7)
* ohlinecolor : varchar(7)
* ohopacity : varchar(3)
* polyname : varchar(100)
v db_cnasv red_wpgmza_polylines
* id : int(11)
* map_id : int(11)
* polydata : longtext
* linecolor : varchar(7)
* linethickness : varchar(3)
* opacity : varchar(3)
* polyname : varchar(100)
v db_cnasv red_wp_rp_tags
* post_id : mediumint(9)
* post_date : datetime
* label : varchar(32)
* weight : float
v db_cnasv wp_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv 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 db_cnasv wp_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v db_cnasv wp_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv 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 db_cnasv wp_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv wp_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v db_cnasv wp_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v db_cnasv 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 db_cnasv wp_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v db_cnasv 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)
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación