wp_freshrank_articles

Static

Stores 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