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