www.cabello.ws / localhost / wordpress

There are no recent tables.

There are no favorite tables.

New
aaa
- aaa
- aaa_fabricas_pruebas
abanq
- abanq_23
- abanq_23 experimental
articulos
autocompleta
azulejoscabello.com
- azulejoscabello.com
- azulejoscabello.com_tienda
azulejoscabello_com
book_sc
cabecab4
cabello-enterprises
- cabello-enterprises
- cabello-enterprises_exp
contabilidad
datatablesv03
durstone
eneboo
grespania
information_schema
intermediaria_online
jplist
keraben
letodms
letodms experimental
magazine
mydms
mydms experimental
mysql
pamesa_filter
performance_schema
php_producto
- php_producto
- php_producto_prueba
sys
tutorial
wordpress
- wordpress
- wordpress_desarrollo

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Untitled *

v		wordpress wp_actionscheduler_actions
action_id : bigint unsigned
hook : varchar(191)
status : varchar(20)
scheduled_date_gmt : datetime
scheduled_date_local : datetime
priority : tinyint unsigned
args : varchar(191)
schedule : longtext
group_id : bigint unsigned
attempts : int
last_attempt_gmt : datetime
last_attempt_local : datetime
claim_id : bigint unsigned
extended_args : varchar(8000)

v		wordpress wp_actionscheduler_claims
claim_id : bigint unsigned
date_created_gmt : datetime

v		wordpress wp_actionscheduler_groups
group_id : bigint unsigned
slug : varchar(255)

v		wordpress wp_actionscheduler_logs
log_id : bigint unsigned
action_id : bigint unsigned
message : text
log_date_gmt : datetime
log_date_local : datetime

v		wordpress wp_commentmeta
meta_id : bigint unsigned
comment_id : bigint unsigned
meta_key : varchar(255)
meta_value : longtext

v		wordpress wp_comments
comment_ID : bigint unsigned
comment_post_ID : bigint 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
comment_approved : varchar(20)
comment_agent : varchar(255)
comment_type : varchar(20)
comment_parent : bigint unsigned
user_id : bigint unsigned

v		wordpress wp_is_inverted_index
post_id : bigint
term : varchar(40)
term_reverse : varchar(40)
score : mediumint
title : mediumint
content : mediumint
excerpt : mediumint
comment : mediumint
author : mediumint
category : mediumint
tag : mediumint
taxonomy : mediumint
customfield : mediumint
taxonomy_detail : longtext
customfield_detail : longtext
type : varchar(210)
lang : varchar(20)

v		wordpress wp_links
link_id : bigint unsigned
link_url : varchar(255)
link_name : varchar(255)
link_image : varchar(255)
link_target : varchar(25)
link_description : varchar(255)
link_visible : varchar(20)
link_owner : bigint unsigned
link_rating : int
link_updated : datetime
link_rel : varchar(255)
link_notes : mediumtext
link_rss : varchar(255)

v		wordpress wp_options
option_id : bigint unsigned
option_name : varchar(191)
option_value : longtext
autoload : varchar(20)

v		wordpress wp_postmeta
meta_id : bigint unsigned
post_id : bigint unsigned
meta_key : varchar(255)
meta_value : longtext

v		wordpress wp_posts
ID : bigint unsigned
post_author : bigint 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 unsigned
guid : varchar(255)
menu_order : int
post_type : varchar(20)
post_mime_type : varchar(100)
comment_count : bigint

v		wordpress wp_termmeta
meta_id : bigint unsigned
term_id : bigint unsigned
meta_key : varchar(255)
meta_value : longtext

v		wordpress wp_terms
term_id : bigint unsigned
name : varchar(200)
slug : varchar(200)
term_group : bigint

v		wordpress wp_term_relationships
object_id : bigint unsigned
term_taxonomy_id : bigint unsigned
term_order : int

v		wordpress wp_term_taxonomy
term_taxonomy_id : bigint unsigned
term_id : bigint unsigned
taxonomy : varchar(32)
description : longtext
parent : bigint unsigned
count : bigint

v		wordpress wp_usermeta
umeta_id : bigint unsigned
user_id : bigint unsigned
meta_key : varchar(255)
meta_value : longtext

v		wordpress wp_users
ID : bigint 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
display_name : varchar(250)

v		wordpress wp_wc_admin_notes
note_id : bigint 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		wordpress wp_wc_admin_note_actions
action_id : bigint unsigned
note_id : bigint 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		wordpress wp_wc_category_lookup
category_tree_id : bigint unsigned
category_id : bigint unsigned

v		wordpress wp_wc_customer_lookup
customer_id : bigint unsigned
user_id : bigint 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		wordpress wp_wc_download_log
download_log_id : bigint unsigned
timestamp : datetime
permission_id : bigint unsigned
user_id : bigint unsigned
user_ip_address : varchar(100)

v		wordpress wp_wc_orders
id : bigint unsigned
status : varchar(20)
currency : varchar(10)
type : varchar(20)
tax_amount : decimal(26,8)
total_amount : decimal(26,8)
customer_id : bigint unsigned
billing_email : varchar(320)
date_created_gmt : datetime
date_updated_gmt : datetime
parent_order_id : bigint unsigned
payment_method : varchar(100)
payment_method_title : text
transaction_id : varchar(100)
ip_address : varchar(100)
user_agent : text
customer_note : text

v		wordpress wp_wc_orders_meta
id : bigint unsigned
order_id : bigint unsigned
meta_key : varchar(255)
meta_value : text

