{"slug":"link-diagnostic-and-insights","name":"Link Diagnostics – Broken Links, Redirects, and Link Insights","description":"Complete link health monitoring for WordPress. Find broken links, fix redirect chains, optimize internal linking, and improve SEO performance.","author":"swiftspeed","active_installs":30,"version":"1.0.3","wp_org_url":"https://wordpress.org/plugins/link-diagnostic-and-insights/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"lhcfwp_fixes","full_table_name":"wp_lhcfwp_fixes","description":"Stores lhcfwp fixes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_fixes` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `old_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `new_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `anchor_text` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `fixed_by` bigint unsigned NOT NULL,\\n  `fixed_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `post_id` (`post_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"lhcfwp_ignored","full_table_name":"wp_lhcfwp_ignored","description":"Stores lhcfwp ignored data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_ignored` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `issue_id` bigint unsigned NOT NULL,\\n  `scan_id` bigint unsigned NOT NULL,\\n  `post_id` bigint unsigned NOT NULL,\\n  `current_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `reason` text COLLATE utf8mb4_unicode_520_ci,\\n  `ignored_by` bigint unsigned NOT NULL,\\n  `ignored_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `issue_id` (`issue_id`),\\n  KEY `scan_id` (`scan_id`),\\n  KEY `post_id` (`post_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"lhcfwp_intelligence","full_table_name":"wp_lhcfwp_intelligence","description":"Stores lhcfwp intelligence data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_intelligence` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `scan_id` bigint unsigned NOT NULL,\\n  `metric_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `metric_key` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `metric_value` bigint NOT NULL,\\n  `post_id` bigint unsigned DEFAULT NULL,\\n  `post_title` text COLLATE utf8mb4_unicode_520_ci,\\n  `additional_data` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `scan_id` (`scan_id`),\\n  KEY `metric_type` (`metric_type`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"lhcfwp_issues","full_table_name":"wp_lhcfwp_issues","description":"Stores lhcfwp issues data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_issues` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `scan_id` bigint unsigned NOT NULL,\\n  `scan_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `post_id` bigint unsigned NOT NULL,\\n  `post_title` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `post_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `anchor_text` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `current_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `destination_url` text COLLATE utf8mb4_unicode_520_ci,\\n  `redirect_type` varchar(10) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `status_code` int DEFAULT NULL,\\n  `issue_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `is_fixable` tinyint(1) DEFAULT '0',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'pending',\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `scan_id` (`scan_id`),\\n  KEY `scan_type` (`scan_type`),\\n  KEY `post_id` (`post_id`),\\n  KEY `issue_type` (`issue_type`),\\n  KEY `status` (`status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"lhcfwp_redirects","full_table_name":"wp_lhcfwp_redirects","description":"Stores lhcfwp redirects data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_redirects` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `source_urls` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `destination_url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `redirect_type` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '301',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',\\n  `match_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'exact',\\n  `scheduled_activation` datetime DEFAULT NULL,\\n  `scheduled_deactivation` datetime DEFAULT NULL,\\n  `category` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_by` bigint unsigned NOT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `status` (`status`),\\n  KEY `match_type` (`match_type`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"lhcfwp_scan_state","full_table_name":"wp_lhcfwp_scan_state","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_scan_state` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `scan_id` bigint unsigned NOT NULL,\\n  `scan_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `config` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `posts` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `total` int NOT NULL,\\n  `current` int NOT NULL DEFAULT '0',\\n  `processed` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `issues_found` int NOT NULL DEFAULT '0',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'running',\\n  `started_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `completed_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `scan_id` (`scan_id`),\\n  KEY `status` (`status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"lhcfwp_scans","full_table_name":"wp_lhcfwp_scans","description":"Stores lhcfwp scans data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_scans` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `scan_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `scan_config` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `scan_config_hash` varchar(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `total_posts` int NOT NULL DEFAULT '0',\\n  `issues_found` int NOT NULL DEFAULT '0',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'running',\\n  `started_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  `completed_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `scan_type` (`scan_type`),\\n  KEY `status` (`status`),\\n  KEY `scan_config_hash` (`scan_config_hash`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"lhcfwp_settings","full_table_name":"wp_lhcfwp_settings","description":"Stores lhcfwp settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_lhcfwp_settings` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `setting_key` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `setting_value` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `setting_key` (`setting_key`)\\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":8}