wp_freshrank_articles
StaticStores freshrank articles data created by this plugin.
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled FreshRank – Instant Feedback for Better Content, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_freshrank_articles`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from FreshRank – Instant Feedback for Better Content