wp_kc_uu_history
StaticStores kc uu history data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| entry_id | VARCHAR(50) | NO |
| date | DATETIME | NO |
| search_for | TEXT | NO |
| replace_with | TEXT | NO |
| tables | TEXT | NO |
| case_insensitive | TINYINT(1) | NO |
| replace_guids | TINYINT(1) | NO |
| total_changes | INT UNSIGNED | NO |
| total_updates | INT UNSIGNED | NO |
| undone | TINYINT(1) | NO |
| details | LONGTEXT | YES |
| name | VARCHAR(255) | NO |
| search_for | TEXT | NO |
| replace_with | TEXT | NO |
| select_tables | TEXT | NO |
| case_insensitive | VARCHAR(5) | NO |
| replace_guids | VARCHAR(5) | NO |
CREATE TABLE Statement
CREATE TABLE wp_kc_uu_history ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, entry_id VARCHAR(50) NOT NULL, date DATETIME NOT NULL, search_for TEXT NOT NULL, replace_with TEXT NOT NULL, tables TEXT NOT NULL, case_insensitive TINYINT(1) NOT NULL DEFAULT 0, replace_guids TINYINT(1) NOT NULL DEFAULT 0, total_changes INT UNSIGNED NOT NULL DEFAULT 0, total_updates INT UNSIGNED NOT NULL DEFAULT 0, undone TINYINT(1) NOT NULL DEFAULT 0, details LONGTEXT, PRIMARY KEY (id), UNIQUE KEY entry_id (entry_id), KEY date (date) ) $collate; CREATE TABLE wp_kc_uu_profiles ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, search_for TEXT NOT NULL, replace_with TEXT NOT NULL, select_tables TEXT NOT NULL, case_insensitive VARCHAR(5) NOT NULL DEFAULT 'off', replace_guids VARCHAR(5) NOT NULL DEFAULT 'off', PRIMARY KEY (id), UNIQUE KEY name (name) ) $collate; "; return $tables; } /** * Create files/ directory * * @since 1.2 */ public static function create_files() { // Want to bypass creation of files? if ( apply_filters( 'kc_uu_install_skip_create_files', false ) ) { return; } $files = array( array( 'base' => KC_UU_LOG_DIR, 'file' => '.htaccess', 'content' => 'deny from all', ), array( 'base' => KC_UU_LOG_DIR, 'file' => 'index.html', 'content' => '', ), );Safe to delete?
If you have uninstalled Search & Replace Everything – Quick and Easy Way to Find and Replace Text, Links, 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_uu_history`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Search & Replace Everything – Quick and Easy Way to Find and Replace Text, Links