{"table_name":"f12_prof_crawl_results","full_table_name":"wp_f12_prof_crawl_results","description":"Stores f12 prof crawl results data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_f12_prof_crawl_results ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, url varchar(2048) NOT NULL, device enum('desktop','mobile') NOT NULL DEFAULT 'desktop', ttfb float DEFAULT NULL, load_time float DEFAULT NULL, html_size int unsigned DEFAULT NULL, total_requests int unsigned DEFAULT NULL, css_count int unsigned DEFAULT NULL, css_size int unsigned DEFAULT NULL, js_count int unsigned DEFAULT NULL, js_size int unsigned DEFAULT NULL, image_count int unsigned DEFAULT NULL, image_size int unsigned DEFAULT NULL, external_requests int unsigned DEFAULT NULL, redirect_count int unsigned DEFAULT NULL, response_headers longtext DEFAULT NULL, assets_data longtext DEFAULT NULL, score float DEFAULT NULL, status enum('pending','crawling','done','error') NOT NULL DEFAULT 'pending', error_message text DEFAULT NULL, crawl_batch varchar(36) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_url (url(191)), KEY idx_device (device), KEY idx_batch (crawl_batch), KEY idx_created (created_at) ) {$charset}; CREATE TABLE wp_f12_prof_recommendations ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, crawl_batch varchar(36) NOT NULL, priority enum('critical','high','medium','low','optional') NOT NULL DEFAULT 'medium', category varchar(50) NOT NULL, title varchar(500) NOT NULL, problem longtext NOT NULL, impact_score float DEFAULT NULL, impact_load_time varchar(50) DEFAULT NULL, impact_bandwidth varchar(50) DEFAULT NULL, affected_items longtext DEFAULT NULL, steps longtext DEFAULT NULL, tool_action varchar(100) DEFAULT NULL, manual_alternative longtext DEFAULT NULL, status enum('open','in_progress','done','ignored') NOT NULL DEFAULT 'open', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_batch (crawl_batch), KEY idx_priority (priority), KEY idx_category (category), KEY idx_status (status) ) {$charset}; CREATE TABLE wp_f12_prof_history ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, device enum('desktop','mobile') NOT NULL DEFAULT 'desktop', score_total float NOT NULL, score_server float DEFAULT NULL, score_loadtime float DEFAULT NULL, score_assets float DEFAULT NULL, score_images float DEFAULT NULL, score_cache float DEFAULT NULL, score_database float DEFAULT NULL, urls_crawled int unsigned DEFAULT NULL, issues_found int unsigned DEFAULT NULL, crawl_batch varchar(36) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_device (device), KEY idx_created (created_at) ) {$charset}; CREATE TABLE wp_f12_prof_asset_rules ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, handle varchar(200) NOT NULL, asset_type enum('css','js') NOT NULL, action enum('disable','async','defer') NOT NULL DEFAULT 'disable', scope varchar(50) NOT NULL DEFAULT 'global', scope_value varchar(500) DEFAULT NULL, source_plugin varchar(200) DEFAULT NULL, is_protected tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_handle (handle), KEY idx_type (asset_type), KEY idx_scope (scope) ) {$charset}; CREATE TABLE wp_f12_prof_pagespeed_results ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, url varchar(2048) NOT NULL, device enum('desktop','mobile') NOT NULL DEFAULT 'desktop', score_performance float DEFAULT NULL, score_accessibility float DEFAULT NULL, score_best_practices float DEFAULT NULL, score_seo float DEFAULT NULL, lcp_ms float DEFAULT NULL, fcp_ms float DEFAULT NULL, cls float DEFAULT NULL, tbt_ms float DEFAULT NULL, si_ms float DEFAULT NULL, tti_ms float DEFAULT NULL, field_lcp_ms int DEFAULT NULL, field_cls float DEFAULT NULL, field_inp_ms int DEFAULT NULL, field_fcp_ms int DEFAULT NULL, field_ttfb_ms int DEFAULT NULL, field_overall varchar(10) DEFAULT NULL, lighthouse_version varchar(20) DEFAULT NULL, runtime_error varchar(255) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_url_device (url(191), device), KEY idx_created (created_at) ) {$charset}; CREATE TABLE wp_f12_prof_image_queue ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, attachment_id bigint(20) unsigned NOT NULL, original_path varchar(500) NOT NULL, original_size int unsigned NOT NULL DEFAULT 0, optimized_size int unsigned DEFAULT NULL, format_from varchar(10) NOT NULL DEFAULT '', format_to varchar(10) NOT NULL DEFAULT 'webp', quality int unsigned NOT NULL DEFAULT 80, status varchar(20) NOT NULL DEFAULT 'pending', error_message text DEFAULT NULL, batch_id varchar(36) DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_status (status), KEY idx_batch (batch_id) ) {$charset}; CREATE TABLE wp_f12_prof_asset_scan_results ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, url varchar(2048) NOT NULL, assets_json longtext NOT NULL, asset_count int unsigned DEFAULT 0, css_count int unsigned DEFAULT 0, js_count int unsigned DEFAULT 0, scan_batch varchar(36) DEFAULT NULL, scanned_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_url (url(191)), KEY idx_batch (scan_batch) ) {$charset}; CREATE TABLE wp_f12_prof_critical_css ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, template_key varchar(200) NOT NULL, template_label varchar(200) NOT NULL DEFAULT '', css_content longtext DEFAULT NULL, source_url varchar(2048) DEFAULT NULL, generated_at datetime DEFAULT NULL, status varchar(20) NOT NULL DEFAULT 'pending', error_message text DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY idx_template (template_key) ) {$charset}; CREATE TABLE wp_f12_prof_optimizer_runs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, run_id varchar(36) NOT NULL, status varchar(20) NOT NULL DEFAULT 'pending', phase tinyint unsigned NOT NULL DEFAULT 0, phase_detail varchar(255) DEFAULT NULL, settings_before longtext DEFAULT NULL, asset_rules_before longtext DEFAULT NULL, asset_suggestions_before longtext DEFAULT NULL, htaccess_before longtext DEFAULT NULL, critical_css_before longtext DEFAULT NULL, settings_applied longtext DEFAULT NULL, asset_rules_applied longtext DEFAULT NULL, recommendations_before_json longtext DEFAULT NULL, recommendations_resolved longtext DEFAULT NULL, score_before longtext DEFAULT NULL, score_after longtext DEFAULT NULL, recommendations_before int unsigned DEFAULT 0, recommendations_after int unsigned DEFAULT 0, started_at datetime DEFAULT NULL, completed_at datetime DEFAULT NULL, error_message text DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY idx_run_id (run_id), KEY idx_status (status), KEY idx_created (created_at) ) {$charset}; \"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql);","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"url","type":"varchar(2048)","nullable":false,"primary_key":false},{"name":"device","type":"enum('desktop','mobile')","nullable":false,"primary_key":false},{"name":"ttfb","type":"float","nullable":true,"primary_key":false},{"name":"load_time","type":"float","nullable":true,"primary_key":false},{"name":"html_size","type":"int unsigned","nullable":true,"primary_key":false},{"name":"total_requests","type":"int unsigned","nullable":true,"primary_key":false},{"name":"css_count","type":"int unsigned","nullable":true,"primary_key":false},{"name":"css_size","type":"int unsigned","nullable":true,"primary_key":false},{"name":"js_count","type":"int unsigned","nullable":true,"primary_key":false},{"name":"js_size","type":"int unsigned","nullable":true,"primary_key":false},{"name":"image_count","type":"int unsigned","nullable":true,"primary_key":false},{"name":"image_size","type":"int unsigned","nullable":true,"primary_key":false},{"name":"external_requests","type":"int unsigned","nullable":true,"primary_key":false},{"name":"redirect_count","type":"int unsigned","nullable":true,"primary_key":false},{"name":"response_headers","type":"longtext","nullable":true,"primary_key":false},{"name":"assets_data","type":"longtext","nullable":true,"primary_key":false},{"name":"score","type":"float","nullable":true,"primary_key":false},{"name":"status","type":"enum('pending','crawling','done','error')","nullable":false,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"crawl_batch","type":"varchar(36)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"crawl_batch","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"priority","type":"enum('critical','high','medium','low','optional')","nullable":false,"primary_key":false},{"name":"category","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"problem","type":"longtext","nullable":false,"primary_key":false},{"name":"impact_score","type":"float","nullable":true,"primary_key":false},{"name":"impact_load_time","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"impact_bandwidth","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"affected_items","type":"longtext","nullable":true,"primary_key":false},{"name":"steps","type":"longtext","nullable":true,"primary_key":false},{"name":"tool_action","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"manual_alternative","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"enum('open','in_progress','done','ignored')","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"device","type":"enum('desktop','mobile')","nullable":false,"primary_key":false},{"name":"score_total","type":"float","nullable":false,"primary_key":false},{"name":"score_server","type":"float","nullable":true,"primary_key":false},{"name":"score_loadtime","type":"float","nullable":true,"primary_key":false},{"name":"score_assets","type":"float","nullable":true,"primary_key":false},{"name":"score_images","type":"float","nullable":true,"primary_key":false},{"name":"score_cache","type":"float","nullable":true,"primary_key":false},{"name":"score_database","type":"float","nullable":true,"primary_key":false},{"name":"urls_crawled","type":"int unsigned","nullable":true,"primary_key":false},{"name":"issues_found","type":"int unsigned","nullable":true,"primary_key":false},{"name":"crawl_batch","type":"varchar(36)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"handle","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"asset_type","type":"enum('css','js')","nullable":false,"primary_key":false},{"name":"action","type":"enum('disable','async','defer')","nullable":false,"primary_key":false},{"name":"scope","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"scope_value","type":"varchar(500)","nullable":true,"primary_key":false},{"name":"source_plugin","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"is_protected","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"url","type":"varchar(2048)","nullable":false,"primary_key":false},{"name":"device","type":"enum('desktop','mobile')","nullable":false,"primary_key":false},{"name":"score_performance","type":"float","nullable":true,"primary_key":false},{"name":"score_accessibility","type":"float","nullable":true,"primary_key":false},{"name":"score_best_practices","type":"float","nullable":true,"primary_key":false},{"name":"score_seo","type":"float","nullable":true,"primary_key":false},{"name":"lcp_ms","type":"float","nullable":true,"primary_key":false},{"name":"fcp_ms","type":"float","nullable":true,"primary_key":false},{"name":"cls","type":"float","nullable":true,"primary_key":false},{"name":"tbt_ms","type":"float","nullable":true,"primary_key":false},{"name":"si_ms","type":"float","nullable":true,"primary_key":false},{"name":"tti_ms","type":"float","nullable":true,"primary_key":false},{"name":"field_lcp_ms","type":"int","nullable":true,"primary_key":false},{"name":"field_cls","type":"float","nullable":true,"primary_key":false},{"name":"field_inp_ms","type":"int","nullable":true,"primary_key":false},{"name":"field_fcp_ms","type":"int","nullable":true,"primary_key":false},{"name":"field_ttfb_ms","type":"int","nullable":true,"primary_key":false},{"name":"field_overall","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"lighthouse_version","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"runtime_error","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"attachment_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"original_path","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"original_size","type":"int unsigned","nullable":false,"primary_key":false},{"name":"optimized_size","type":"int unsigned","nullable":true,"primary_key":false},{"name":"format_from","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"format_to","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"quality","type":"int unsigned","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"batch_id","type":"varchar(36)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"url","type":"varchar(2048)","nullable":false,"primary_key":false},{"name":"assets_json","type":"longtext","nullable":false,"primary_key":false},{"name":"asset_count","type":"int unsigned","nullable":true,"primary_key":false},{"name":"css_count","type":"int unsigned","nullable":true,"primary_key":false},{"name":"js_count","type":"int unsigned","nullable":true,"primary_key":false},{"name":"scan_batch","type":"varchar(36)","nullable":true,"primary_key":false},{"name":"scanned_at","type":"datetime","nullable":false,"primary_key":false},{"name":"template_key","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"template_label","type":"varchar(200)","nullable":false,"primary_key":false},{"name":"css_content","type":"longtext","nullable":true,"primary_key":false},{"name":"source_url","type":"varchar(2048)","nullable":true,"primary_key":false},{"name":"generated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"run_id","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"phase","type":"tinyint unsigned","nullable":false,"primary_key":false},{"name":"phase_detail","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"settings_before","type":"longtext","nullable":true,"primary_key":false},{"name":"asset_rules_before","type":"longtext","nullable":true,"primary_key":false},{"name":"asset_suggestions_before","type":"longtext","nullable":true,"primary_key":false},{"name":"htaccess_before","type":"longtext","nullable":true,"primary_key":false},{"name":"critical_css_before","type":"longtext","nullable":true,"primary_key":false},{"name":"settings_applied","type":"longtext","nullable":true,"primary_key":false},{"name":"asset_rules_applied","type":"longtext","nullable":true,"primary_key":false},{"name":"recommendations_before_json","type":"longtext","nullable":true,"primary_key":false},{"name":"recommendations_resolved","type":"longtext","nullable":true,"primary_key":false},{"name":"score_before","type":"longtext","nullable":true,"primary_key":false},{"name":"score_after","type":"longtext","nullable":true,"primary_key":false},{"name":"recommendations_before","type":"int unsigned","nullable":true,"primary_key":false},{"name":"recommendations_after","type":"int unsigned","nullable":true,"primary_key":false},{"name":"started_at","type":"datetime","nullable":true,"primary_key":false},{"name":"completed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"f12-profiler","name":"F12 Profiler","active_installs":500,"version":"2.1.0","wp_org_url":"https://wordpress.org/plugins/f12-profiler/"}}