{"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","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());","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}],"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/"}}