wp_kc_us_tags
StaticStores kc us tags data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(10) | NO |
| name | varchar(255) | YES |
| description | text | YES |
| color | varchar(20) | NO |
| created_by_id | int(11) | YES |
| created_at | datetime | YES |
| updated_by_id | int(11) | YES |
| updated_at | datetime | YES |
| link_id | int(10) | NO |
| tag_id | int(10) | NO |
| created_by_id | int(11) | YES |
| created_at | datetime | YES |
| user_id | bigint(20) unsigned | NO |
| link_id | bigint(20) unsigned | NO |
| created_at | datetime | YES |
| keyword | text | NO |
| link_id | bigint(20) unsigned | NO |
| post_types | text | YES |
| open_new_tab | tinyint(1) | YES |
| nofollow | tinyint(1) | YES |
| case_sensitive | tinyint(1) | YES |
| status | tinyint(1) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| link_id | bigint(20) unsigned | NO |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
CREATE TABLE Statement
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();Safe to delete?
If you have uninstalled URL Shortify – Simple and Easy URL Shortener, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_kc_us_tags`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from URL Shortify – Simple and Easy URL Shortener