DATABASE STRUCTURE — timenlife.shop (WordPress + WooCommerce) Source backup: backup_2026-08-02-1741_TimeNLife_91f04792cfa1-db.zip (UpdraftPlus) Total tables: 159 ========================================================================================== TABLE: wp_options [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra option_id bigint(20) unsigned NO option_name varchar(191) NO '' option_value longtext NO autoload varchar(20) NO 'yes' Keys: - PRIMARY KEY (`option_name`) - UNIQUE KEY `option_id` (`option_id`) - UNIQUE KEY `option_name` (`option_name`) - KEY `autoload` (`autoload`) TABLE: wp_users [10 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra ID bigint(20) unsigned NO user_login varchar(60) NO '' user_pass varchar(255) NO '' user_nicename varchar(50) NO '' user_email varchar(100) NO '' user_url varchar(100) NO '' user_registered datetime NO '0000-00-00 00:00:00' user_activation_key varchar(255) NO '' user_status int(11) NO 0 display_name varchar(250) NO '' Keys: - PRIMARY KEY (`ID`) - KEY `user_login_key` (`user_login`) - KEY `user_nicename` (`user_nicename`) - KEY `user_email` (`user_email`) - KEY `display_name` (`display_name`) TABLE: wp_usermeta [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra umeta_id bigint(20) unsigned NO user_id bigint(20) unsigned NO 0 meta_key varchar(255) NO meta_value longtext YES NULL Keys: - PRIMARY KEY (`user_id`,`meta_key`,`umeta_id`) - UNIQUE KEY `umeta_id` (`umeta_id`) - KEY `meta_key` (`meta_key`,`meta_value`(32),`user_id`,`umeta_id`) - KEY `meta_value` (`meta_value`(32),`umeta_id`) - KEY `user_id` (`user_id`) TABLE: wp_actionscheduler_actions [14 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra action_id bigint(20) unsigned NO hook varchar(191) NO status varchar(20) NO scheduled_date_gmt datetime YES '0000-00-00 00:00:00' scheduled_date_local datetime YES '0000-00-00 00:00:00' priority tinyint(3) unsigned NO 10 args varchar(191) YES NULL schedule longtext YES NULL group_id bigint(20) unsigned NO 0 attempts int(11) NO 0 last_attempt_gmt datetime YES '0000-00-00 00:00:00' last_attempt_local datetime YES '0000-00-00 00:00:00' claim_id bigint(20) unsigned NO 0 extended_args varchar(8000) YES NULL Keys: - PRIMARY KEY (`action_id`) - KEY `hook_status_scheduled_date_gmt` (`hook`(163),`status`,`scheduled_date_gmt`) - KEY `status_scheduled_date_gmt` (`status`,`scheduled_date_gmt`) - KEY `scheduled_date_gmt` (`scheduled_date_gmt`) - KEY `args` (`args`) - KEY `group_id` (`group_id`) - KEY `last_attempt_gmt` (`last_attempt_gmt`) - KEY `claim_id_status_scheduled_date_gmt` (`claim_id`,`status`,`scheduled_date_gmt`) - KEY `claim_id_status_priority_scheduled_date_gmt` (`claim_id`,`status`,`priority`,`scheduled_date_gmt`) - KEY `status_last_attempt_gmt` (`status`,`last_attempt_gmt`) - KEY `status_claim_id` (`status`,`claim_id`) TABLE: wp_actionscheduler_claims [2 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra claim_id bigint(20) unsigned NO date_created_gmt datetime YES '0000-00-00 00:00:00' Keys: - PRIMARY KEY (`claim_id`) - KEY `date_created_gmt` (`date_created_gmt`) TABLE: wp_actionscheduler_groups [2 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra group_id bigint(20) unsigned NO slug varchar(255) NO Keys: - PRIMARY KEY (`group_id`) - KEY `slug` (`slug`(191)) TABLE: wp_actionscheduler_logs [5 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra log_id bigint(20) unsigned NO action_id bigint(20) unsigned NO message text NO log_date_gmt datetime YES '0000-00-00 00:00:00' log_date_local datetime YES '0000-00-00 00:00:00' Keys: - PRIMARY KEY (`log_id`) - KEY `action_id` (`action_id`) - KEY `log_date_gmt` (`log_date_gmt`) TABLE: wp_bwpup_backups [11 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO destination varchar(255) NO '' filename varchar(255) YES NULL job_id bigint(20) unsigned YES NULL status varchar(255) NO '' error_code varchar(32) YES NULL error_message longtext YES NULL logfile varchar(255) YES NULL backup_trigger varchar(32) NO '' modified timestamp NO '0000-00-00 00:00:00' submitted_at timestamp YES NULL Keys: - PRIMARY KEY (`id`) - KEY `modified` (`modified`) - KEY `destination` (`destination`(191)) - KEY `error_code_index` (`error_code`) TABLE: wp_commentmeta [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra meta_id bigint(20) unsigned NO comment_id bigint(20) unsigned NO 0 meta_key varchar(255) NO meta_value longtext YES NULL Keys: - PRIMARY KEY (`meta_key`,`comment_id`,`meta_id`) - UNIQUE KEY `meta_id` (`meta_id`) - KEY `comment_id` (`comment_id`,`meta_key`,`meta_value`(32)) - KEY `meta_value` (`meta_value`(32)) - KEY `meta_key` (`meta_key`(191)) TABLE: wp_comments [15 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra comment_ID bigint(20) unsigned NO comment_post_ID bigint(20) unsigned NO 0 comment_author tinytext NO comment_author_email varchar(100) NO '' comment_author_url varchar(200) NO '' comment_author_IP varchar(100) NO '' comment_date datetime NO '0000-00-00 00:00:00' comment_date_gmt datetime NO '0000-00-00 00:00:00' comment_content text NO comment_karma int(11) NO 0 comment_approved varchar(20) NO '1' comment_agent varchar(255) NO '' comment_type varchar(20) NO 'comment' comment_parent bigint(20) unsigned NO 0 user_id bigint(20) unsigned NO 0 Keys: - PRIMARY KEY (`comment_post_ID`,`comment_ID`) - UNIQUE KEY `comment_ID` (`comment_ID`) - KEY `woo_idx_comment_type` (`comment_type`) - KEY `woo_idx_comment_date_type` (`comment_date_gmt`,`comment_type`,`comment_approved`,`comment_post_ID`) - KEY `woo_idx_comment_approved_type` (`comment_approved`,`comment_type`,`comment_post_ID`) - KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`,`comment_ID`) - KEY `comment_date_gmt` (`comment_date_gmt`,`comment_ID`) - KEY `comment_parent` (`comment_parent`,`comment_ID`) - KEY `comment_author_email` (`comment_author_email`,`comment_post_ID`,`comment_ID`) - KEY `comment_post_parent_approved` (`comment_post_ID`,`comment_parent`,`comment_approved`,`comment_type`,`user_id`,`comment_date_gmt`,`comment_ID`) - KEY `comment_post_id` (`comment_post_ID`) TABLE: wp_links [13 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra link_id bigint(20) unsigned NO link_url varchar(255) NO '' link_name varchar(255) NO '' link_image varchar(255) NO '' link_target varchar(25) NO '' link_description varchar(255) NO '' link_visible varchar(20) NO 'Y' link_owner bigint(20) unsigned NO 1 link_rating int(11) NO 0 link_updated datetime NO '0000-00-00 00:00:00' link_rel varchar(255) NO '' link_notes mediumtext NO link_rss varchar(255) NO '' Keys: - PRIMARY KEY (`link_id`) - KEY `link_visible` (`link_visible`) TABLE: wp_postmeta [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra meta_id bigint(20) unsigned NO post_id bigint(20) unsigned NO 0 meta_key varchar(255) NO meta_value longtext YES NULL Keys: - PRIMARY KEY (`post_id`,`meta_key`,`meta_id`) - UNIQUE KEY `meta_id` (`meta_id`) - KEY `meta_key` (`meta_key`,`meta_value`(32),`post_id`,`meta_id`) - KEY `meta_value` (`meta_value`(32),`meta_id`) - KEY `post_id` (`post_id`) TABLE: wp_posts [23 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra ID bigint(20) unsigned NO post_author bigint(20) unsigned NO 0 post_date datetime NO '0000-00-00 00:00:00' post_date_gmt datetime NO '0000-00-00 00:00:00' post_content longtext NO post_title text NO post_excerpt text NO post_status varchar(20) NO 'publish' comment_status varchar(20) NO 'open' ping_status varchar(20) NO 'open' post_password varchar(255) NO '' post_name varchar(200) NO '' to_ping text NO pinged text NO post_modified datetime NO '0000-00-00 00:00:00' post_modified_gmt datetime NO '0000-00-00 00:00:00' post_content_filtered longtext NO post_parent bigint(20) unsigned NO 0 guid varchar(255) NO '' menu_order int(11) NO 0 post_type varchar(20) NO 'post' post_mime_type varchar(100) NO '' comment_count bigint(20) NO 0 Keys: - PRIMARY KEY (`ID`) - KEY `post_name` (`post_name`) - KEY `post_parent` (`post_parent`,`post_type`,`post_status`) - KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`post_author`) - KEY `post_author` (`post_author`,`post_type`,`post_status`,`post_date`) - KEY `type_status_author` (`post_type`,`post_status`,`post_author`) TABLE: wp_term_relationships [3 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra object_id bigint(20) unsigned NO 0 term_taxonomy_id bigint(20) unsigned NO 0 term_order int(11) NO 0 Keys: - PRIMARY KEY (`object_id`,`term_taxonomy_id`) - KEY `term_taxonomy_id` (`term_taxonomy_id`) TABLE: wp_term_taxonomy [6 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra term_taxonomy_id bigint(20) unsigned NO term_id bigint(20) unsigned NO 0 taxonomy varchar(32) NO '' description longtext NO parent bigint(20) unsigned NO 0 count bigint(20) NO 0 Keys: - PRIMARY KEY (`term_taxonomy_id`) - UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`) - KEY `taxonomy` (`taxonomy`) TABLE: wp_termmeta [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra meta_id bigint(20) unsigned NO term_id bigint(20) unsigned NO 0 meta_key varchar(255) NO meta_value longtext YES NULL Keys: - PRIMARY KEY (`term_id`,`meta_key`,`meta_id`) - UNIQUE KEY `meta_id` (`meta_id`) - KEY `meta_key` (`meta_key`,`meta_value`(32),`term_id`,`meta_id`) - KEY `meta_value` (`meta_value`(32),`meta_id`) - KEY `term_id` (`term_id`) TABLE: wp_terms [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra term_id bigint(20) unsigned NO name varchar(200) NO '' slug varchar(200) NO '' term_group bigint(10) NO 0 Keys: - PRIMARY KEY (`term_id`) - KEY `slug` (`slug`(191)) - KEY `name` (`name`(191)) TABLE: wp_wc_category_lookup [2 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra category_tree_id bigint(20) unsigned NO category_id bigint(20) unsigned NO Keys: - PRIMARY KEY (`category_tree_id`,`category_id`) TABLE: wp_wc_product_meta_lookup [15 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra product_id bigint(20) NO sku varchar(100) YES '' global_unique_id varchar(100) YES '' virtual tinyint(1) YES 0 downloadable tinyint(1) YES 0 min_price decimal(19,4) YES NULL max_price decimal(19,4) YES NULL onsale tinyint(1) YES 0 stock_quantity double YES NULL stock_status varchar(100) YES 'instock' rating_count bigint(20) YES 0 average_rating decimal(3,2) YES 0.00 total_sales bigint(20) YES 0 tax_status varchar(100) YES 'taxable' tax_class varchar(100) YES '' Keys: - PRIMARY KEY (`product_id`) - KEY `virtual` (`virtual`) - KEY `downloadable` (`downloadable`) - KEY `stock_status` (`stock_status`) - KEY `stock_quantity` (`stock_quantity`) - KEY `onsale` (`onsale`) - KEY `min_max_price` (`min_price`,`max_price`) - KEY `sku` (`sku`(50)) TABLE: wp_wc_reserved_stock [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra order_id bigint(20) NO product_id bigint(20) NO stock_quantity double NO 0 timestamp datetime NO '0000-00-00 00:00:00' expires datetime NO '0000-00-00 00:00:00' Keys: - PRIMARY KEY (`order_id`,`product_id`) - KEY `product_id_expires` (`product_id`,`expires`) TABLE: wp_wc_tax_rate_classes [3 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra tax_rate_class_id bigint(20) unsigned NO name varchar(200) NO '' slug varchar(200) NO '' Keys: - PRIMARY KEY (`tax_rate_class_id`) - UNIQUE KEY `slug` (`slug`(191)) TABLE: wp_woocommerce_order_itemmeta [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra meta_id bigint(20) unsigned NO order_item_id bigint(20) unsigned NO meta_key varchar(255) NO meta_value longtext YES NULL Keys: - PRIMARY KEY (`order_item_id`,`meta_key`,`meta_id`) - UNIQUE KEY `meta_id` (`meta_id`) - KEY `meta_key` (`meta_key`,`meta_value`(32),`order_item_id`,`meta_id`) - KEY `meta_value` (`meta_value`(32),`meta_id`) - KEY `order_item_id` (`order_item_id`) TABLE: wp_woocommerce_payment_tokenmeta [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra meta_id bigint(20) unsigned NO payment_token_id bigint(20) unsigned NO meta_key varchar(255) YES NULL meta_value longtext YES NULL Keys: - PRIMARY KEY (`meta_id`) - KEY `payment_token_id` (`payment_token_id`) - KEY `meta_key` (`meta_key`(32)) TABLE: wp_aioseo_ai_insights_keyword_reports [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO uuid varchar(40) NO keyword varchar(255) NO status varchar(20) NO 'pending' brands longtext YES NULL brands_mentioned int(11) YES 0 results longtext YES NULL created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - KEY `ndx_aioseo_ai_insights_keyword_reports_uuid` (`uuid`) - KEY `ndx_aioseo_ai_insights_keyword_reports_keyword` (`keyword`) - KEY `ndx_aioseo_ai_insights_keyword_reports_status` (`status`) TABLE: wp_aioseo_blc_cache [7 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO value longtext NO is_object tinyint(1) YES 0 expiration datetime YES NULL created datetime NO updated datetime NO name varchar(80) NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_blc_cache_name` (`name`) - KEY `ndx_aioseo_blc_cache_expiration` (`expiration`) TABLE: wp_aioseo_blc_link_status [19 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO url text NO url_hash varchar(40) NO http_status_code smallint(6) YES NULL broken tinyint(1) unsigned NO 0 dismissed tinyint(1) NO 0 request_duration float YES NULL scan_count int(4) unsigned NO 0 redirect_count smallint(5) unsigned NO 0 final_url text YES NULL first_failure datetime YES NULL log text YES NULL last_scan_date datetime YES NULL created datetime NO updated datetime NO needs_additional_scan tinyint(1) unsigned NO 0 client_confirmed_broken tinyint(1) unsigned NO 0 last_success datetime YES NULL local_scan_count int(4) unsigned NO 0 Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_blc_link_status_url_hash` (`url_hash`) TABLE: wp_aioseo_blc_links [16 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO post_id bigint(20) unsigned NO blc_link_status_id bigint(20) unsigned YES NULL url text NO url_hash varchar(40) NO hostname text NO hostname_url varchar(40) NO external tinyint(1) NO 0 anchor text NO phrase text NO phrase_html text NO paragraph mediumtext NO paragraph_html mediumtext NO created datetime NO updated datetime NO is_video tinyint(1) NO 0 Keys: - PRIMARY KEY (`id`) - KEY `ndx_aioseo_blc_links_post_id` (`post_id`) - KEY `ndx_aioseo_blc_links_hostname` (`hostname`(10)) TABLE: wp_aioseo_blc_notifications [18 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO notification_id bigint(20) unsigned YES NULL notification_name varchar(255) YES NULL slug varchar(13) NO title text NO content longtext NO type varchar(64) NO level text NO start datetime YES NULL end datetime YES NULL button1_label varchar(255) YES NULL button1_action varchar(255) YES NULL button2_label varchar(255) YES NULL button2_action varchar(255) YES NULL dismissed tinyint(1) NO 0 new tinyint(1) NO 1 created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx__aioseo_blc_notifications_slug` (`slug`) - KEY `ndx__aioseo_blc_notifications_dates` (`start`,`end`) - KEY `ndx__aioseo_blc_notifications_type` (`type`) - KEY `ndx__aioseo_blc_notifications_dismissed` (`dismissed`) TABLE: wp_aioseo_blc_posts [5 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO post_id bigint(20) unsigned NO link_scan_date datetime YES NULL created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_blc_posts_post_id` (`post_id`) TABLE: wp_aioseo_cache [8 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO key varchar(80) YES NULL value longtext NO is_object tinyint(1) YES 0 expiration datetime YES NULL created datetime NO updated datetime NO name varchar(80) NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_cache_name` (`name`) - KEY `ndx_aioseo_cache_expiration` (`expiration`) TABLE: wp_aioseo_crawl_cleanup_blocked_args [10 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO param text YES NULL key text YES NULL value text YES NULL key_value_hash varchar(40) YES NULL regex varchar(150) YES NULL hits int(20) NO 0 created datetime NO updated datetime NO param_value_hash varchar(40) YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_crawl_cleanup_blocked_args_regex` (`regex`) - UNIQUE KEY `ndx_aioseo_crawl_cleanup_blocked_args_param_value_hash` (`param_value_hash`) TABLE: wp_aioseo_crawl_cleanup_logs [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO slug text NO param text NO key text YES NULL value text YES NULL hash varchar(40) NO hits int(20) NO 1 created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_crawl_cleanup_logs_hash` (`hash`) TABLE: wp_aioseo_notifications [19 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO slug varchar(13) NO addon varchar(64) YES NULL title text NO content longtext NO type varchar(64) NO level text NO notification_id bigint(20) unsigned YES NULL notification_name varchar(255) YES NULL start datetime YES NULL end datetime YES NULL button1_label varchar(255) YES NULL button1_action varchar(255) YES NULL button2_label varchar(255) YES NULL button2_action varchar(255) YES NULL dismissed tinyint(1) NO 0 new tinyint(1) NO 1 created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_notifications_slug` (`slug`) - KEY `ndx_aioseo_notifications_dates` (`start`,`end`) - KEY `ndx_aioseo_notifications_type` (`type`) - KEY `ndx_aioseo_notifications_dismissed` (`dismissed`) TABLE: wp_aioseo_posts [62 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO post_id bigint(20) unsigned NO title text YES NULL description text YES NULL keywords mediumtext YES NULL keyphrases longtext YES NULL page_analysis longtext YES NULL primary_term longtext YES NULL canonical_url text YES NULL og_title text YES NULL og_description text YES NULL og_object_type varchar(64) YES 'default' og_image_type varchar(64) YES 'default' og_image_url text YES NULL og_image_width int(11) YES NULL og_image_height int(11) YES NULL og_image_custom_url text YES NULL og_image_custom_fields text YES NULL og_video varchar(255) YES NULL og_custom_url text YES NULL og_article_section text YES NULL og_article_tags text YES NULL twitter_use_og tinyint(1) YES 0 twitter_card varchar(64) YES 'default' twitter_image_type varchar(64) YES 'default' twitter_image_url text YES NULL twitter_image_custom_url text YES NULL twitter_image_custom_fields text YES NULL twitter_title text YES NULL twitter_description text YES NULL seo_score int(11) NO 0 schema longtext YES NULL schema_type varchar(20) YES 'default' schema_type_options longtext YES NULL pillar_content tinyint(1) YES NULL robots_default tinyint(1) NO 1 robots_noindex tinyint(1) NO 0 robots_noarchive tinyint(1) NO 0 robots_nosnippet tinyint(1) NO 0 robots_nofollow tinyint(1) NO 0 robots_noimageindex tinyint(1) NO 0 robots_noodp tinyint(1) NO 0 robots_notranslate tinyint(1) NO 0 robots_max_snippet int(11) YES NULL robots_max_videopreview int(11) YES NULL robots_max_imagepreview varchar(20) YES 'large' images longtext YES NULL image_scan_date datetime YES NULL priority float YES NULL frequency tinytext YES NULL videos longtext YES NULL video_thumbnail text YES NULL video_scan_date datetime YES NULL local_seo longtext YES NULL breadcrumb_settings longtext YES NULL limit_modified_date tinyint(1) NO 0 options longtext YES NULL open_ai mediumtext YES NULL ai longtext YES NULL created datetime NO updated datetime NO seo_analyzer_scan_date datetime YES NULL Keys: - PRIMARY KEY (`id`) - KEY `ndx_aioseo_posts_post_id` (`post_id`) - KEY `ndx_aioseo_posts_pillar_content` (`pillar_content`) TABLE: wp_aioseo_revisions [8 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO object_id bigint(20) NO object_type varchar(20) NO author_id bigint(20) NO note varchar(255) YES NULL revision_data longtext NO created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - KEY `object` (`object_id`,`object_type`) TABLE: wp_aioseo_search_statistics_objects [12 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO object_id bigint(20) unsigned YES NULL object_type varchar(100) YES NULL object_subtype varchar(100) YES NULL object_path varchar(500) NO object_path_hash varchar(40) NO seo_score int(11) unsigned NO inspection_result longtext YES NULL inspection_result_date datetime YES NULL indexed tinyint(1) NO 0 created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - KEY `ndx_aioseo_object_id1` (`object_id`) - KEY `ndx_aioseo_object_path_hash1` (`object_path_hash`) TABLE: wp_aioseo_seo_analyzer_results [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO data text NO score varchar(255) YES NULL competitor_url varchar(255) YES NULL created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - KEY `ndx_aioseo_seo_analyzer_results_competitor_url` (`competitor_url`) TABLE: wp_aioseo_terms [46 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO term_id bigint(20) unsigned NO title text YES NULL description text YES NULL keywords mediumtext YES NULL canonical_url text YES NULL og_title text YES NULL og_description text YES NULL og_object_type varchar(64) YES 'default' og_image_type varchar(64) YES 'default' og_image_custom_url text YES NULL og_image_custom_fields text YES NULL og_custom_image_width int(11) YES NULL og_custom_image_height int(11) YES NULL og_video varchar(255) YES NULL og_custom_url text YES NULL og_article_section text YES NULL og_article_tags text YES NULL twitter_use_og tinyint(1) YES 0 twitter_card varchar(64) YES 'default' twitter_image_type varchar(64) YES 'default' twitter_image_custom_url text YES NULL twitter_image_custom_fields text YES NULL twitter_title text YES NULL twitter_description text YES NULL pillar_content tinyint(1) YES NULL robots_default tinyint(1) NO 1 robots_noindex tinyint(1) NO 0 robots_noarchive tinyint(1) NO 0 robots_nosnippet tinyint(1) NO 0 robots_nofollow tinyint(1) NO 0 robots_noimageindex tinyint(1) NO 0 robots_noodp tinyint(1) NO 0 robots_notranslate tinyint(1) NO 0 robots_max_snippet int(11) YES NULL robots_max_videopreview int(11) YES NULL robots_max_imagepreview varchar(20) YES 'large' priority float YES NULL frequency tinytext YES NULL images longtext YES NULL videos longtext YES NULL video_scan_date datetime YES NULL tabs mediumtext YES NULL local_seo longtext YES NULL created datetime NO updated datetime NO Keys: - PRIMARY KEY (`id`) - KEY `ndx_aioseo_terms_term_id` (`term_id`) TABLE: wp_aioseo_writing_assistant_keywords [10 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO uuid varchar(40) NO keyword varchar(255) NO country varchar(10) NO 'us' language varchar(10) NO 'en' progress tinyint(3) YES 0 keywords mediumtext YES NULL competitors mediumtext YES NULL created datetime NO updated datetime NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_writing_assistant_keywords_uuid` (`uuid`) - KEY `ndx_aioseo_writing_assistant_keywords_keyword` (`keyword`) TABLE: wp_aioseo_writing_assistant_posts [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO post_id bigint(20) unsigned YES NULL keyword_id bigint(20) unsigned YES NULL content_analysis_hash varchar(40) YES NULL content_analysis text YES NULL created datetime NO updated datetime NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `ndx_aioseo_writing_assistant_posts_post_id` (`post_id`) - KEY `ndx_aioseo_writing_assistant_posts_keyword_id` (`keyword_id`) TABLE: wp_cartflows_ca_cart_abandonment [11 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO checkout_id int(11) NO email varchar(100) YES NULL cart_contents longtext YES NULL cart_total decimal(10,2) YES NULL session_id varchar(60) NO other_fields longtext YES NULL order_status enum('normal','abandoned','completed','lost') NO 'normal' unsubscribed tinyint(1) YES 0 coupon_code varchar(50) YES NULL time datetime YES NULL Keys: - PRIMARY KEY (`id`,`session_id`) - UNIQUE KEY `session_id_UNIQUE` (`session_id`) TABLE: wp_cartflows_ca_email_history [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO template_id bigint(20) NO ca_session_id varchar(60) YES NULL coupon_code varchar(50) YES NULL scheduled_time datetime YES NULL email_sent tinyint(1) YES 0 Keys: - PRIMARY KEY (`id`) - KEY `template_id` (`template_id`) - KEY `ca_session_id` (`ca_session_id`) - CONSTRAINT `wp_cartflows_ca_email_history_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `wp_cartflows_ca_email_templates` (`id`) ON DELETE CASCADE - CONSTRAINT `wp_cartflows_ca_email_history_ibfk_2` FOREIGN KEY (`ca_session_id`) REFERENCES `wp_cartflows_ca_cart_abandonment` (`session_id`) ON DELETE CASCADE TABLE: wp_cartflows_ca_email_templates [7 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO template_name text NO email_subject text NO email_body mediumtext NO is_activated tinyint(1) NO 0 frequency int(11) NO frequency_unit enum('MINUTE','HOUR','DAY') NO 'MINUTE' Keys: - PRIMARY KEY (`id`) TABLE: wp_cartflows_ca_email_templates_meta [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO email_template_id bigint(20) NO meta_key varchar(255) NO meta_value longtext NO Keys: - PRIMARY KEY (`id`) - KEY `email_template_id` (`email_template_id`) - CONSTRAINT `wp_cartflows_ca_email_templates_meta_ibfk_1` FOREIGN KEY (`email_template_id`) REFERENCES `wp_cartflows_ca_email_templates` (`id`) ON DELETE CASCADE TABLE: wp_dokan_announcement [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO user_id bigint(20) unsigned NO post_id bigint(11) NO status varchar(30) NO Keys: - PRIMARY KEY (`id`) TABLE: wp_dokan_order_stats [12 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra order_id bigint(20) unsigned NO vendor_id bigint(20) unsigned NO 0 order_type tinyint(1) NO 0 vendor_earning double NO 0 vendor_gateway_fee double NO 0 vendor_shipping_fee double NO 0 vendor_discount double NO 0 admin_commission double NO 0 admin_gateway_fee double NO 0 admin_shipping_fee double NO 0 admin_discount double NO 0 admin_subsidy double NO 0 Keys: - PRIMARY KEY (`order_id`) - KEY `vendor_id` (`vendor_id`) - KEY `order_type` (`order_type`) TABLE: wp_dokan_orders [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO order_id bigint(20) YES NULL seller_id bigint(20) YES NULL order_total decimal(19,4) YES NULL net_amount decimal(19,4) YES NULL order_status varchar(30) YES NULL Keys: - PRIMARY KEY (`id`) - KEY `order_id` (`order_id`) - KEY `seller_id` (`seller_id`) TABLE: wp_dokan_refund [12 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO order_id bigint(20) unsigned NO seller_id bigint(20) NO refund_amount decimal(19,4) NO refund_reason text YES NULL item_qtys varchar(200) YES NULL item_totals text YES NULL item_tax_totals text YES NULL restock_items varchar(10) YES NULL date timestamp NO status int(1) NO method varchar(30) NO Keys: - PRIMARY KEY (`id`) TABLE: wp_dokan_reverse_withdrawal [8 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO trn_id bigint(20) unsigned NO trn_type varchar(200) NO 'order_commission' vendor_id bigint(20) unsigned NO note mediumtext YES NULL debit decimal(19,4) NO 0.0000 credit decimal(19,4) NO 0.0000 trn_date int(11) unsigned NO 0 Keys: - PRIMARY KEY (`id`) - KEY `trn_date` (`trn_date`) - KEY `vendor_id_trn_date` (`vendor_id`,`trn_date`) - KEY `vendor_id` (`vendor_id`) - KEY `trn_id_type` (`trn_id`,`trn_type`(191)) - KEY `vendor_id_trn_date_type` (`vendor_id`,`trn_date`,`trn_type`(191)) TABLE: wp_dokan_vendor_balance [10 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO vendor_id bigint(20) unsigned NO trn_id bigint(20) unsigned NO trn_type varchar(30) NO perticulars text NO debit decimal(19,4) NO credit decimal(19,4) NO status varchar(30) YES NULL trn_date timestamp NO balance_date timestamp NO Keys: - PRIMARY KEY (`id`) TABLE: wp_dokan_withdraw [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO user_id bigint(20) unsigned NO amount decimal(19,4) NO date timestamp NO status int(1) NO method varchar(30) NO note text NO details longtext YES NULL ip varchar(50) NO Keys: - PRIMARY KEY (`id`) TABLE: wp_duplicator_packages [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO name varchar(250) NO hash varchar(50) NO status int(11) NO created datetime NO '0000-00-00 00:00:00' owner varchar(60) NO package longtext NO Keys: - PRIMARY KEY (`id`) - KEY `hash` (`hash`) TABLE: wp_e_events [3 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO event_data text YES NULL created_at datetime NO Keys: - PRIMARY KEY (`id`) - KEY `created_at_index` (`created_at`) TABLE: wp_gla_attribute_mapping_rules [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO attribute varchar(255) NO source varchar(100) NO category_condition_type varchar(10) NO categories text YES '' Keys: - PRIMARY KEY (`id`) TABLE: wp_gla_budget_recommendations [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO currency varchar(3) NO country varchar(2) NO daily_budget int(11) NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `country_currency` (`country`,`currency`) TABLE: wp_gla_merchant_issues [12 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO product_id bigint(20) NO issue varchar(200) NO code varchar(100) NO severity varchar(20) NO 'warning' product varchar(100) NO action text NO action_url varchar(1024) NO applicable_countries text NO source varchar(10) NO 'mc' type varchar(10) NO 'product' created_at datetime NO Keys: - PRIMARY KEY (`id`) TABLE: wp_gla_merchant_price_benchmarks [19 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra product_id bigint(20) NO mc_product_id varchar(255) NO mc_product_offer_id varchar(255) NO mc_product_price_micros varchar(64) NO mc_product_currency_code varchar(3) NO mc_price_country_code varchar(2) NO mc_price_benchmark_price_micros varchar(64) NO mc_price_benchmark_price_currency_code varchar(3) NO mc_insights_suggested_price_micros varchar(64) NO mc_insights_suggested_price_currency_code varchar(3) NO mc_insights_predicted_impressions_change_fraction decimal(10,6) NO mc_insights_predicted_clicks_change_fraction decimal(10,6) NO mc_insights_predicted_conversions_change_fraction decimal(10,6) NO mc_insights_effectiveness tinyint(1) NO mc_metrics_clicks varchar(64) NO mc_metrics_impressions varchar(64) NO mc_metrics_ctr int(20) NO mc_metrics_conversions int(20) NO price_compared_with_benchmark tinyint(1) NO 0 Keys: - PRIMARY KEY (`product_id`) - UNIQUE KEY `mc_product_id` (`mc_product_id`) - KEY `mc_insights_effectiveness` (`mc_insights_effectiveness`) - KEY `price_compared_with_benchmark` (`price_compared_with_benchmark`) TABLE: wp_gla_shipping_rates [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO country varchar(2) NO currency varchar(3) NO rate double NO 0 options text YES NULL Keys: - PRIMARY KEY (`id`) - KEY `country` (`country`) - KEY `currency` (`currency`) TABLE: wp_gla_shipping_times [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO country varchar(2) NO time bigint(20) NO 0 max_time bigint(20) NO 0 Keys: - PRIMARY KEY (`id`) - KEY `country` (`country`) TABLE: wp_jetpack_sync_queue [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra ID bigint(20) NO queue_id varchar(50) NO event_id varchar(100) NO event_payload longtext NO timestamp timestamp NO current_timestamp() Keys: - PRIMARY KEY (`ID`) - KEY `event_id` (`event_id`) - KEY `queue_id` (`queue_id`) - KEY `queue_id_event_id` (`queue_id`,`event_id`) - KEY `timestamp` (`timestamp`) TABLE: wp_leopards_courier [3 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) NO store_key varchar(200) NO store_value longtext NO Keys: - PRIMARY KEY (`id`) TABLE: wp_leopards_courier_load_sheet [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) NO track_no varchar(200) NO load_sheet_id int(11) NO booking_datetime varchar(200) NO total_cn int(20) NO courier_name varchar(200) NO Courier_code varchar(200) NO Keys: - PRIMARY KEY (`id`) TABLE: wp_leopards_courier_sheet [8 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) NO track_no varchar(200) NO user_id int(11) NO order_id varchar(50) NO booking_datetime varchar(200) NO is_sheet int(11) NO is_cancel int(11) NO slip_url text NO Keys: - PRIMARY KEY (`id`) TABLE: wp_leopards_courier_shippers [5 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) NO shipper_name varchar(200) NO shipper_email varchar(200) NO shipper_address varchar(200) NO shipper_phone varchar(200) NO Keys: - PRIMARY KEY (`id`) TABLE: wp_litespeed_avatar [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO url varchar(1000) NO '' md5 varchar(128) NO '' dateline int(11) NO 0 Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `md5` (`md5`) - KEY `dateline` (`dateline`) TABLE: wp_litespeed_url [3 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO url varchar(500) NO cache_tags varchar(1000) NO '' Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `url` (`url`(191)) - KEY `cache_tags` (`cache_tags`(191)) TABLE: wp_litespeed_url_file [8 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO url_id bigint(20) NO vary varchar(32) NO '' filename varchar(32) NO '' type tinyint(4) NO mobile tinyint(4) NO webp tinyint(4) NO expired int(11) NO 0 Keys: - PRIMARY KEY (`id`) - KEY `filename` (`filename`) - KEY `type` (`type`) - KEY `url_id_2` (`url_id`,`vary`,`type`) - KEY `filename_2` (`filename`,`expired`) - KEY `url_id` (`url_id`,`expired`) TABLE: wp_mailpoet_automation_run_logs [11 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO automation_run_id int(11) unsigned NO step_id varchar(191) NO step_type varchar(255) NO step_key varchar(255) NO status varchar(191) NO started_at timestamp YES NULL updated_at timestamp NO current_timestamp() run_number int(11) NO data longtext NO error longtext YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `automation_run_id_step_id` (`automation_run_id`,`step_id`) - KEY `status` (`status`) - KEY `step_id` (`step_id`) TABLE: wp_mailpoet_automation_run_subjects [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO automation_run_id int(11) unsigned NO key varchar(191) YES NULL args longtext YES NULL hash varchar(191) YES NULL Keys: - PRIMARY KEY (`id`) - KEY `automation_run_id` (`automation_run_id`) - KEY `hash` (`hash`) TABLE: wp_mailpoet_automation_runs [8 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO automation_id int(11) unsigned NO version_id int(11) unsigned NO trigger_key varchar(191) NO status varchar(191) NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() next_step_id varchar(191) YES NULL Keys: - PRIMARY KEY (`id`) - KEY `automation_id` (`automation_id`,`status`) - KEY `created_at` (`created_at`) - KEY `version_id` (`version_id`) - KEY `status` (`status`) - KEY `next_step_id` (`next_step_id`) TABLE: wp_mailpoet_automation_triggers [2 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra automation_id int(11) unsigned NO trigger_key varchar(191) NO Keys: - PRIMARY KEY (`automation_id`,`trigger_key`) TABLE: wp_mailpoet_automation_versions [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO automation_id int(11) unsigned NO steps longtext YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - KEY `automation_id` (`automation_id`) TABLE: wp_mailpoet_automations [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(191) NO author bigint(20) NO status varchar(191) NO meta longtext YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() activated_at timestamp YES NULL deleted_at timestamp YES NULL Keys: - PRIMARY KEY (`id`) TABLE: wp_mailpoet_custom_fields [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(90) NO type varchar(90) NO params longtext NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `name` (`name`) TABLE: wp_mailpoet_dynamic_segment_filters [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO segment_id int(11) unsigned NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() filter_data longblob YES NULL filter_type varchar(255) YES NULL action varchar(255) YES NULL Keys: - PRIMARY KEY (`id`) - KEY `segment_id` (`segment_id`) TABLE: wp_mailpoet_feature_flags [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(100) NO value tinyint(1) YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `name` (`name`) TABLE: wp_mailpoet_forms [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(90) NO status varchar(20) NO 'enabled' body longtext YES NULL settings longtext YES NULL styles longtext YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() deleted_at timestamp YES NULL Keys: - PRIMARY KEY (`id`) TABLE: wp_mailpoet_log [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO name varchar(255) YES NULL level int(11) YES NULL message longtext YES NULL created_at timestamp YES current_timestamp() raw_message longtext YES NULL context longtext YES NULL Keys: - PRIMARY KEY (`id`) TABLE: wp_mailpoet_migrations [6 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(191) NO started_at timestamp NO current_timestamp() completed_at timestamp YES NULL retries int(11) unsigned NO 0 error text YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `name` (`name`) TABLE: wp_mailpoet_newsletter_links [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO queue_id int(11) unsigned NO url varchar(2083) NO hash varchar(20) NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - KEY `newsletter_id` (`newsletter_id`) - KEY `queue_id` (`queue_id`) - KEY `url` (`url`(100)) TABLE: wp_mailpoet_newsletter_option [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO option_field_id int(11) unsigned NO value longtext YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `newsletter_id_option_field_id` (`newsletter_id`,`option_field_id`) TABLE: wp_mailpoet_newsletter_option_fields [5 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(90) NO newsletter_type varchar(90) NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `name_newsletter_type` (`newsletter_type`,`name`) TABLE: wp_mailpoet_newsletter_posts [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO post_id int(11) unsigned NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - KEY `newsletter_id` (`newsletter_id`) TABLE: wp_mailpoet_newsletter_segment [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO segment_id int(11) unsigned NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `newsletter_segment` (`newsletter_id`,`segment_id`) TABLE: wp_mailpoet_newsletter_templates [11 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) YES 0 name varchar(250) NO categories varchar(250) NO '[]' description varchar(255) NO '' body longtext YES NULL thumbnail longtext YES NULL thumbnail_data longtext YES NULL readonly tinyint(1) YES 0 created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) TABLE: wp_mailpoet_newsletters [19 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO hash varchar(150) YES NULL parent_id int(11) unsigned YES NULL subject varchar(250) NO '' type varchar(150) NO 'standard' sender_address varchar(150) NO '' sender_name varchar(150) NO '' status varchar(20) NO 'draft' reply_to_address varchar(150) NO '' reply_to_name varchar(150) NO '' preheader varchar(250) NO '' body longtext YES NULL sent_at timestamp YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() deleted_at timestamp YES NULL unsubscribe_token char(15) YES NULL ga_campaign varchar(250) NO '' wp_post_id int(11) YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `unsubscribe_token` (`unsubscribe_token`) - KEY `type_status` (`type`,`status`) - KEY `wp_post_id` (`wp_post_id`) TABLE: wp_mailpoet_scheduled_task_subscribers [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra task_id int(11) unsigned NO subscriber_id int(11) unsigned NO processed int(1) NO failed smallint(1) NO 0 error text YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`task_id`,`subscriber_id`) - KEY `subscriber_id` (`subscriber_id`) TABLE: wp_mailpoet_scheduled_tasks [13 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO type varchar(90) YES NULL status varchar(12) YES NULL priority mediumint(9) NO 0 scheduled_at timestamp YES NULL processed_at timestamp YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() deleted_at timestamp YES NULL in_progress int(1) YES NULL reschedule_count int(11) NO 0 meta longtext YES NULL cancelled_at timestamp YES NULL Keys: - PRIMARY KEY (`id`) - KEY `type` (`type`) - KEY `status` (`status`) TABLE: wp_mailpoet_segments [10 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(90) NO type varchar(90) NO 'default' description varchar(250) NO '' created_at timestamp YES NULL updated_at timestamp NO current_timestamp() deleted_at timestamp YES NULL average_engagement_score float unsigned YES NULL average_engagement_score_updated_at timestamp YES NULL display_in_manage_subscription_page tinyint(1) NO 0 Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `name` (`name`) - KEY `average_engagement_score_updated_at` (`average_engagement_score_updated_at`) TABLE: wp_mailpoet_sending_queues [13 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO task_id int(11) unsigned NO newsletter_id int(11) unsigned YES NULL newsletter_rendered_body longtext YES NULL newsletter_rendered_subject varchar(250) YES NULL subscribers longtext YES NULL count_total int(11) unsigned NO 0 count_processed int(11) unsigned NO 0 count_to_process int(11) unsigned NO 0 meta longtext YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() deleted_at timestamp YES NULL Keys: - PRIMARY KEY (`id`) - KEY `task_id` (`task_id`) - KEY `newsletter_id` (`newsletter_id`) TABLE: wp_mailpoet_settings [5 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(50) NO value longtext YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `name` (`name`) TABLE: wp_mailpoet_statistics_bounces [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO subscriber_id int(11) unsigned NO queue_id int(11) unsigned NO created_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) TABLE: wp_mailpoet_statistics_clicks [10 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO subscriber_id int(11) unsigned NO queue_id int(11) unsigned NO link_id int(11) unsigned NO user_agent_id int(11) unsigned YES NULL user_agent_type tinyint(1) NO 0 count int(11) unsigned NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - KEY `newsletter_id_subscriber_id_user_agent_type` (`newsletter_id`,`subscriber_id`,`user_agent_type`) - KEY `queue_id` (`queue_id`) - KEY `subscriber_id` (`subscriber_id`) TABLE: wp_mailpoet_statistics_forms [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO form_id int(11) unsigned NO subscriber_id int(11) unsigned NO created_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `form_subscriber` (`form_id`,`subscriber_id`) TABLE: wp_mailpoet_statistics_newsletters [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO subscriber_id int(11) unsigned NO queue_id int(11) unsigned NO sent_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - KEY `newsletter_id` (`newsletter_id`) - KEY `subscriber_id` (`subscriber_id`) TABLE: wp_mailpoet_statistics_opens [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO subscriber_id int(11) unsigned NO queue_id int(11) unsigned NO user_agent_id int(11) unsigned YES NULL user_agent_type tinyint(1) NO 0 created_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - KEY `newsletter_id_subscriber_id_user_agent_type` (`newsletter_id`,`subscriber_id`,`user_agent_type`) - KEY `queue_id` (`queue_id`) - KEY `subscriber_id` (`subscriber_id`) - KEY `created_at` (`created_at`) - KEY `subscriber_id_created_at` (`subscriber_id`,`created_at`) TABLE: wp_mailpoet_statistics_unsubscribes [8 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned YES NULL subscriber_id int(11) unsigned NO queue_id int(11) unsigned YES NULL created_at timestamp NO current_timestamp() source varchar(255) YES 'unknown' meta varchar(255) YES NULL method varchar(40) NO 'unknown' Keys: - PRIMARY KEY (`id`) - KEY `newsletter_id_subscriber_id` (`newsletter_id`,`subscriber_id`) - KEY `queue_id` (`queue_id`) - KEY `subscriber_id` (`subscriber_id`) TABLE: wp_mailpoet_statistics_woocommerce_purchases [11 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned YES NULL subscriber_id int(11) unsigned NO queue_id int(11) unsigned NO click_id int(11) unsigned NO order_id bigint(20) unsigned NO order_currency char(3) NO order_price_total float NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() status varchar(40) NO 'unknown' Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `click_id_order_id` (`click_id`,`order_id`) - KEY `newsletter_id` (`newsletter_id`) - KEY `queue_id` (`queue_id`) - KEY `subscriber_id` (`subscriber_id`) - KEY `status` (`status`) TABLE: wp_mailpoet_stats_notifications [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO newsletter_id int(11) unsigned NO task_id int(11) unsigned NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `newsletter_id_task_id` (`newsletter_id`,`task_id`) - KEY `task_id` (`task_id`) TABLE: wp_mailpoet_subscriber_custom_field [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO subscriber_id int(11) unsigned NO custom_field_id int(11) unsigned NO value text NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `subscriber_id_custom_field_id` (`subscriber_id`,`custom_field_id`) TABLE: wp_mailpoet_subscriber_ips [2 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra ip varchar(45) NO created_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`created_at`,`ip`) - KEY `ip` (`ip`) TABLE: wp_mailpoet_subscriber_segment [6 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO subscriber_id int(11) unsigned NO segment_id int(11) unsigned NO status varchar(12) NO 'subscribed' created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `subscriber_segment` (`subscriber_id`,`segment_id`) - KEY `segment_id` (`segment_id`) TABLE: wp_mailpoet_subscriber_tag [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO subscriber_id int(11) unsigned NO tag_id int(11) unsigned NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `subscriber_tag` (`subscriber_id`,`tag_id`) - KEY `tag_id` (`tag_id`) TABLE: wp_mailpoet_subscribers [29 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO wp_user_id bigint(20) YES NULL is_woocommerce_user int(1) NO 0 first_name varchar(255) NO '' last_name varchar(255) NO '' email varchar(150) NO status varchar(12) NO 'unconfirmed' subscribed_ip varchar(45) YES NULL confirmed_ip varchar(45) YES NULL confirmed_at timestamp YES NULL last_subscribed_at timestamp YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() deleted_at timestamp YES NULL unconfirmed_data longtext YES NULL source enum('form','imported','administrator','api','wordpress_user','woocommerce_user','woocommerce_checkout','unknown') YES 'unknown' count_confirmations int(11) unsigned NO 0 unsubscribe_token char(15) YES NULL link_token char(32) YES NULL engagement_score float unsigned YES NULL engagement_score_updated_at timestamp YES NULL last_engagement_at timestamp YES NULL woocommerce_synced_at timestamp YES NULL email_count int(11) unsigned NO 0 last_sending_at timestamp YES NULL last_open_at timestamp YES NULL last_click_at timestamp YES NULL last_purchase_at timestamp YES NULL last_page_view_at timestamp YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `email` (`email`) - UNIQUE KEY `unsubscribe_token` (`unsubscribe_token`) - KEY `wp_user_id` (`wp_user_id`) - KEY `updated_at` (`updated_at`) - KEY `status_deleted_at` (`status`,`deleted_at`) - KEY `last_subscribed_at` (`last_subscribed_at`) - KEY `engagement_score_updated_at` (`engagement_score_updated_at`) - KEY `link_token` (`link_token`) - KEY `first_name` (`first_name`(10)) - KEY `last_name` (`last_name`(10)) - KEY `last_sending_at` (`last_sending_at`) - KEY `last_open_at` (`last_open_at`) - KEY `last_click_at` (`last_click_at`) - KEY `last_purchase_at` (`last_purchase_at`) - KEY `last_page_view_at` (`last_page_view_at`) TABLE: wp_mailpoet_tags [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO name varchar(191) NO description text NO '' created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `name` (`name`) TABLE: wp_mailpoet_user_agents [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO hash varchar(32) NO user_agent text NO created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `hash` (`hash`) TABLE: wp_mailpoet_user_flags [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO user_id bigint(20) NO name varchar(50) NO value varchar(255) YES NULL created_at timestamp YES NULL updated_at timestamp NO current_timestamp() Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `user_id_name` (`user_id`,`name`) TABLE: wp_monsterinsights_cache [6 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra cache_id bigint(20) unsigned NO cache_key varchar(255) NO cache_value longtext NO cache_group varchar(64) YES 'default' expires_at datetime NO created_at datetime NO current_timestamp() Keys: - PRIMARY KEY (`cache_id`) - UNIQUE KEY `cache_key_group` (`cache_key`,`cache_group`) - KEY `expires_at` (`expires_at`) - KEY `created_at` (`created_at`) TABLE: wp_rank_math_internal_links [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO url varchar(255) NO post_id bigint(20) unsigned NO target_post_id bigint(20) unsigned NO type varchar(8) NO Keys: - PRIMARY KEY (`id`) - KEY `link_direction` (`post_id`,`type`) TABLE: wp_rank_math_internal_meta [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra object_id bigint(20) unsigned NO internal_link_count int(10) unsigned YES 0 external_link_count int(10) unsigned YES 0 incoming_link_count int(10) unsigned YES 0 Keys: - PRIMARY KEY (`object_id`) TABLE: wp_sgpb_subscribers [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(12) NO firstName varchar(255) YES NULL lastName varchar(255) YES NULL email varchar(255) YES NULL subscriptionType int(12) YES NULL cDate date YES NULL status varchar(255) YES NULL unsubscribed int(11) YES 0 unsubscribe_token varchar(255) YES NULL Keys: - PRIMARY KEY (`id`) TABLE: wp_sgpb_subscription_error_log [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(12) NO firstName varchar(255) YES NULL popupType varchar(255) YES NULL email varchar(255) YES NULL date varchar(255) YES NULL Keys: - PRIMARY KEY (`id`) TABLE: wp_social_users [7 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra social_users_id int(11) NO ID int(11) NO type varchar(20) NO identifier varchar(100) NO register_date datetime YES NULL login_date datetime YES NULL link_date datetime YES NULL Keys: - PRIMARY KEY (`social_users_id`) - KEY `ID` (`ID`,`type`) - KEY `identifier` (`identifier`) TABLE: wp_userfeedback_email_survey_responses [14 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO survey_id bigint(20) NO session_token varchar(64) NO rating_value varchar(50) NO utm_campaign varchar(255) YES NULL utm_medium varchar(255) YES NULL utm_source varchar(255) YES NULL utm_term varchar(255) YES NULL utm_content varchar(255) YES NULL comment text YES NULL comment_submitted_at timestamp YES NULL user_agent varchar(255) YES NULL referrer varchar(500) YES NULL created_at timestamp NO Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `session_token` (`session_token`) - KEY `survey_id` (`survey_id`) - KEY `rating_value` (`rating_value`) - KEY `utm_campaign` (`utm_campaign`) - KEY `utm_medium` (`utm_medium`) - KEY `utm_source` (`utm_source`) - KEY `created_at` (`created_at`) - CONSTRAINT `wp_userfeedback_email_survey_responses_ibfk_1` FOREIGN KEY (`survey_id`) REFERENCES `wp_userfeedback_email_surveys` (`id`) ON DELETE CASCADE TABLE: wp_userfeedback_email_surveys [15 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO slug varchar(255) NO secret_key varchar(64) NO title varchar(255) NO link_text varchar(255) YES 'How would you rate this email?' status enum('publish','draft','trash') YES 'draft' rating_options longtext YES NULL thank_you_message varchar(255) YES 'Thank You For Your Feedback' collect_feedback tinyint(1) YES 1 feedback_field_label varchar(255) YES 'Why did you rate us this way' feedback_response varchar(255) YES 'Thank You For Your Feedback! We appreciate it!' settings text YES NULL notifications text YES NULL created_at timestamp NO updated_at timestamp YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `slug` (`slug`) - UNIQUE KEY `secret_key` (`secret_key`) TABLE: wp_userfeedback_heatmap_recordings [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO heatmap_id bigint(20) NO heatmap_data longtext NO created_at timestamp NO current_timestamp() interaction_type varchar(100) NO Keys: - PRIMARY KEY (`id`) TABLE: wp_userfeedback_heatmaps [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO page_id bigint(20) NO created_at timestamp NO current_timestamp() status enum('publish','draft','trash') YES 'publish' Keys: - PRIMARY KEY (`id`) TABLE: wp_userfeedback_post_ratings [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO post_id bigint(20) unsigned NO rating tinyint(3) unsigned NO user_id bigint(20) unsigned YES NULL created_at datetime NO Keys: - PRIMARY KEY (`id`) - KEY `post_id` (`post_id`) TABLE: wp_userfeedback_survey_responses [10 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO survey_id bigint(20) NO answers longtext YES NULL page_submitted text YES NULL user_ip varchar(256) YES NULL user_browser varchar(128) YES NULL user_os varchar(128) YES NULL user_device varchar(64) YES NULL status enum('publish','draft','trash') YES 'publish' submitted_at timestamp NO Keys: - PRIMARY KEY (`id`) - KEY `survey_id` (`survey_id`) - CONSTRAINT `wp_userfeedback_survey_responses_ibfk_1` FOREIGN KEY (`survey_id`) REFERENCES `wp_userfeedback_surveys` (`id`) ON DELETE CASCADE TABLE: wp_userfeedback_surveys [10 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO title varchar(128) YES NULL status enum('publish','draft','trash') YES 'draft' type varchar(100) YES NULL questions longtext YES NULL impressions bigint(20) NO 0 settings text YES NULL notifications text YES NULL publish_at timestamp YES NULL created_at timestamp NO Keys: - PRIMARY KEY (`id`) TABLE: wp_wc_admin_note_actions [9 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra action_id bigint(20) unsigned NO note_id bigint(20) unsigned NO name varchar(255) NO label varchar(255) NO query longtext NO status varchar(255) NO actioned_text varchar(255) NO nonce_action varchar(255) YES NULL nonce_name varchar(255) YES NULL Keys: - PRIMARY KEY (`action_id`) - KEY `note_id` (`note_id`) TABLE: wp_wc_admin_notes [17 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra note_id bigint(20) unsigned NO name varchar(255) NO type varchar(20) NO locale varchar(20) NO title longtext NO content longtext NO content_data longtext YES NULL status varchar(200) NO source varchar(200) NO date_created datetime NO '0000-00-00 00:00:00' date_reminder datetime YES NULL is_snoozable tinyint(1) NO 0 layout varchar(20) NO '' image varchar(200) YES NULL is_deleted tinyint(1) NO 0 is_read tinyint(1) NO 0 icon varchar(200) NO 'info' Keys: - PRIMARY KEY (`note_id`) TABLE: wp_wc_customer_lookup [12 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra customer_id bigint(20) unsigned NO user_id bigint(20) unsigned YES NULL username varchar(60) NO '' first_name varchar(255) NO last_name varchar(255) NO email varchar(100) YES NULL date_last_active timestamp YES NULL date_registered timestamp YES NULL country char(2) NO '' postcode varchar(20) NO '' city varchar(100) NO '' state varchar(100) NO '' Keys: - PRIMARY KEY (`customer_id`) - UNIQUE KEY `user_id` (`user_id`) - KEY `email` (`email`) TABLE: wp_wc_download_log [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra download_log_id bigint(20) unsigned NO timestamp datetime NO permission_id bigint(20) unsigned NO user_id bigint(20) unsigned YES NULL user_ip_address varchar(100) YES '' Keys: - PRIMARY KEY (`download_log_id`) - KEY `permission_id` (`permission_id`) - KEY `timestamp` (`timestamp`) TABLE: wp_wc_order_addresses [14 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO order_id bigint(20) unsigned NO address_type varchar(20) YES NULL first_name text YES NULL last_name text YES NULL company text YES NULL address_1 text YES NULL address_2 text YES NULL city text YES NULL state text YES NULL postcode text YES NULL country text YES NULL email varchar(320) YES NULL phone varchar(100) YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `address_type_order_id` (`address_type`,`order_id`) - KEY `order_id` (`order_id`) - KEY `email` (`email`(191)) - KEY `phone` (`phone`) TABLE: wp_wc_order_coupon_lookup [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra order_id bigint(20) unsigned NO coupon_id bigint(20) NO date_created datetime NO '0000-00-00 00:00:00' discount_amount double NO 0 Keys: - PRIMARY KEY (`order_id`,`coupon_id`) - KEY `coupon_id` (`coupon_id`) - KEY `date_created` (`date_created`) TABLE: wp_wc_order_operational_data [18 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO order_id bigint(20) unsigned YES NULL created_via varchar(100) YES NULL woocommerce_version varchar(20) YES NULL prices_include_tax tinyint(1) YES NULL coupon_usages_are_counted tinyint(1) YES NULL download_permission_granted tinyint(1) YES NULL cart_hash varchar(100) YES NULL new_order_email_sent tinyint(1) YES NULL order_key varchar(100) YES NULL order_stock_reduced tinyint(1) YES NULL date_paid_gmt datetime YES NULL date_completed_gmt datetime YES NULL shipping_tax_amount decimal(26,8) YES NULL shipping_total_amount decimal(26,8) YES NULL discount_tax_amount decimal(26,8) YES NULL discount_total_amount decimal(26,8) YES NULL recorded_sales tinyint(1) YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `order_id` (`order_id`) - KEY `order_key` (`order_key`) TABLE: wp_wc_order_product_lookup [13 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra order_item_id bigint(20) unsigned NO order_id bigint(20) unsigned NO product_id bigint(20) unsigned NO variation_id bigint(20) unsigned NO customer_id bigint(20) unsigned YES NULL date_created datetime NO '0000-00-00 00:00:00' product_qty int(11) NO product_net_revenue double NO 0 product_gross_revenue double NO 0 coupon_amount double NO 0 tax_amount double NO 0 shipping_amount double NO 0 shipping_tax_amount double NO 0 Keys: - PRIMARY KEY (`order_item_id`,`order_id`) - KEY `order_id` (`order_id`) - KEY `product_id` (`product_id`) - KEY `customer_id` (`customer_id`) - KEY `date_created` (`date_created`) - KEY `customer_product_date` (`customer_id`,`product_id`,`date_created`) TABLE: wp_wc_order_stats [14 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra order_id bigint(20) unsigned NO parent_id bigint(20) unsigned NO 0 date_created datetime NO '0000-00-00 00:00:00' date_created_gmt datetime NO '0000-00-00 00:00:00' date_paid datetime YES '0000-00-00 00:00:00' date_completed datetime YES '0000-00-00 00:00:00' num_items_sold int(11) NO 0 total_sales double NO 0 tax_total double NO 0 shipping_total double NO 0 net_total double NO 0 returning_customer tinyint(1) YES NULL status varchar(20) NO customer_id bigint(20) unsigned NO Keys: - PRIMARY KEY (`order_id`) - KEY `date_created` (`date_created`) - KEY `customer_id` (`customer_id`) - KEY `status` (`status`) - KEY `idx_date_paid_status_parent` (`date_paid`,`status`,`parent_id`) TABLE: wp_wc_order_tax_lookup [6 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra order_id bigint(20) unsigned NO tax_rate_id bigint(20) unsigned NO date_created datetime NO '0000-00-00 00:00:00' shipping_tax double NO 0 order_tax double NO 0 total_tax double NO 0 Keys: - PRIMARY KEY (`order_id`,`tax_rate_id`) - KEY `tax_rate_id` (`tax_rate_id`) - KEY `date_created` (`date_created`) TABLE: wp_wc_orders [17 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO status varchar(20) YES NULL currency varchar(10) YES NULL type varchar(20) YES NULL tax_amount decimal(26,8) YES NULL total_amount decimal(26,8) YES NULL customer_id bigint(20) unsigned YES NULL billing_email varchar(320) YES NULL date_created_gmt datetime YES NULL date_updated_gmt datetime YES NULL parent_order_id bigint(20) unsigned YES NULL payment_method varchar(100) YES NULL payment_method_title text YES NULL transaction_id varchar(100) YES NULL ip_address varchar(100) YES NULL user_agent text YES NULL customer_note text YES NULL Keys: - PRIMARY KEY (`id`) - KEY `status` (`status`) - KEY `date_created` (`date_created_gmt`) - KEY `customer_id_billing_email` (`customer_id`,`billing_email`(171)) - KEY `billing_email` (`billing_email`(191)) - KEY `type_status_date` (`type`,`status`,`date_created_gmt`) - KEY `parent_order_id` (`parent_order_id`) - KEY `date_updated` (`date_updated_gmt`) - KEY `customer_id_status` (`customer_id`,`status`) - KEY `transaction_id` (`transaction_id`(20)) TABLE: wp_wc_orders_meta [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO order_id bigint(20) unsigned NO meta_key varchar(255) NO meta_value text YES NULL Keys: - PRIMARY KEY (`order_id`,`meta_key`,`id`) - UNIQUE KEY `id` (`id`) - KEY `order_id_meta_key_meta_value` (`order_id`,`meta_key`(100),`meta_value`(82)) - KEY `meta_key_value` (`meta_key`(50),`meta_value`(20)) TABLE: wp_wc_product_attributes_lookup [6 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra product_id bigint(20) NO product_or_parent_id bigint(20) NO taxonomy varchar(32) NO term_id bigint(20) NO is_variation_attribute tinyint(1) NO in_stock tinyint(1) NO Keys: - PRIMARY KEY (`product_or_parent_id`,`term_id`,`product_id`,`taxonomy`) - KEY `is_variation_attribute_term_id` (`is_variation_attribute`,`term_id`) - KEY `product_id` (`product_id`) - KEY `taxonomy_term_id_in_stock_product_or_parent_id` (`taxonomy`,`term_id`,`in_stock`,`product_or_parent_id`) TABLE: wp_wc_product_download_directories [3 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra url_id bigint(20) unsigned NO url varchar(256) NO enabled tinyint(1) NO 0 Keys: - PRIMARY KEY (`url_id`) - KEY `url` (`url`(191)) TABLE: wp_wc_rate_limits [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra rate_limit_id bigint(20) unsigned NO rate_limit_key varchar(200) NO rate_limit_expiry bigint(20) unsigned NO rate_limit_remaining smallint(10) NO 0 Keys: - PRIMARY KEY (`rate_limit_id`) - UNIQUE KEY `rate_limit_key` (`rate_limit_key`(191)) TABLE: wp_wc_webhooks [14 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra webhook_id bigint(20) unsigned NO status varchar(200) NO name text NO user_id bigint(20) unsigned NO delivery_url text NO secret text NO topic varchar(200) NO date_created datetime NO '0000-00-00 00:00:00' date_created_gmt datetime NO '0000-00-00 00:00:00' date_modified datetime NO '0000-00-00 00:00:00' date_modified_gmt datetime NO '0000-00-00 00:00:00' api_version smallint(4) NO failure_count smallint(10) NO 0 pending_delivery tinyint(1) NO 0 Keys: - PRIMARY KEY (`webhook_id`) - KEY `user_id` (`user_id`) TABLE: wp_woocommerce_api_keys [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra key_id bigint(20) unsigned NO user_id bigint(20) unsigned NO description varchar(200) YES NULL permissions varchar(10) NO consumer_key char(64) NO consumer_secret char(43) NO nonces longtext YES NULL truncated_key char(7) NO last_access datetime YES NULL Keys: - PRIMARY KEY (`key_id`) - KEY `consumer_key` (`consumer_key`) - KEY `consumer_secret` (`consumer_secret`) TABLE: wp_woocommerce_attribute_taxonomies [6 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra attribute_id bigint(20) unsigned NO attribute_name varchar(200) NO attribute_label varchar(200) YES NULL attribute_type varchar(20) NO attribute_orderby varchar(20) NO attribute_public int(1) NO 1 Keys: - PRIMARY KEY (`attribute_id`) - KEY `attribute_name` (`attribute_name`(20)) TABLE: wp_woocommerce_downloadable_product_permissions [11 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra permission_id bigint(20) unsigned NO download_id varchar(36) NO product_id bigint(20) unsigned NO order_id bigint(20) unsigned NO 0 order_key varchar(200) NO user_email varchar(200) NO user_id bigint(20) unsigned YES NULL downloads_remaining varchar(9) YES NULL access_granted datetime NO '0000-00-00 00:00:00' access_expires datetime YES NULL download_count bigint(20) unsigned NO 0 Keys: - PRIMARY KEY (`permission_id`) - KEY `download_order_key_product` (`product_id`,`order_id`,`order_key`(16),`download_id`) - KEY `download_order_product` (`download_id`,`order_id`,`product_id`) - KEY `order_id` (`order_id`) - KEY `user_order_remaining_expires` (`user_id`,`order_id`,`downloads_remaining`,`access_expires`) - KEY `idx_user_email` (`user_email`(100)) TABLE: wp_woocommerce_log [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra log_id bigint(20) unsigned NO timestamp datetime NO level smallint(4) NO source varchar(200) NO message longtext NO context longtext YES NULL Keys: - PRIMARY KEY (`log_id`) - KEY `level` (`level`) TABLE: wp_woocommerce_order_items [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra order_item_id bigint(20) unsigned NO order_item_name text NO order_item_type varchar(200) NO '' order_id bigint(20) unsigned NO Keys: - PRIMARY KEY (`order_item_id`) - KEY `order_id` (`order_id`) TABLE: wp_woocommerce_payment_tokens [6 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra token_id bigint(20) unsigned NO gateway_id varchar(200) NO token text NO user_id bigint(20) unsigned NO 0 type varchar(200) NO is_default tinyint(1) NO 0 Keys: - PRIMARY KEY (`token_id`) - KEY `user_id` (`user_id`) TABLE: wp_woocommerce_sessions [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra session_id bigint(20) unsigned NO session_key char(32) NO session_value longtext NO session_expiry bigint(20) unsigned NO Keys: - PRIMARY KEY (`session_id`) - UNIQUE KEY `session_key` (`session_key`) - KEY `session_expiry` (`session_expiry`) TABLE: wp_woocommerce_shipping_zone_locations [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra location_id bigint(20) unsigned NO zone_id bigint(20) unsigned NO location_code varchar(200) NO location_type varchar(40) NO Keys: - PRIMARY KEY (`location_id`) - KEY `zone_id` (`zone_id`) - KEY `location_type_code` (`location_type`(10),`location_code`(20)) TABLE: wp_woocommerce_shipping_zone_methods [5 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra zone_id bigint(20) unsigned NO instance_id bigint(20) unsigned NO method_id varchar(200) NO method_order bigint(20) unsigned NO is_enabled tinyint(1) NO 1 Keys: - PRIMARY KEY (`instance_id`) - KEY `zone_id` (`zone_id`) - KEY `method_id` (`method_id`(20)) TABLE: wp_woocommerce_shipping_zones [3 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra zone_id bigint(20) unsigned NO zone_name varchar(200) NO zone_order bigint(20) unsigned NO Keys: - PRIMARY KEY (`zone_id`) - KEY `zone_order_id` (`zone_order`,`zone_id`) TABLE: wp_woocommerce_tax_rate_locations [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra location_id bigint(20) unsigned NO location_code varchar(200) NO tax_rate_id bigint(20) unsigned NO location_type varchar(40) NO Keys: - PRIMARY KEY (`location_id`) - KEY `tax_rate_id` (`tax_rate_id`) - KEY `location_type_code` (`location_type`(10),`location_code`(20)) TABLE: wp_woocommerce_tax_rates [10 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra tax_rate_id bigint(20) unsigned NO tax_rate_country varchar(2) NO '' tax_rate_state varchar(200) NO '' tax_rate varchar(8) NO '' tax_rate_name varchar(200) NO '' tax_rate_priority bigint(20) unsigned NO tax_rate_compound int(1) NO 0 tax_rate_shipping int(1) NO 1 tax_rate_order bigint(20) unsigned NO tax_rate_class varchar(200) NO '' Keys: - PRIMARY KEY (`tax_rate_id`) - KEY `tax_rate_country` (`tax_rate_country`) - KEY `tax_rate_state` (`tax_rate_state`(2)) - KEY `tax_rate_class` (`tax_rate_class`(10)) - KEY `tax_rate_priority` (`tax_rate_priority`) TABLE: wp_wpforms_analytics_forms [5 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra form_id bigint(20) unsigned NO period_date date NO views int(10) unsigned NO 0 unique_sessions int(10) unsigned NO 0 submissions int(10) unsigned NO 0 Keys: - PRIMARY KEY (`form_id`,`period_date`) TABLE: wp_wpforms_analytics_snapshots [9 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO form_id bigint(20) unsigned NO session_id varchar(64) NO trigger_type tinyint(3) unsigned NO page_number tinyint(3) unsigned YES NULL form_visible tinyint(1) unsigned NO 0 payload longtext NO occurred_at datetime NO processed tinyint(1) unsigned NO 0 Keys: - PRIMARY KEY (`id`) - KEY `idx_unprocessed` (`processed`,`occurred_at`) - KEY `idx_session` (`session_id`,`form_id`,`trigger_type`) - KEY `idx_form_date` (`form_id`,`processed`,`form_visible`,`occurred_at`) TABLE: wp_wpforms_logs [8 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO title varchar(255) NO message longtext NO types varchar(255) NO create_at datetime NO form_id bigint(20) YES NULL entry_id bigint(20) YES NULL user_id bigint(20) YES NULL Keys: - PRIMARY KEY (`id`) TABLE: wp_wpforms_payment_meta [4 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO payment_id bigint(20) NO meta_key varchar(255) YES NULL meta_value longtext YES NULL Keys: - PRIMARY KEY (`id`) - KEY `payment_id` (`payment_id`) - KEY `meta_key` (`meta_key`(191)) - KEY `meta_value` (`meta_value`(191)) TABLE: wp_wpforms_payments [19 columns] (empty) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO form_id bigint(20) NO status varchar(10) NO '' subtotal_amount decimal(26,8) NO 0.00000000 discount_amount decimal(26,8) NO 0.00000000 total_amount decimal(26,8) NO 0.00000000 currency varchar(3) NO '' entry_id bigint(20) NO 0 gateway varchar(20) NO '' type varchar(12) NO '' mode varchar(4) NO '' transaction_id varchar(40) NO '' customer_id varchar(40) NO '' subscription_id varchar(40) NO '' subscription_status varchar(10) NO '' title varchar(255) NO '' date_created_gmt datetime NO date_updated_gmt datetime NO is_published tinyint(1) NO 1 Keys: - PRIMARY KEY (`id`) - KEY `form_id` (`form_id`) - KEY `status` (`status`(8)) - KEY `total_amount` (`total_amount`) - KEY `type` (`type`(8)) - KEY `transaction_id` (`transaction_id`(32)) - KEY `customer_id` (`customer_id`(32)) - KEY `subscription_id` (`subscription_id`(32)) - KEY `subscription_status` (`subscription_status`(8)) - KEY `title` (`title`(64)) TABLE: wp_wpforms_tasks_meta [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) NO action varchar(255) NO data longtext NO date datetime NO Keys: - PRIMARY KEY (`id`) TABLE: wp_yoast_indexable [53 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO permalink longtext YES NULL permalink_hash varchar(40) YES NULL object_id bigint(20) YES NULL object_type varchar(32) NO object_sub_type varchar(32) YES NULL author_id bigint(20) YES NULL post_parent bigint(20) YES NULL title text YES NULL description mediumtext YES NULL breadcrumb_title text YES NULL post_status varchar(20) YES NULL is_public tinyint(1) YES NULL is_protected tinyint(1) YES 0 has_public_posts tinyint(1) YES NULL number_of_pages int(11) unsigned YES NULL canonical longtext YES NULL primary_focus_keyword varchar(191) YES NULL primary_focus_keyword_score int(3) YES NULL readability_score int(3) YES NULL is_cornerstone tinyint(1) YES 0 is_robots_noindex tinyint(1) YES 0 is_robots_nofollow tinyint(1) YES 0 is_robots_noarchive tinyint(1) YES 0 is_robots_noimageindex tinyint(1) YES 0 is_robots_nosnippet tinyint(1) YES 0 twitter_title text YES NULL twitter_image longtext YES NULL twitter_description longtext YES NULL twitter_image_id varchar(191) YES NULL twitter_image_source text YES NULL open_graph_title text YES NULL open_graph_description longtext YES NULL open_graph_image longtext YES NULL open_graph_image_id varchar(191) YES NULL open_graph_image_source text YES NULL open_graph_image_meta mediumtext YES NULL link_count int(11) YES NULL incoming_link_count int(11) YES NULL prominent_words_version int(11) unsigned YES NULL created_at datetime YES NULL updated_at timestamp NO current_timestamp() blog_id bigint(20) NO 1 language varchar(32) YES NULL region varchar(32) YES NULL schema_page_type varchar(64) YES NULL schema_article_type varchar(64) YES NULL has_ancestors tinyint(1) YES 0 estimated_reading_time_minutes int(11) YES NULL version int(11) YES 1 object_last_modified datetime YES NULL object_published_at datetime YES NULL inclusive_language_score int(3) YES NULL Keys: - PRIMARY KEY (`id`) - KEY `object_type_and_sub_type` (`object_type`,`object_sub_type`) - KEY `object_id_and_type` (`object_id`,`object_type`) - KEY `permalink_hash_and_object_type` (`permalink_hash`,`object_type`) - KEY `subpages` (`post_parent`,`object_type`,`post_status`,`object_id`) - KEY `prominent_words` (`prominent_words_version`,`object_type`,`object_sub_type`,`post_status`) - KEY `published_sitemap_index` (`object_published_at`,`is_robots_noindex`,`object_type`,`object_sub_type`) TABLE: wp_yoast_indexable_hierarchy [4 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra indexable_id int(11) unsigned NO ancestor_id int(11) unsigned NO depth int(11) unsigned YES NULL blog_id bigint(20) NO 1 Keys: - PRIMARY KEY (`indexable_id`,`ancestor_id`) - KEY `indexable_id` (`indexable_id`) - KEY `ancestor_id` (`ancestor_id`) - KEY `depth` (`depth`) TABLE: wp_yoast_migrations [2 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO version varchar(191) YES NULL Keys: - PRIMARY KEY (`id`) - UNIQUE KEY `wp_yoast_migrations_version` (`version`) TABLE: wp_yoast_primary_term [7 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id int(11) unsigned NO post_id bigint(20) YES NULL term_id bigint(20) YES NULL taxonomy varchar(32) NO created_at datetime YES NULL updated_at timestamp NO current_timestamp() blog_id bigint(20) NO 1 Keys: - PRIMARY KEY (`id`) - KEY `post_taxonomy` (`post_id`,`taxonomy`) - KEY `post_term` (`post_id`,`term_id`) TABLE: wp_yoast_seo_links [12 columns] (DATA) ------------------------------------------------------------------------------------------ Column Type Null Default Extra id bigint(20) unsigned NO url varchar(255) YES NULL post_id bigint(20) unsigned YES NULL target_post_id bigint(20) unsigned YES NULL type varchar(8) YES NULL indexable_id int(11) unsigned YES NULL target_indexable_id int(11) unsigned YES NULL height int(11) unsigned YES NULL width int(11) unsigned YES NULL size int(11) unsigned YES NULL language varchar(32) YES NULL region varchar(32) YES NULL Keys: - PRIMARY KEY (`id`) - KEY `link_direction` (`post_id`,`type`) - KEY `indexable_link_direction` (`indexable_id`,`type`)