🗄️What WP Table Is This?
Home / URL Shortify – Simple and Easy URL Shortener / wp_kc_us_clicks

wp_kc_us_clicks

Static

Stores kc us clicks data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_kc_us_clicks` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `link_id` int DEFAULT NULL,\n  `uri` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `host` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `referer` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `is_first_click` tinyint(1) DEFAULT '0',\n  `is_robot` tinyint(1) DEFAULT '0',\n  `user_agent` text COLLATE utf8mb4_unicode_520_ci,\n  `os` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `device` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `browser_type` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `browser_version` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `visitor_id` varchar(25) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `country` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `ip` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\n  `created_at` datetime NOT NULL,\n  PRIMARY KEY (`id`),\n  KEY `link_id` (`link_id`),\n  KEY `ip` (`ip`(191)),\n  KEY `browser_type` (`browser_type`(191)),\n  KEY `browser_version` (`browser_version`(191)),\n  KEY `os` (`os`(191)),\n  KEY `device` (`device`(191)),\n  KEY `country` (`country`),\n  KEY `referer` (`referer`(191)),\n  KEY `host` (`host`(191)),\n  KEY `uri` (`uri`(191)),\n  KEY `is_robot` (`is_robot`),\n  KEY `is_first_click` (`is_first_click`),\n  KEY `visitor_id` (`visitor_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci

Safe to delete?

If you have uninstalled URL Shortify – Simple and Easy URL Shortener, 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_kc_us_clicks`;

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

Other tables from URL Shortify – Simple and Easy URL Shortener