v		wordpress wp_wc_order_addresses
id : bigint unsigned
order_id : bigint 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		wordpress wp_wc_order_coupon_lookup
order_id : bigint unsigned
coupon_id : bigint
date_created : datetime
discount_amount : double

v		wordpress wp_wc_order_operational_data
id : bigint unsigned
order_id : bigint 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		wordpress wp_wc_order_product_lookup
order_item_id : bigint unsigned
order_id : bigint unsigned
product_id : bigint unsigned
variation_id : bigint unsigned
customer_id : bigint unsigned
date_created : datetime
product_qty : int
product_net_revenue : double
product_gross_revenue : double
coupon_amount : double
tax_amount : double
shipping_amount : double
shipping_tax_amount : double

v		wordpress wp_wc_order_stats
order_id : bigint unsigned
parent_id : bigint unsigned
date_created : datetime
date_created_gmt : datetime
date_paid : datetime
date_completed : datetime
num_items_sold : int
total_sales : double
tax_total : double
shipping_total : double
net_total : double
returning_customer : tinyint(1)
status : varchar(20)
customer_id : bigint unsigned

v		wordpress wp_wc_order_tax_lookup
order_id : bigint unsigned
tax_rate_id : bigint unsigned
date_created : datetime
shipping_tax : double
order_tax : double
total_tax : double

v		wordpress wp_wc_product_attributes_lookup
product_id : bigint
product_or_parent_id : bigint
taxonomy : varchar(32)
term_id : bigint
is_variation_attribute : tinyint(1)
in_stock : tinyint(1)

v		wordpress wp_wc_product_download_directories
url_id : bigint unsigned
url : varchar(256)
enabled : tinyint(1)

v		wordpress wp_wc_product_meta_lookup
product_id : bigint
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
average_rating : decimal(3,2)
total_sales : bigint
tax_status : varchar(100)
tax_class : varchar(100)

v		wordpress wp_wc_rate_limits
rate_limit_id : bigint unsigned
rate_limit_key : varchar(200)
rate_limit_expiry : bigint unsigned
rate_limit_remaining : smallint

v		wordpress wp_wc_reserved_stock
order_id : bigint
product_id : bigint
stock_quantity : double
timestamp : datetime
expires : datetime

v		wordpress wp_wc_tax_rate_classes
tax_rate_class_id : bigint unsigned
name : varchar(200)
slug : varchar(200)

v		wordpress wp_wc_webhooks
webhook_id : bigint unsigned
status : varchar(200)
name : text
user_id : bigint 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
failure_count : smallint
pending_delivery : tinyint(1)

v		wordpress wp_woocommerce_api_keys
key_id : bigint unsigned
user_id : bigint 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		wordpress wp_woocommerce_attribute_taxonomies
attribute_id : bigint unsigned
attribute_name : varchar(200)
attribute_label : varchar(200)
attribute_type : varchar(20)
attribute_orderby : varchar(20)
attribute_public : int

v		wordpress wp_woocommerce_downloadable_product_permissions
permission_id : bigint unsigned
download_id : varchar(36)
product_id : bigint unsigned
order_id : bigint unsigned
order_key : varchar(200)
user_email : varchar(200)
user_id : bigint unsigned
downloads_remaining : varchar(9)
access_granted : datetime
access_expires : datetime
download_count : bigint unsigned

v		wordpress wp_woocommerce_log
log_id : bigint unsigned
timestamp : datetime
level : smallint
source : varchar(200)
message : longtext
context : longtext

v		wordpress wp_woocommerce_order_itemmeta
meta_id : bigint unsigned
order_item_id : bigint unsigned
meta_key : varchar(255)
meta_value : longtext

v		wordpress wp_woocommerce_order_items
order_item_id : bigint unsigned
order_item_name : text
order_item_type : varchar(200)
order_id : bigint unsigned

v		wordpress wp_woocommerce_payment_tokenmeta
meta_id : bigint unsigned
payment_token_id : bigint unsigned
meta_key : varchar(255)
meta_value : longtext

v		wordpress wp_woocommerce_payment_tokens
token_id : bigint unsigned
gateway_id : varchar(200)
token : text
user_id : bigint unsigned
type : varchar(200)
is_default : tinyint(1)

v		wordpress wp_woocommerce_sessions
session_id : bigint unsigned
session_key : char(32)
session_value : longtext
session_expiry : bigint unsigned

v		wordpress wp_woocommerce_shipping_zones
zone_id : bigint unsigned
zone_name : varchar(200)
zone_order : bigint unsigned

v		wordpress wp_woocommerce_shipping_zone_locations
location_id : bigint unsigned
zone_id : bigint unsigned
location_code : varchar(200)
location_type : varchar(40)

v		wordpress wp_woocommerce_shipping_zone_methods
zone_id : bigint unsigned
instance_id : bigint unsigned
method_id : varchar(200)
method_order : bigint unsigned
is_enabled : tinyint(1)

v		wordpress wp_woocommerce_tax_rates
tax_rate_id : bigint unsigned
tax_rate_country : varchar(2)
tax_rate_state : varchar(200)
tax_rate : varchar(8)
tax_rate_name : varchar(200)
tax_rate_priority : bigint unsigned
tax_rate_compound : int
tax_rate_shipping : int
tax_rate_order : bigint unsigned
tax_rate_class : varchar(200)

v		wordpress wp_woocommerce_tax_rate_locations
location_id : bigint unsigned
location_code : varchar(200)
tax_rate_id : bigint unsigned
location_type : varchar(40)

v		wordpress wp_woof_sd
id : int
title : text
type : varchar(32)
template : int
demo_taxonomy : varchar(96)
options : text

Create relationship
FOREIGN KEY
on delete
on update