wp_metasync_otto_bot_stats
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| stat_key | varchar(100) | NO |
| stat_value | bigint(20) | NO |
| updated_at | datetime | YES |
| bot_name | varchar(255) | NO |
| bot_type | varchar(50) | NO |
| user_agent | text | NO |
| ip_address | varchar(45) | NO |
| detection_method | varchar(50) | YES |
| url | text | YES |
| hit_count | bigint(20) unsigned | NO |
| first_seen_at | datetime | NO |
| last_seen_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_metasync_otto_bot_stats ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, stat_key varchar(100) NOT NULL, stat_value bigint(20) NOT NULL DEFAULT 0, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY stat_key (stat_key), KEY updated_at (updated_at) ) $charset_collate;"; // Logs table v2: unique entries with hit_count $logs_sql = "CREATE TABLE wp_metasync_otto_bot_logs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, bot_name varchar(255) NOT NULL, bot_type varchar(50) NOT NULL, user_agent text NOT NULL, ip_address varchar(45) NOT NULL DEFAULT '', detection_method varchar(50) DEFAULT NULL, url text DEFAULT NULL, hit_count bigint(20) unsigned NOT NULL DEFAULT 1, first_seen_at datetime NOT NULL, last_seen_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY unique_bot_ip (bot_name(100), ip_address), KEY bot_type (bot_type), KEY last_seen_at (last_seen_at), KEY hit_count (hit_count) ) $charset_collate;"; dbDelta($stats_sql);
Safe to delete?
If you have uninstalled Search Atlas SEO – OTTO AI SEO Automation for WordPress, 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_metasync_otto_bot_stats`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Search Atlas SEO – OTTO AI SEO Automation for WordPress