wp_seopress_content_analysis

Verified

Stores seopress content analysis data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_seopress_content_analysis` (\n  `id` bigint NOT NULL AUTO_INCREMENT,\n  `post_id` bigint DEFAULT NULL,\n  `title` longtext COLLATE utf8mb4_unicode_520_ci,\n  `description` longtext COLLATE utf8mb4_unicode_520_ci,\n  `og_title` longtext COLLATE utf8mb4_unicode_520_ci,\n  `og_description` longtext COLLATE utf8mb4_unicode_520_ci,\n  `og_image` longtext COLLATE utf8mb4_unicode_520_ci,\n  `og_url` longtext COLLATE utf8mb4_unicode_520_ci,\n  `og_site_name` longtext COLLATE utf8mb4_unicode_520_ci,\n  `twitter_title` longtext COLLATE utf8mb4_unicode_520_ci,\n  `twitter_description` longtext COLLATE utf8mb4_unicode_520_ci,\n  `twitter_image` longtext COLLATE utf8mb4_unicode_520_ci,\n  `twitter_image_src` longtext COLLATE utf8mb4_unicode_520_ci,\n  `canonical` longtext COLLATE utf8mb4_unicode_520_ci,\n  `h1` longtext COLLATE utf8mb4_unicode_520_ci,\n  `h2` longtext COLLATE utf8mb4_unicode_520_ci,\n  `h3` longtext COLLATE utf8mb4_unicode_520_ci,\n  `images` longtext COLLATE utf8mb4_unicode_520_ci,\n  `meta_robots` longtext COLLATE utf8mb4_unicode_520_ci,\n  `meta_google` longtext COLLATE utf8mb4_unicode_520_ci,\n  `links_no_follow` longtext COLLATE utf8mb4_unicode_520_ci,\n  `outbound_links` longtext COLLATE utf8mb4_unicode_520_ci,\n  `internal_links` longtext COLLATE utf8mb4_unicode_520_ci,\n  `json_schemas` longtext COLLATE utf8mb4_unicode_520_ci,\n  `keywords` text COLLATE utf8mb4_unicode_520_ci,\n  `permalink` text COLLATE utf8mb4_unicode_520_ci,\n  `score` text COLLATE utf8mb4_unicode_520_ci,\n  `analysis_date` datetime DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `idx_post_id` (`post_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

If you have uninstalled SEOPress – On-site SEO & Analytics, 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_seopress_content_analysis`;

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

Other tables from SEOPress – On-site SEO & Analytics

wp_qss