{"slug":"url-shortify","name":"URL Shortify – Simple and Easy URL Shortener","description":"URL Shortify helps you beautify, manage, share & cloak any links on or off your WordPress website. Create links using your domain name!","author":"KaizenCoders","active_installs":10000,"version":"2.4.1","wp_org_url":"https://wordpress.org/plugins/url-shortify/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"kc_us_api_keys","full_table_name":"wp_kc_us_api_keys","description":"Stores kc us api keys data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_api_keys` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL,\\n  `description` varchar(200) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `permissions` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `consumer_key` char(64) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `consumer_secret` char(43) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `truncated_key` char(7) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `last_access` datetime DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `created_by_id` int DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  `updated_by_id` int DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `consumer_key` (`consumer_key`),\\n  KEY `consumer_secret` (`consumer_secret`),\\n  KEY `created_at` (`created_at`),\\n  KEY `updated_at` (`updated_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_auto_link_keywords","full_table_name":"wp_kc_us_auto_link_keywords","description":"Stores kc us auto link keywords data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_auto_link_keywords` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `keyword` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `link_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `post_types` text COLLATE utf8mb4_unicode_520_ci,\\n  `open_new_tab` tinyint(1) DEFAULT '0',\\n  `nofollow` tinyint(1) DEFAULT '0',\\n  `case_sensitive` tinyint(1) DEFAULT '0',\\n  `status` tinyint(1) DEFAULT '1',\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `keyword` (`keyword`(191)),\\n  KEY `link_id` (`link_id`),\\n  KEY `status` (`status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"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","columns":[],"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"},{"table_name":"kc_us_clicks_rotations","full_table_name":"wp_kc_us_clicks_rotations","description":"Stores kc us clicks rotations data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_clicks_rotations` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `click_id` int NOT NULL,\\n  `link_id` int NOT NULL,\\n  `url` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `click_id` (`click_id`),\\n  KEY `link_id` (`link_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_domains","full_table_name":"wp_kc_us_domains","description":"Stores kc us domains data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_domains` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `host` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `status` tinyint(1) DEFAULT '1',\\n  `created_by_id` int DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_by_id` int DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `created_at` (`created_at`),\\n  KEY `updated_at` (`updated_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_favorites_links","full_table_name":"wp_kc_us_favorites_links","description":"Stores kc us favorites links data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_favorites_links` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned NOT NULL,\\n  `link_id` bigint unsigned NOT NULL,\\n  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `user_link` (`user_id`,`link_id`),\\n  KEY `user_id` (`user_id`),\\n  KEY `link_id` (`link_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_groups","full_table_name":"wp_kc_us_groups","description":"Stores kc us groups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_groups` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `description` text COLLATE utf8mb4_unicode_520_ci,\\n  `created_by_id` int DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_by_id` int DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `created_at` (`created_at`),\\n  KEY `updated_at` (`updated_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_linkmeta","full_table_name":"wp_kc_us_linkmeta","description":"Stores kc us linkmeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"kc_us_links","full_table_name":"wp_kc_us_links","description":"Stores kc us links data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(10)","nullable":false,"primary_key":true},{"name":"slug","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"url","type":"text","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"nofollow","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"track_me","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"sponsored","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"params_forwarding","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"params_structure","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"redirect_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(30)","nullable":true,"primary_key":false},{"name":"type_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"password","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false},{"name":"total_clicks","type":"int(11)","nullable":true,"primary_key":false},{"name":"unique_clicks","type":"int(11)","nullable":true,"primary_key":false},{"name":"cpt_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"cpt_type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"broken_link_status","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"rules","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"og_title","type":"text","nullable":true,"primary_key":false},{"name":"og_description","type":"text","nullable":true,"primary_key":false},{"name":"og_image","type":"text","nullable":true,"primary_key":false},{"name":"og_site_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"og_last_fetched","type":"datetime","nullable":true,"primary_key":false},{"name":"link_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"uri","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"host","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"referer","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"is_first_click","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_robot","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"user_agent","type":"text","nullable":true,"primary_key":false},{"name":"os","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"device","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"browser_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"browser_version","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"visitor_id","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"country","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ip","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"link_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"group_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"host","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"utm_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_source","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_medium","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_campaign","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_term","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"utm_content","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"name","type":"varchar(80)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(40)","nullable":true,"primary_key":false},{"name":"pixel_id","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"head_code","type":"text","nullable":true,"primary_key":false},{"name":"body_code","type":"text","nullable":true,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"click_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"link_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"url","type":"text","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"description","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"permissions","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"consumer_key","type":"char(64)","nullable":false,"primary_key":false},{"name":"consumer_secret","type":"char(43)","nullable":false,"primary_key":false},{"name":"truncated_key","type":"char(7)","nullable":false,"primary_key":false},{"name":"last_access","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"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());"},{"table_name":"kc_us_links_groups","full_table_name":"wp_kc_us_links_groups","description":"Stores kc us links groups data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_links_groups` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `link_id` int NOT NULL,\\n  `group_id` int NOT NULL,\\n  `created_by_id` int DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `link_id` (`link_id`),\\n  KEY `group_id` (`group_id`),\\n  KEY `created_by_id` (`created_by_id`),\\n  KEY `created_at` (`created_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_links_tags","full_table_name":"wp_kc_us_links_tags","description":"Stores kc us links tags data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_links_tags` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `link_id` int NOT NULL,\\n  `tag_id` int NOT NULL,\\n  `created_by_id` int DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `link_id` (`link_id`),\\n  KEY `tag_id` (`tag_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_tags","full_table_name":"wp_kc_us_tags","description":"Stores kc us tags data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(10)","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"color","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"link_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"tag_id","type":"int(10)","nullable":false,"primary_key":false},{"name":"created_by_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"link_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"keyword","type":"text","nullable":false,"primary_key":false},{"name":"link_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"post_types","type":"text","nullable":true,"primary_key":false},{"name":"open_new_tab","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"nofollow","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"case_sensitive","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"link_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `wp_kc_us_tags` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `color` varchar(20) DEFAULT '#6366f1' NOT 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) ) $collate; CREATE TABLE `wp_kc_us_links_tags` ( `id` int(10) NOT NULL AUTO_INCREMENT, `link_id` int(10) NOT NULL, `tag_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 tag_id (tag_id) ) $collate; \"; } /** * Create User Favorites Links Table. * * @since 1.12.2 */ public static function get_1122_schema( $collate = '' ) { global $wpdb; return \" CREATE TABLE `wp_kc_us_favorites_links` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `link_id` bigint(20) unsigned NOT NULL, `created_at` datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_link (user_id, link_id), KEY user_id (user_id), KEY link_id (link_id) ) $collate; \"; } /** * Create Auto Link Keywords Table. * * @since 1.13.1 */ public static function get_1131_schema( $collate = '' ) { global $wpdb; return \" CREATE TABLE `wp_kc_us_auto_link_keywords` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `keyword` text NOT NULL, `link_id` bigint(20) unsigned NOT NULL DEFAULT 0, `post_types` text DEFAULT NULL, `open_new_tab` tinyint(1) DEFAULT 0, `nofollow` tinyint(1) DEFAULT 0, `case_sensitive` tinyint(1) DEFAULT 0, `status` tinyint(1) DEFAULT 1, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (id), KEY keyword (keyword(191)), KEY link_id (link_id), KEY status (status) ) $collate; \"; } /** * Link meta table schema (stores per-link key/value metadata, e.g. broken-link scan results). * * @since 2.2.0 */ public static function get_220_schema( $collate = '' ) { global $wpdb; return \" CREATE TABLE `wp_kc_us_linkmeta` ( `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `link_id` bigint(20) unsigned NOT NULL DEFAULT 0, `meta_key` varchar(255) DEFAULT NULL, `meta_value` longtext DEFAULT NULL, PRIMARY KEY (meta_id), KEY link_id (link_id), KEY meta_key (meta_key(191)) ) $collate; \"; } /** * Run dbDelta to add new Open Graph columns to kc_us_links table. * * @since 2.4.0 */ public static function update_240_alter_links_table() { self::create_tables();"},{"table_name":"kc_us_tracking_pixels","full_table_name":"wp_kc_us_tracking_pixels","description":"Stores kc us tracking pixels data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_tracking_pixels` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(80) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `type` varchar(40) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `pixel_id` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `head_code` text COLLATE utf8mb4_unicode_520_ci,\\n  `body_code` text COLLATE utf8mb4_unicode_520_ci,\\n  `created_by_id` int DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_by_id` int DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `created_at` (`created_at`),\\n  KEY `updated_at` (`updated_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"kc_us_utm_presets","full_table_name":"wp_kc_us_utm_presets","description":"Stores kc us utm presets data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_kc_us_utm_presets` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `name` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `description` text COLLATE utf8mb4_unicode_520_ci,\\n  `utm_id` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `utm_source` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `utm_medium` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `utm_campaign` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `utm_term` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `utm_content` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_by_id` int DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_by_id` int DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `created_at` (`created_at`),\\n  KEY `updated_at` (`updated_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":16}