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 full-screen 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 rce_blog1 rce_blogactionscheduler_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 rce_blog1 rce_blogactionscheduler_claims
* claim_id : bigint(20) unsigned
* date_created_gmt : datetime
v rce_blog1 rce_blogactionscheduler_groups
* group_id : bigint(20) unsigned
* slug : varchar(255)
v rce_blog1 rce_blogactionscheduler_logs
* log_id : bigint(20) unsigned
* action_id : bigint(20) unsigned
* message : text
* log_date_gmt : datetime
* log_date_local : datetime
v rce_blog1 rce_blogcommentmeta
* meta_id : bigint(20) unsigned
* comment_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v rce_blog1 rce_blogcomments
* 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 rce_blog1 rce_blogduplicator_packages
* id : bigint(20) unsigned
* name : varchar(250)
* hash : varchar(50)
* status : int(11)
* created : datetime
* owner : varchar(60)
* package : longtext
v rce_blog1 rce_bloge_events
* id : bigint(20) unsigned
* event_data : text
* created_at : datetime
v rce_blog1 rce_bloghustle_entries
* entry_id : bigint(20) unsigned
* entry_type : varchar(191)
* module_id : bigint(20) unsigned
* date_created : datetime
v rce_blog1 rce_bloghustle_entries_meta
* meta_id : bigint(20) unsigned
* entry_id : bigint(20) unsigned
* meta_key : varchar(191)
* meta_value : longtext
* date_created : datetime
* date_updated : datetime
v rce_blog1 rce_bloghustle_modules
* module_id : bigint(20) unsigned
* blog_id : bigint(20) unsigned
* module_name : varchar(255)
* module_type : varchar(100)
* active : tinyint(4)
* module_mode : varchar(100)
v rce_blog1 rce_bloghustle_modules_meta
* meta_id : bigint(20) unsigned
* module_id : bigint(20) unsigned
* meta_key : varchar(191)
* meta_value : longtext
v rce_blog1 rce_bloghustle_tracking
* tracking_id : bigint(20) unsigned
* module_id : bigint(20) unsigned
* page_id : bigint(20) unsigned
* module_type : varchar(100)
* action : varchar(100)
* ip : varchar(191)
* counter : mediumint(8) unsigned
* date_created : datetime
* date_updated : datetime
v rce_blog1 rce_blogig_actions
* contact_id : bigint(20) unsigned
* message_id : bigint(20) unsigned
* campaign_id : bigint(20) unsigned
* type : tinyint(1)
* count : int(11) unsigned
* list_id : int(11) unsigned
* ip : varchar(50)
* country : varchar(50)
* device : varchar(50)
* browser : varchar(50)
* email_client : varchar(50)
* os : varchar(50)
* created_at : int(11) unsigned
* updated_at : int(11) unsigned
v rce_blog1 rce_blogig_blocked_emails
* id : int(10)
* email : varchar(50)
* ip : varchar(45)
* created_on : timestamp
v rce_blog1 rce_blogig_campaigns
* id : int(10)
* slug : varchar(255)
* name : varchar(255)
* type : varchar(50)
* parent_id : int(10) unsigned
* parent_type : varchar(50)
* subject : varchar(255)
* body : longtext
* from_name : varchar(250)
* from_email : varchar(150)
* reply_to_name : varchar(250)
* reply_to_email : varchar(150)
* categories : text
* list_ids : text
* base_template_id : int(10)
* status : tinyint(4)
* meta : longtext
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v rce_blog1 rce_blogig_contactmeta
* meta_id : bigint(20)
* contact_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v rce_blog1 rce_blogig_contacts
* id : int(10)
* wp_user_id : int(10)
* first_name : varchar(50)
* last_name : varchar(50)
* email : varchar(50)
* source : varchar(50)
* ip_address : varchar(50)
* country_code : varchar(50)
* form_id : int(10)
* status : varchar(10)
* unsubscribed : tinyint(1)
* hash : varchar(50)
* created_at : datetime
* updated_at : datetime
* is_verified : tinyint(1)
* is_disposable : tinyint(1)
* is_rolebased : tinyint(1)
* is_webmail : tinyint(1)
* is_deliverable : tinyint(1)
* is_sendsafely : tinyint(1)
* meta : longtext
v rce_blog1 rce_blogig_contacts_ips
* ip : varchar(45)
* created_on : timestamp
v rce_blog1 rce_blogig_contact_meta
* id : int(10)
* contact_id : bigint(10) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v rce_blog1 rce_blogig_forms
* id : int(10)
* name : varchar(255)
* body : longtext
* settings : longtext
* styles : longtext
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
* af_id : int(10)
v rce_blog1 rce_blogig_lists
* id : int(10)
* slug : varchar(255)
* name : varchar(255)
* hash : varchar(12)
* created_at : datetime
* updated_at : datetime
* deleted_at : datetime
v rce_blog1 rce_blogig_lists_contacts
* id : int(10)
* list_id : int(10)
* contact_id : int(10)
* status : varchar(50)
* optin_type : tinyint(4)
* subscribed_at : datetime
* subscribed_ip : varchar(45)
* unsubscribed_at : datetime
* unsubscribed_ip : varchar(45)
v rce_blog1 rce_blogig_mailing_queue
* id : int(10)
* hash : varchar(50)
* campaign_id : int(10)
* subject : text
* body : longtext
* count : int(10) unsigned
* status : varchar(10)
* start_at : datetime
* finish_at : datetime
* meta : longtext
* created_at : datetime
* updated_at : datetime
v rce_blog1 rce_blogig_queue
* contact_id : bigint(20) unsigned
* campaign_id : bigint(20) unsigned
* requeued : tinyint(1) unsigned
* added : int(11) unsigned
* timestamp : int(11) unsigned
* sent_at : int(11) unsigned
* priority : tinyint(1) unsigned
* count : tinyint(1) unsigned
* error : tinyint(1) unsigned
* ignore_status : tinyint(1) unsigned
* options : varchar(191)
* tags : longtext
v rce_blog1 rce_blogig_sending_queue
* id : int(10)
* mailing_queue_id : int(10)
* mailing_queue_hash : varchar(50)
* campaign_id : int(10)
* contact_id : int(10)
* contact_hash : varchar(255)
* email : varchar(50)
* status : varchar(50)
* opened : int(1)
* sent_at : datetime
* opened_at : datetime
v rce_blog1 rce_blogig_temp_import
* ID : bigint(20)
* data : longtext
* identifier : char(13)
v rce_blog1 rce_blogig_unsubscribe_feedback
* id : int(10)
* contact_id : int(10) unsigned
* list_id : int(10) unsigned
* campaign_id : int(10) unsigned
* mailing_queue_id : int(10) unsigned
* feedback_slug : varchar(50)
* feedback_text : varchar(500)
* created_at : datetime
* updated_at : datetime
* meta : longtext
v rce_blog1 rce_blogig_wc_cart
* id : bigint(20)
* status : varchar(100)
* user_id : bigint(20)
* guest_id : bigint(20)
* last_modified : datetime
* created : datetime
* items : longtext
* coupons : longtext
* fees : longtext
* shipping_tax_total : double
* shipping_total : double
* total : double
* token : varchar(32)
* currency : varchar(8)
v rce_blog1 rce_blogig_wc_guests
* id : bigint(20)
* email : varchar(255)
* tracking_key : varchar(32)
* created : datetime
* last_active : datetime
* meta : longtext
* language : varchar(10)
* most_recent_order : bigint(20)
* version : bigint(20)
v rce_blog1 rce_blogig_workflows
* id : int(10)
* name : varchar(255)
* title : varchar(255)
* trigger_name : varchar(250)
* trigger_options : longtext
* rules : longtext
* actions : longtext
* status : tinyint(4)
* type : tinyint(4)
* priority : int(11)
* meta : longtext
* created_at : datetime
* updated_at : datetime
v rce_blog1 rce_blogig_workflows_queue
* id : bigint(20)
* workflow_id : bigint(20)
* failed : int(1)
* failure_code : int(3)
* meta : longtext
* scheduled_at : datetime
* created_at : datetime
v rce_blog1 rce_bloglitespeed_avatar
* id : bigint(20) unsigned
* url : varchar(1000)
* md5 : varchar(128)
* dateline : int(11)
v rce_blog1 rce_bloglitespeed_img_optm
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* optm_status : tinyint(4)
* src : text
* src_filesize : int(11)
* target_filesize : int(11)
* webp_filesize : int(11)
v rce_blog1 rce_bloglitespeed_img_optming
* id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* optm_status : tinyint(4)
* src : varchar(1000)
* server_info : text
v rce_blog1 rce_bloglitespeed_url
* id : bigint(20)
* url : varchar(500)
* cache_tags : varchar(1000)
v rce_blog1 rce_bloglitespeed_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 rce_blog1 rce_blogoptions
* option_id : bigint(20) unsigned
* option_name : varchar(191)
* option_value : longtext
* autoload : varchar(20)
v rce_blog1 rce_blogpostmeta
* meta_id : bigint(20) unsigned
* post_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v rce_blog1 rce_blogposts
* 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 rce_blog1 rce_blogtermmeta
* meta_id : bigint(20) unsigned
* term_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v rce_blog1 rce_blogterms
* term_id : bigint(20) unsigned
* name : varchar(200)
* slug : varchar(200)
* term_group : bigint(10)
v rce_blog1 rce_blogterm_relationships
* object_id : bigint(20) unsigned
* term_taxonomy_id : bigint(20) unsigned
* term_order : int(11)
v rce_blog1 rce_blogterm_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 rce_blog1 rce_blogtm_taskmeta
* meta_id : bigint(20)
* task_id : bigint(20)
* meta_key : varchar(255)
* meta_value : longtext
v rce_blog1 rce_blogtm_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 rce_blog1 rce_blogusermeta
* umeta_id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* meta_key : varchar(255)
* meta_value : longtext
v rce_blog1 rce_blogusers
* 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 rce_blog1 rce_blogwsm_bouncevisits
* visitId : bigint(10) unsigned
* visitLastActionTime : datetime
v rce_blog1 rce_blogwsm_browsers
* id : tinyint(2) unsigned
* name : varchar(255)
v rce_blog1 rce_blogwsm_countries
* id : int(10) unsigned
* name : varchar(255)
* alpha2Code : varchar(2)
* alpha3Code : varchar(3)
* numericCode : smallint(6)
v rce_blog1 rce_blogwsm_dailyhourlyreport
* id : int(10) unsigned
* name : varchar(50)
* reportDate : datetime
* content : text
* timezone : varchar(20)
v rce_blog1 rce_blogwsm_datewisebounce
* recordDate : varchar(10)
* bounce : bigint(21)
v rce_blog1 rce_blogwsm_datewisebouncerate
* recordDate : varchar(10)
* bounce : bigint(21)
* pageViews : decimal(42,0)
* visitors : bigint(21)
* bRatePageViews : decimal(27,4)
* bRateVisitors : decimal(27,4)
v rce_blog1 rce_blogwsm_datewisefirstvisitors
* recordDate : varchar(10)
* visitors : bigint(21)
v rce_blog1 rce_blogwsm_datewisepageviews
* recordDate : varchar(10)
* pageViews : decimal(42,0)
v rce_blog1 rce_blogwsm_datewisevisitors
* recordDate : varchar(10)
* visitors : bigint(21)
v rce_blog1 rce_blogwsm_datewise_report
* id : int(10) unsigned
* date : date
* normal : int(2)
* hour : int(2)
* search_engine : varchar(255)
* browser : int(2)
* screen : int(2)
* country : int(3)
* city : varchar(255)
* operating_system : int(2)
* url_id : int(11)
* total_page_views : int(11)
* total_visitors : int(11)
* total_first_time_visitors : int(11)
* total_bounce : int(11)
v rce_blog1 rce_blogwsm_hourwisebounce
* hour : int(2)
* bounce : bigint(21)
v rce_blog1 rce_blogwsm_hourwisebouncerate
* hour : int(2)
* bounce : bigint(21)
* pageViews : decimal(42,0)
* visitors : bigint(21)
* bRatePageViews : decimal(27,4)
* bRateVisitors : decimal(27,4)
v rce_blog1 rce_blogwsm_hourwisefirstvisitors
* hour : int(2)
* visitors : bigint(21)
v rce_blog1 rce_blogwsm_hourwisepageviews
* hour : int(2)
* pageViews : decimal(42,0)
v rce_blog1 rce_blogwsm_hourwisevisitors
* hour : int(2)
* visitors : bigint(21)
v rce_blog1 rce_blogwsm_loguniquevisit
* id : bigint(10) unsigned
* siteId : int(10) unsigned
* visitorId : varchar(20)
* visitLastActionTime : datetime
* configId : varchar(20)
* ipAddress : varchar(16)
* userId : varchar(200)
* firstActionVisitTime : datetime
* daysSinceFirstVisit : smallint(5) unsigned
* returningVisitor : tinyint(1)
* visitCount : int(11) unsigned
* visitEntryURLId : int(11) unsigned
* visitExitURLId : int(11) unsigned
* visitTotalActions : int(11) unsigned
* refererUrlId : int(11)
* browserLang : varchar(20)
* browserId : int(11) unsigned
* deviceType : varchar(20)
* oSystemId : int(11) unsigned
* currentLocalTime : time
* daysSinceLastVisit : smallint(5) unsigned
* totalTimeVisit : int(11) unsigned
* resolutionId : int(11) unsigned
* cookie : tinyint(1)
* director : tinyint(1)
* flash : tinyint(1)
* gears : tinyint(1)
* java : tinyint(1)
* pdf : tinyint(1)
* quicktime : tinyint(1)
* realplayer : tinyint(1)
* silverlight : tinyint(1)
* windowsmedia : tinyint(1)
* city : varchar(255)
* countryId : int(3) unsigned
* latitude : decimal(9,6)
* longitude : decimal(9,6)
* regionId : tinyint(2)
v rce_blog1 rce_blogwsm_logvisit
* id : bigint(10) unsigned
* siteId : int(10) unsigned
* visitorId : varchar(20)
* visitId : bigint(10) unsigned
* refererUrlId : int(10) unsigned
* keyword : varchar(200)
* serverTime : datetime
* timeSpentRef : int(11) unsigned
* URLId : int(10) unsigned
v rce_blog1 rce_blogwsm_monthlydailyreport
* id : int(10) unsigned
* name : varchar(50)
* reportMonthYear : varchar(50)
* content : text
* timezone : varchar(20)
v rce_blog1 rce_blogwsm_monthwisebounce
* recordMonth : varchar(7)
* bounce : bigint(21)
v rce_blog1 rce_blogwsm_monthwisebouncerate
* recordMonth : varchar(7)
* bounce : bigint(21)
* pageViews : decimal(42,0)
* visitors : bigint(21)
* bRatePageViews : decimal(27,4)
* bRateVisitors : decimal(27,4)
v rce_blog1 rce_blogwsm_monthwisefirstvisitors
* recordMonth : varchar(7)
* visitors : bigint(21)
v rce_blog1 rce_blogwsm_monthwisepageviews
* recordMonth : varchar(7)
* pageViews : decimal(42,0)
v rce_blog1 rce_blogwsm_monthwisevisitors
* recordMonth : varchar(7)
* visitors : bigint(21)
v rce_blog1 rce_blogwsm_monthwise_report
* id : int(10) unsigned
* date : date
* normal : int(2)
* hour : int(2)
* search_engine : varchar(255)
* browser : int(2)
* screen : int(2)
* country : int(3)
* city : varchar(255)
* operating_system : int(2)
* url_id : int(11)
* total_page_views : int(11)
* total_visitors : int(11)
* total_first_time_visitors : int(11)
* total_bounce : int(11)
v rce_blog1 rce_blogwsm_osystems
* id : tinyint(2) unsigned
* name : varchar(255)
v rce_blog1 rce_blogwsm_pageviews
* visitId : bigint(10) unsigned
* URLId : int(10) unsigned
* keyword : varchar(200)
* refererUrlId : int(10) unsigned
* countryId : int(3) unsigned
* regionId : tinyint(2)
* totalViews : bigint(21)
* visitLastActionTime : datetime
v rce_blog1 rce_blogwsm_regions
* id : tinyint(1) unsigned
* code : char(2)
* name : varchar(255)
v rce_blog1 rce_blogwsm_resolutions
* id : tinyint(2) unsigned
* name : varchar(255)
v rce_blog1 rce_blogwsm_searchengines
* id : tinyint(2) unsigned
* name : varchar(255)
v rce_blog1 rce_blogwsm_toolbars
* id : tinyint(2) unsigned
* name : varchar(255)
v rce_blog1 rce_blogwsm_uniquevisitors
* id : bigint(10) unsigned
* visitorId : varchar(20)
* totalTimeVisit : decimal(33,0)
* firstVisitTime : datetime
* refererUrlId : int(11)
v rce_blog1 rce_blogwsm_url_log
* id : int(10) unsigned
* pageId : int(10) unsigned
* title : text
* hash : varchar(20)
* protocol : varchar(10)
* url : text
* searchEngine : int(2) unsigned
* toolBar : int(2) unsigned
v rce_blog1 rce_blogwsm_visitorinfo
* visitId : bigint(10) unsigned
* userId : varchar(200)
* serverTime : datetime
* visitLastActionTime : datetime
* urlId : int(10) unsigned
* hits : bigint(21)
* title : text
* url : mediumtext
* refUrl : mediumtext
* visitorId : varchar(20)
* ipAddress : varchar(16)
* city : varchar(255)
* alpha2Code : varchar(2)
* country : varchar(255)
* deviceType : varchar(20)
* browser : varchar(255)
* osystem : varchar(255)
* latitude : decimal(9,6)
* longitude : decimal(9,6)
* resolution : varchar(255)
* searchEngine : varchar(255)
* toolBar : varchar(255)
v rce_blog1 rce_blogwsm_yearlymonthlyreport
* id : int(10) unsigned
* name : varchar(50)
* reportYear : varchar(10)
* content : text
* timezone : varchar(20)
v rce_blog1 rce_blogwsm_yearwise_report
* id : int(10) unsigned
* date : date
* normal : int(2)
* hour : int(2)
* search_engine : varchar(255)
* browser : int(2)
* screen : int(2)
* country : int(3)
* city : varchar(255)
* operating_system : int(2)
* url_id : int(11)
* total_page_views : int(11)
* total_visitors : int(11)
* total_first_time_visitors : int(11)
* total_bounce : int(11)
v rce_blog1 rce_blogyoast_indexable
* id : int(11) 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(11) unsigned
* canonical : longtext
* primary_focus_keyword : varchar(191)
* primary_focus_keyword_score : int(3)
* readability_score : int(3)
* 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(11) 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(3)
v rce_blog1 rce_blogyoast_indexable_hierarchy
* indexable_id : int(11) unsigned
* ancestor_id : int(11) unsigned
* depth : int(11) unsigned
* blog_id : bigint(20)
v rce_blog1 rce_blogyoast_migrations
* id : int(11) unsigned
* version : varchar(191)
v rce_blog1 rce_blogyoast_primary_term
* id : int(11) 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