wp_kc_us_links

Column Definitions

CREATE TABLE Statement

CREATE TABLE `wp_kc_us_links` ( `id` int(10) NOT NULL AUTO_INCREMENT, `slug` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `url` text DEFAULT NULL, `description` text DEFAULT NULL, `nofollow` tinyint(1) DEFAULT 0, `track_me` tinyint(1) DEFAULT 1, `sponsored` tinyint(1) DEFAULT 0, `params_forwarding` tinyint(1) DEFAULT 0, `params_structure` varchar(255) DEFAULT NULL, `redirect_type` varchar(255) DEFAULT '307', `status` tinyint(1) DEFAULT 1, `type` varchar(30) DEFAULT 'direct', `type_id` int(11) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `expires_at` datetime DEFAULT NULL, `total_clicks` int(11) DEFAULT null, `unique_clicks` int(11) DEFAULT null, `cpt_id` int(11) DEFAULT 0, `cpt_type` varchar(20) DEFAULT NULL, `broken_link_status` varchar(20) DEFAULT NULL, `rules` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `created_by_id` int(11) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `updated_by_id` int(11) DEFAULT NULL, `og_title` text DEFAULT NULL, `og_description` text DEFAULT NULL, `og_image` text DEFAULT NULL, `og_site_name` varchar(255) DEFAULT NULL, `og_last_fetched` datetime DEFAULT NULL, PRIMARY KEY (id), KEY cpt_id (cpt_id), KEY type_id (type_id), KEY status (status), KEY nofollow (nofollow), KEY track_me (track_me), KEY sponsored (sponsored), KEY params_forwarding (params_forwarding), KEY redirect_type (redirect_type(191)), KEY slug (slug(191)), KEY expires_at (expires_at), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; "; return $tables; } /** * Get Clicks table schema * * @since 1.0.1 * * @param string $collate * * @return string * */ public static function get_101_schema( $collate = '' ) { global $wpdb; $table = " CREATE TABLE `wp_kc_us_clicks` ( `id` int(11) NOT NULL AUTO_INCREMENT, `link_id` int(11) DEFAULT NULL, `uri` varchar(255) DEFAULT NULL, `host` varchar(255) DEFAULT NULL, `referer` varchar(255) DEFAULT NULL, `is_first_click` tinyint(1) DEFAULT 0, `is_robot` tinyint(1) DEFAULT 0, `user_agent` text DEFAULT NULL, `os` varchar(255) DEFAULT NULL, `device` varchar(255) DEFAULT NULL, `browser_type` varchar(255) DEFAULT NULL, `browser_version` varchar(255) DEFAULT NULL, `visitor_id` varchar(25) default NULL, `country` varchar(50) DEFAULT NULL, `ip` varchar(255) DEFAULT NULL, `created_at` DATETIME NOT NULL, PRIMARY KEY (id), KEY link_id (link_id), KEY ip (ip(191)), KEY browser_type (browser_type(191)), KEY browser_version (browser_version(191)), KEY os (os(191)), KEY device (device(191)), KEY country (country(50)), KEY referer (referer(191)), KEY host (host(191)), KEY uri (uri(191)), KEY is_robot (is_robot), KEY is_first_click (is_first_click), KEY visitor_id (visitor_id) ) $collate; "; return $table; } /** * @since 1.1.3 * * @param string $collate * * @return string * */ public static function get_113_schema( $collate = '' ) { global $wpdb; return " CREATE TABLE `wp_kc_us_groups` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `created_by_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_by_id` int(11) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; CREATE TABLE `wp_kc_us_links_groups` ( `id` int(10) NOT NULL AUTO_INCREMENT, `link_id` int(10) NOT NULL, `group_id` int(10) NOT NULL, `created_by_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY link_id (link_id), KEY group_id (group_id), KEY created_by_id (created_by_id), KEY created_at (created_at) ) $collate; "; } /** * @since 1.3.8 * * @param string $collate * * @return string * */ public static function get_138_schema( $collate = '' ) { global $wpdb; return " CREATE TABLE `wp_kc_us_domains` ( `id` int(10) NOT NULL AUTO_INCREMENT, `host` varchar(255) DEFAULT NULL, `status` tinyint(1) DEFAULT 1, `created_by_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_by_id` int(11) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; "; } /** * Table Schema. * * @since 1.5.12 * * @param string $collate * * @return string * */ public static function get_1512_schema( $collate = '' ) { global $wpdb; return " CREATE TABLE `wp_kc_us_utm_presets` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `utm_id` varchar(255) DEFAULT NULL, `utm_source` varchar(255) DEFAULT NULL, `utm_medium` varchar(255) DEFAULT NULL, `utm_campaign` varchar(255) DEFAULT NULL, `utm_term` varchar(255) DEFAULT NULL, `utm_content` varchar(255) DEFAULT NULL, `created_by_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_by_id` int(11) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; "; } /** * Create Tracking Pixel Table. * * @since 1.8.9 * * @param string $collate * * @return string * */ public static function get_189_schema( $collate = '' ) { global $wpdb; return " CREATE TABLE `wp_kc_us_tracking_pixels` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(80) DEFAULT NULL, `type` varchar(40) DEFAULT NULL, `pixel_id` varchar(191) DEFAULT NULL, `head_code` text DEFAULT NULL, `body_code` text DEFAULT NULL, `created_by_id` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_by_id` int(11) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; "; } /** * Create Clicks Rotations Table. * * @since 1.8.9 * * @param string $collate * * @return string * */ public static function get_191_schema( $collate = '' ) { global $wpdb; return " CREATE TABLE `wp_kc_us_clicks_rotations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `click_id` int(11) NOT NULL, `link_id` int(11) NOT NULL, `url` text NOT NULL, PRIMARY KEY (id), KEY click_id (click_id), KEY link_id (link_id) ) $collate; "; } /** * Create Api Keys Table. * * @since 1.9.5 * * @param string $collate * * @return string * */ public static function get_195_schema( $collate = '' ) { global $wpdb; return " CREATE TABLE `wp_kc_us_api_keys` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `description` varchar(200) DEFAULT NULL, `permissions` varchar(10) NOT NULL, `consumer_key` char(64) NOT NULL, `consumer_secret` char(43) NOT NULL, `truncated_key` char(7) NOT NULL, `last_access` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `created_by_id` int(11) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `updated_by_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `consumer_key` (`consumer_key`), KEY `consumer_secret` (`consumer_secret`), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; "; } /** * Get files to create * * @since 1.5.1 * @return array[] * */ public static function get_files() { // If we need to create more files/ dirs in the future // use following code // return array_merge(self::get_151_files(), self::get_152_files(), self::get_153_files());

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_kc_us_links`;

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

Other tables from URL Shortify – Simple and Easy URL Shortener