{"table_name":"freshrank_analysis","full_table_name":"wp_freshrank_analysis","description":"Stores freshrank analysis data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_freshrank_analysis` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `analysis_data` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `issues_count` int DEFAULT '0',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `error_message` text COLLATE utf8mb4_unicode_520_ci,\\n  `processing_time` decimal(8,2) DEFAULT NULL,\\n  `tokens_used` int DEFAULT '0',\\n  `prompt_tokens` int DEFAULT '0',\\n  `completion_tokens` int DEFAULT '0',\\n  `model_used` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `dismissed_items` text COLLATE utf8mb4_unicode_520_ci COMMENT 'JSON array of dismissed issue identifiers',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `post_id` (`post_id`),\\n  KEY `status` (`status`),\\n  KEY `created_at` (`created_at`),\\n  KEY `post_status_date` (`post_id`,`status`,`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"freshrank-ai","name":"FreshRank – Instant Feedback for Better Content","active_installs":10,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/freshrank-ai/"}}