🗄️What WP Table Is This?
Home / Easy Content Linker Lite / wp_ecl_lite_links

wp_ecl_lite_links

Static

Stores ecl lite links data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_ecl_lite_links` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `source_post_id` bigint unsigned NOT NULL,\n  `target_post_id` bigint unsigned NOT NULL,\n  `anchor_text` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\n  `similarity_score` float DEFAULT '0',\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'active',\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 `unique_link` (`source_post_id`,`target_post_id`,`anchor_text`(100)),\n  KEY `source_post_id` (`source_post_id`),\n  KEY `target_post_id` (`target_post_id`),\n  KEY `status` (`status`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

If you have uninstalled Easy Content Linker Lite, 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_ecl_lite_links`;

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

Other tables from Easy Content Linker Lite