{"table_name":"freshrank_articles","full_table_name":"wp_freshrank_articles","description":"Stores freshrank articles data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_freshrank_articles` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `priority_score` decimal(10,2) DEFAULT '0.00',\\n  `display_order` int DEFAULT '0',\\n  `ctr_current` decimal(5,4) DEFAULT '0.0000',\\n  `ctr_previous` decimal(5,4) DEFAULT '0.0000',\\n  `ctr_decline` decimal(5,4) DEFAULT '0.0000',\\n  `position_current` decimal(5,2) DEFAULT '0.00',\\n  `position_previous` decimal(5,2) DEFAULT '0.00',\\n  `position_drop` decimal(5,2) DEFAULT '0.00',\\n  `impressions_current` bigint DEFAULT '0',\\n  `impressions_previous` bigint DEFAULT '0',\\n  `clicks_current` bigint DEFAULT '0',\\n  `clicks_previous` bigint DEFAULT '0',\\n  `traffic_potential` decimal(10,2) DEFAULT '0.00',\\n  `content_age_score` decimal(5,2) DEFAULT '0.00',\\n  `last_gsc_update` datetime DEFAULT NULL,\\n  `analysis_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `draft_status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'pending',\\n  `custom_order` int DEFAULT '0',\\n  `excluded` tinyint(1) DEFAULT '0',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `post_id` (`post_id`),\\n  KEY `priority_score` (`priority_score`),\\n  KEY `display_order` (`display_order`),\\n  KEY `analysis_status` (`analysis_status`),\\n  KEY `draft_status` (`draft_status`),\\n  KEY `custom_order` (`custom_order`),\\n  KEY `status_priority` (`analysis_status`,`priority_score`)\\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/"}}