wp_atk_ai_logs

Static

A logging table that records activity, events, or audit history.

Column Definitions

Column	Type	Nullable
🔑log_id	bigint(20) unsigned	NO
user_id	bigint(20) unsigned	NO
action	varchar(255)	NO
action_name	varchar(255)	NO
action_type	varchar(255)	NO
user_ip_address	varchar(100)	YES
ip_location	varchar(4096)	YES
action_url	varchar(4096)	NO
created_date	datetime	NO
updated_date	datetime	NO
action	varchar(255)	NO
action_name	varchar(255)	NO
user_id	bigint(20) unsigned	NO
email_to	varchar(255)	YES
count_emails	bigint(20) unsigned	NO
created_date	datetime	NO
updated_date	datetime	NO

CREATE TABLE Statement

CREATE TABLE wp_atk_ai_logs ( log_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, user_id bigint(20) unsigned NOT NULL, action varchar(255) NOT NULL, action_name varchar(255) NOT NULL, action_type varchar(255) NOT NULL, user_ip_address varchar(100) NULL DEFAULT '', ip_location varchar(4096) NULL DEFAULT '', action_url varchar(4096) NOT NULL, created_date datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_date datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (log_id), KEY user_id (user_id), UNIQUE KEY session_key (log_id) ) $collate; CREATE TABLE wp_atk_ai_stats ( stat_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, action varchar(255) NOT NULL, action_name varchar(255) NOT NULL, user_id bigint(20) unsigned NOT NULL, email_to varchar(255) NULL DEFAULT '', count_emails bigint(20) unsigned NOT NULL, created_date datetime DEFAULT CURRENT_TIMESTAMP NOT NULL, updated_date datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL, PRIMARY KEY (stat_id), KEY user_id (user_id), UNIQUE KEY session_key (stat_id) ) $collate; "; dbDelta( $tables );

Safe to delete?

If you have uninstalled Activity Track – User Activity 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_atk_ai_logs`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Activity Track – User Activity Log

wp_atk_ai_stats