Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v wordpress wp_actionscheduler_actions
* action_id : bigint(20) unsigned
* hook : varchar(191)
* status : varchar(20)
* scheduled_date_gmt : datetime
* scheduled_date_local : datetime
* 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 wordpress wp_actionscheduler_claims
* claim_id : bigint(20) unsigned
* date_created_gmt : datetime
v wordpress wp_actionscheduler_groups
* group_id : bigint(20) unsigned
* slug : varchar(255)
v wordpress wp_actionscheduler_logs
* log_id : bigint(20) unsigned
* action_id : bigint(20) unsigned
* message : text
* log_date_gmt : datetime
* log_date_local : datetime
v wordpress wp_catfolders
* id : int(10) unsigned
* title : varchar(250)
* parent : int(10) unsigned
* type : varchar(20)
* ord : int(10) unsigned
* created_by : bigint(20)
v wordpress wp_catfolders_posts
* folder_id : int(10) unsigned
* post_id : bigint(20) unsigned
v wordpress wp_commentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress 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 wordpress wp_e_events
* id : bigint(20) unsigned
* event_data : text
* created_at : datetime
v wordpress wp_e_notes
* id : bigint(20) unsigned
* route_url : text
* route_title : varchar(255)
* route_post_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* element_id : varchar(60)
* parent_id : bigint(20) unsigned
* author_id : bigint(20) unsigned
* author_display_name : varchar(250)
* status : varchar(20)
* position : text
* content : longtext
* is_resolved : tinyint(1)
* is_public : tinyint(1)
* last_activity_at : datetime
* created_at : datetime
* updated_at : datetime
v wordpress wp_e_notes_users_relations
* id : bigint(20) unsigned
* type : varchar(60)
* note_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* created_at : datetime
* updated_at : datetime
v wordpress wp_e_submissions
* id : bigint(20) unsigned
* type : varchar(60)
* hash_id : varchar(60)
* main_meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* referer : varchar(500)
* referer_title : varchar(300)
* element_id : varchar(20)
* form_name : varchar(60)
* campaign_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* user_ip : varchar(46)
* user_agent : text
* actions_count : int(11)
* actions_succeeded_count : int(11)
* status : varchar(20)
* is_read : tinyint(1)
* meta : text
* created_at_gmt : datetime
* updated_at_gmt : datetime
* created_at : datetime
* updated_at : datetime
v wordpress wp_e_submissions_actions_log
* id : bigint(20) unsigned
* submission_id : bigint(20) unsigned
* action_name : varchar(60)
* action_label : varchar(60)
* status : varchar(20)
* log : text
* created_at_gmt : datetime
* updated_at_gmt : datetime
* created_at : datetime
* updated_at : datetime
v wordpress wp_e_submissions_values
* id : bigint(20) unsigned
* submission_id : bigint(20) unsigned
* key : varchar(60)
* value : longtext
v wordpress wp_litespeed_url
* id : bigint(20)
* url : varchar(500)
* cache_tags : varchar(1000)
v wordpress 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 wordpress wp_options
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v wordpress wp_pmb_external_resources
* ID : bigint(20) unsigned
* external_url : varchar(511)
* copy_filename : varchar(511)
v wordpress wp_pmb_project_sections
* ID : bigint(20) unsigned
* project_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* parent_id : bigint(20) unsigned
* section_order : int(11)
* template : varchar(50)
* placement : varchar(15)
* height : smallint(6)
* depth : smallint(6)
v wordpress wp_postmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress 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 wordpress wp_termmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_terms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(20)
v wordpress wp_term_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v wordpress 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 wordpress wp_tm_taskmeta
* meta_id : bigint(20)
* task_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v wordpress wp_tm_tasks
* id : int(11)
* user_id : bigint(20)
* type : varchar(300)
* class_identifier : varchar(300)
* attempts : int(11)
* description : varchar(300)
* time_created : timestamp
* last_locked_at : bigint(20)
* status : varchar(300)
v wordpress wp_usermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v wordpress 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 wordpress wp_wfauditevents
* id : bigint(20) unsigned
* type : varchar(255)
* data : text
* event_time : double(14,4)
* request_id : bigint(20) unsigned
* state : enum('new','sending','sent')
* state_timestamp : timestamp
v wordpress wp_wfblockediplog
* IP : binary(16)
* countryCode : varchar(2)
* blockCount : int(10) unsigned
* unixday : int(10) unsigned
* blockType : varchar(50)
v wordpress wp_wfblocks7
* id : bigint(20) unsigned
* type : int(10) unsigned
* IP : binary(16)
* blockedTime : bigint(20)
* reason : varchar(255)
* lastAttempt : int(10) unsigned
* blockedHits : int(10) unsigned
* expiration : bigint(20) unsigned
* parameters : text
v wordpress wp_wfconfig
* name : varchar(100)
* val : longblob
* autoload : enum('no','yes')
v wordpress wp_wfcrawlers
* IP : binary(16)
* patternSig : binary(16)
* status : char(8)
* lastUpdate : int(10) unsigned
* PTR : varchar(255)
v wordpress wp_wffilechanges
* filenameHash : char(64)
* file : varchar(1000)
* md5 : char(32)
v wordpress wp_wffilemods
* filenameMD5 : binary(16)
* filename : varchar(1000)
* real_path : text
* knownFile : tinyint(3) unsigned
* oldMD5 : binary(16)
* newMD5 : binary(16)
* SHAC : binary(32)
* stoppedOnSignature : varchar(255)
* stoppedOnPosition : int(10) unsigned
* isSafeFile : varchar(1)
v wordpress wp_wfhits
* id : int(10) unsigned
* attackLogTime : double(17,6) unsigned
* ctime : double(17,6) unsigned
* IP : binary(16)
* jsRun : tinyint(4)
* statusCode : int(11)
* isGoogle : tinyint(4)
* userID : int(10) unsigned
* newVisit : tinyint(3) unsigned
* URL : text
* referer : text
* UA : text
* action : varchar(64)
* actionDescription : text
* actionData : text
v wordpress wp_wfhoover
* id : int(10) unsigned
* owner : text
* host : text
* path : text
* hostKey : varbinary(124)
v wordpress wp_wfissues
* id : int(10) unsigned
* time : int(10) unsigned
* lastUpdated : int(10) unsigned
* status : varchar(10)
* type : varchar(20)
* severity : tinyint(3) unsigned
* ignoreP : char(32)
* ignoreC : char(32)
* shortMsg : varchar(255)
* longMsg : text
* data : text
v wordpress wp_wfknownfilelist
* id : int(10) unsigned
* path : text
* wordpress_path : text
v wordpress wp_wflivetraffichuman
* IP : binary(16)
* identifier : binary(32)
* expiration : int(10) unsigned
v wordpress wp_wflocs
* IP : binary(16)
* ctime : int(10) unsigned
* failed : tinyint(3) unsigned
* city : varchar(255)
* region : varchar(255)
* countryName : varchar(255)
* countryCode : char(2)
* lat : float(10,7)
* lon : float(10,7)
v wordpress wp_wflogins
* id : int(10) unsigned
* hitID : int(11)
* ctime : double(17,6) unsigned
* fail : tinyint(3) unsigned
* action : varchar(40)
* username : varchar(255)
* userID : int(10) unsigned
* IP : binary(16)
* UA : text
v wordpress wp_wfls_2fa_secrets
* id : int(10) unsigned
* user_id : bigint(20) unsigned
* secret : tinyblob
* recovery : blob
* ctime : int(10) unsigned
* vtime : int(10) unsigned
* mode : enum('authenticator')
v wordpress wp_wfls_role_counts
* serialized_roles : varbinary(255)
* two_factor_inactive : tinyint(1)
* user_count : bigint(20) unsigned
v wordpress wp_wfls_settings
* name : varchar(191)
* value : longblob
* autoload : enum('no','yes')
v wordpress wp_wfnotifications
* id : varchar(32)
* new : tinyint(3) unsigned
* category : varchar(255)
* priority : int(11)
* ctime : int(10) unsigned
* html : text
v wordpress wp_wfpendingissues
* id : int(10) unsigned
* time : int(10) unsigned
* lastUpdated : int(10) unsigned
* status : varchar(10)
* type : varchar(20)
* severity : tinyint(3) unsigned
* ignoreP : char(32)
* ignoreC : char(32)
* shortMsg : varchar(255)
* longMsg : text
* data : text
v wordpress wp_wfreversecache
* IP : binary(16)
* host : varchar(255)
* lastUpdate : int(10) unsigned
v wordpress wp_wfsecurityevents
* id : bigint(20) unsigned
* type : varchar(255)
* data : text
* event_time : double(14,4)
* state : enum('new','sending','sent')
* state_timestamp : timestamp
v wordpress wp_wfsnipcache
* id : int(10) unsigned
* IP : varchar(45)
* expiration : timestamp
* body : varchar(255)
* count : int(10) unsigned
* type : int(10) unsigned
v wordpress wp_wfstatus
* id : bigint(20) unsigned
* ctime : double(17,6) unsigned
* level : tinyint(3) unsigned
* type : char(5)
* msg : varchar(1000)
v wordpress wp_wftrafficrates
* eMin : int(10) unsigned
* IP : binary(16)
* hitType : enum('hit','404')
* hits : int(10) unsigned
v wordpress wp_wfwaffailures
* id : int(10) unsigned
* throwable : text
* rule_id : int(10) unsigned
* timestamp : timestamp
v wordpress wp_wpaas_activity_log
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* activity : text
* timestamp : datetime
v wordpress wp_wpfm_backup
* id : int(11)
* backup_name : text
* backup_date : text
v wordpress wp_wpforms_tasks_meta
* id : bigint(20)
* action : varchar(255)
* data : longtext
* date : datetime
v wordpress wp_wpmailsmtp_debug_events
* id : int(10) unsigned
* content : text
* initiator : text
* event_type : tinyint(3) unsigned
* created_at : timestamp
v wordpress wp_wpmailsmtp_tasks_meta
* id : bigint(20)
* action : varchar(255)
* data : longtext
* date : datetime
v wordpress wp_wprss_logs
* id : bigint(20)
* date : timestamp
* level : varchar(30)
* message : text
* feed_id : varchar(100)
v wordpress wp_wp_phpmyadmin_extension__errors_log
* id : int(11)
* gmdate : datetime
* function_name : longtext
* function_args : longtext
* message : longtext
v wordpress wp_yoast_indexable
* id : int(10) unsigned
* object_id : bigint(20)
* object_type : varchar(32)
* object_sub_type : varchar(32)
* author_id : bigint(20)
* post_parent : bigint(20)
* title : text
* description : mediumtext
* breadcrumb_title : text
* post_status : varchar(20)
* is_public : tinyint(1)
* is_protected : tinyint(1)
* has_public_posts : tinyint(1)
* number_of_pages : int(10) unsigned
* canonical : longtext
* primary_focus_keyword : varchar(191)
* primary_focus_keyword_score : int(11)
* readability_score : int(11)
* is_cornerstone : tinyint(1)
* is_robots_noindex : tinyint(1)
* is_robots_nofollow : tinyint(1)
* is_robots_noarchive : tinyint(1)
* is_robots_noimageindex : tinyint(1)
* is_robots_nosnippet : tinyint(1)
* twitter_title : text
* twitter_image : longtext
* twitter_description : longtext
* twitter_image_id : varchar(191)
* twitter_image_source : text
* open_graph_title : text
* open_graph_description : longtext
* open_graph_image : longtext
* open_graph_image_id : varchar(191)
* open_graph_image_source : text
* open_graph_image_meta : mediumtext
* prominent_words_version : int(10) unsigned
* created_at : datetime
* updated_at : timestamp
* blog_id : bigint(20)
* language : varchar(32)
* region : varchar(32)
* schema_page_type : varchar(64)
* schema_article_type : varchar(64)
* has_ancestors : tinyint(1)
* estimated_reading_time_minutes : int(11)
* version : int(11)
* object_last_modified : datetime
* object_published_at : datetime
* inclusive_language_score : int(11)
v wordpress wp_yoast_indexable_hierarchy
* indexable_id : int(10) unsigned
* ancestor_id : int(10) unsigned
* depth : int(10) unsigned
* blog_id : bigint(20)
v wordpress wp_yoast_migrations
* id : int(10) unsigned
* version : varchar(191)
v wordpress wp_yoast_primary_term
* id : int(10) unsigned
* post_id : bigint(20)
* term_id : bigint(20)
* taxonomy : varchar(32)
* created_at : datetime
* updated_at : timestamp
* blog_id : bigint(20)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship