wp_kc_ml_audit_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| event_type | varchar(32) | NO |
| user_id | bigint(20) | NO |
| link_id | bigint(20) | NO |
| varchar(190) | YES | |
| ip_address | varchar(45) | YES |
| user_agent | varchar(255) | YES |
| country | varchar(8) | YES |
| meta_json | longtext | YES |
| created_at | datetime | YES |
| user_id | bigint(20) | NO |
| token | varchar(64) | NO |
| expires | datetime | NO |
| used | tinyint(1) | YES |
| ip_address | varchar(45) | YES |
| created_at | datetime | YES |
CREATE TABLE Statement
CREATE TABLE `wp_kc_ml_audit_log` ( id bigint(20) NOT NULL AUTO_INCREMENT, event_type varchar(32) NOT NULL, user_id bigint(20) NOT NULL DEFAULT 0, link_id bigint(20) NOT NULL DEFAULT 0, email varchar(190) DEFAULT '', ip_address varchar(45) DEFAULT '', user_agent varchar(255) DEFAULT '', country varchar(8) DEFAULT '', meta_json longtext, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY event_type (event_type), KEY user_id (user_id), KEY created_at (created_at), KEY email (email) ) $collate; "; } /** * @param string $collate * * @return string * * @since 1.1.0 * */ public static function get_110_schema( $collate = '' ) { global $wpdb; $tables = " CREATE TABLE `wp_kc_ml_magic_links` ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, token varchar(64) NOT NULL, expires datetime NOT NULL, used tinyint(1) DEFAULT 0, ip_address varchar(45), created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY token (token), KEY user_id (user_id), KEY expires (expires) ) $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 Magic Link – Secure one click passwordless login, 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_ml_audit_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Magic Link – Secure one click passwordless login