wp_aswp_visitor_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| ip | VARCHAR(45) | NO |
| ip_long | BIGINT | NO |
| country | VARCHAR(2) | NO |
| city | VARCHAR(100) | NO |
| method | VARCHAR(10) | NO |
| url | TEXT | NO |
| referer | TEXT | NO |
| user_agent | TEXT | NO |
| ua_family | VARCHAR(80) | NO |
| os_family | VARCHAR(80) | NO |
| user_id | BIGINT UNSIGNED | NO |
| username | VARCHAR(60) | NO |
| status_code | SMALLINT | NO |
| is_bot | TINYINT(1) | NO |
| bot_score | TINYINT UNSIGNED | NO |
| is_blocked | TINYINT(1) | NO |
| block_reason | VARCHAR(120) | NO |
| page_title | VARCHAR(255) | NO |
| post_id | BIGINT UNSIGNED | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE wp_aswp_visitor_log ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ip VARCHAR(45) NOT NULL, ip_long BIGINT NOT NULL DEFAULT 0, country VARCHAR(2) NOT NULL DEFAULT '', city VARCHAR(100) NOT NULL DEFAULT '', method VARCHAR(10) NOT NULL DEFAULT 'GET', url TEXT NOT NULL, referer TEXT NOT NULL, user_agent TEXT NOT NULL, ua_family VARCHAR(80) NOT NULL DEFAULT '', os_family VARCHAR(80) NOT NULL DEFAULT '', user_id BIGINT UNSIGNED NOT NULL DEFAULT 0, username VARCHAR(60) NOT NULL DEFAULT '', status_code SMALLINT NOT NULL DEFAULT 200, is_bot TINYINT(1) NOT NULL DEFAULT 0, bot_score TINYINT UNSIGNED NOT NULL DEFAULT 0, is_blocked TINYINT(1) NOT NULL DEFAULT 0, block_reason VARCHAR(120) NOT NULL DEFAULT '', page_title VARCHAR(255) NOT NULL DEFAULT '', post_id BIGINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY ip (ip), KEY ip_long (ip_long), KEY created_at (created_at), KEY idx_created_ip (created_at, ip), KEY idx_post_created (post_id, created_at), KEY is_bot (is_bot), KEY is_blocked (is_blocked), KEY user_id (user_id) ) $charset;" );
Safe to delete?
If you have uninstalled Atlant Security, 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_aswp_visitor_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Atlant Security