{"table_name":"kc_us_clicks","full_table_name":"wp_kc_us_clicks","description":"Stores kc us clicks data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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","columns":[],"plugin":{"slug":"url-shortify","name":"URL Shortify – Simple and Easy URL Shortener","active_installs":10000,"version":"2.4.1","wp_org_url":"https://wordpress.org/plugins/url-shortify/"}}