wp_kc_lf_activity_logs
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(10) | NO |
| site_id | bigint(20) | YES |
| event_id | bigint(20) | NO |
| severity | bigint(20) | YES |
| action | varchar(100) | NO |
| user_id | bigint(20) | YES |
| user_role | varchar(255) | YES |
| user_login | varchar(60) | NO |
| user_display_name | varchar(250) | NO |
| event_type | varchar(100) | NO |
| object_id | bigint(20) | NO |
| object_type | varchar(100) | NO |
| object_name | varchar(250) | NO |
| ip | varchar(255) | NO |
| user_agent | varchar(255) | YES |
| session_id | varchar(255) | YES |
| request_id | varchar(40) | YES |
| description | text | NO |
| metadata | longtext | YES |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE `wp_kc_lf_activity_logs` ( `id` int(10) NOT NULL AUTO_INCREMENT, `site_id` bigint(20) DEFAULT 1, `event_id` bigint(20) NOT NULL, `severity` bigint(20) DEFAULT 0, `action` varchar(100) NOT NULL, `user_id` bigint(20) DEFAULT NULL, `user_role` varchar(255) DEFAULT NULL, `user_login` varchar(60) NOT NULL, `user_display_name` varchar(250) NOT NULL, `event_type` varchar(100) NOT NULL, `object_id` bigint(20) NOT NULL, `object_type` varchar(100) NOT NULL, `object_name` varchar(250) NOT NULL, `ip` varchar(255) NOT NULL, `user_agent` varchar(255) DEFAULT NULL, `session_id` varchar(255) DEFAULT NULL, `request_id` varchar(40) DEFAULT NULL, `description` text NOT NULL, `metadata` longtext, `created_at` datetime NOT NULL, PRIMARY KEY (`id`), KEY `idx_created_at` (`created_at`), KEY `idx_user_id` (`user_id`), KEY `idx_user_login` (`user_login`), KEY `idx_event_id` (`event_id`), KEY `idx_event_type` (`event_type`), KEY `idx_object_id` (`object_id`), KEY `idx_object_type` (`object_type`), KEY `idx_severity` (`severity`), KEY `idx_action` (`action`), KEY `idx_request_id` (`request_id`), KEY `idx_event_type_created_at` (`event_type`, `created_at`), KEY `idx_user_id_created_at` (`user_id`, `created_at`), KEY `idx_object_type_object_id` (`object_type`, `object_id`) ) $collate; "; return $tables; } /** * Get files to create * * @return array[] * * @since 1.1.0 */ public static function get_files() { // If we need to create more files/ dirs in the future // use following code return array_merge( [], self::get_110_files() );Safe to delete?
If you have uninstalled Logify – Event Logger, Activity Monitor, Activity Log & Audit Log, 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_lf_activity_logs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Logify – Event Logger, Activity Monitor, Activity Log & Audit Log