wp_semantic_suggested_links
StaticStores semantic suggested links data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| analysis_id | bigint(20) UNSIGNED | NO |
| post_id | bigint(20) UNSIGNED | NO |
| anchor_text | text | YES |
| target_page_title | text | YES |
| target_url | text | YES |
| confidence_score | float | YES |
| relevance_reasoning | text | YES |
| content_relationship | text | YES |
| intent_classification | varchar(50) | YES |
| approval_status | varchar(20) | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_semantic_suggested_links ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, analysis_id bigint(20) UNSIGNED NOT NULL, post_id bigint(20) UNSIGNED NOT NULL, anchor_text text, target_page_title text, target_url text, confidence_score float DEFAULT 0, relevance_reasoning text, content_relationship text, intent_classification varchar(50), approval_status varchar(20) NOT NULL DEFAULT 'pending', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY analysis_id (analysis_id), KEY post_id (post_id) ) $charset;" );
Safe to delete?
If you have uninstalled AI Data Layer – AI SEO & AI Search Optimization: llms.txt, MCP Server, Schema (AEO/GEO), 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_semantic_suggested_links`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI Data Layer – AI SEO & AI Search Optimization: llms.txt, MCP Server, Schema (AEO/GEO)