🗄️What WP Table Is This?
Home / FreshRank – Instant Feedback for Better Content / wp_freshrank_analysis

wp_freshrank_analysis

Static

Stores freshrank analysis data created by this plugin.

CREATE TABLE Statement

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

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_analysis`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from FreshRank – Instant Feedback for Better Content