wp_dreamcore_monitor_user_agents
StaticStores dreamcore monitor user agents data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | YES |
| user_agent_string | TEXT | NO |
| user_agent_hash | VARCHAR(32) | NO |
| category | VARCHAR(20) | NO |
| agent_name | VARCHAR(100) | NO |
| agent_version | VARCHAR(20) | YES |
| visit_count | BIGINT UNSIGNED | YES |
| first_seen | DATETIME | YES |
| last_seen | DATETIME | YES |
| last_ip | VARCHAR(45) | YES |
| last_page | TEXT | YES |
CREATE TABLE Statement
CREATE TABLE wp_dreamcore_monitor_user_agents ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, user_agent_string TEXT NOT NULL, user_agent_hash VARCHAR(32) NOT NULL, category VARCHAR(20) NOT NULL DEFAULT 'unknown', agent_name VARCHAR(100) NOT NULL DEFAULT 'Unknown', agent_version VARCHAR(20) DEFAULT '', visit_count BIGINT UNSIGNED DEFAULT 1, first_seen DATETIME DEFAULT CURRENT_TIMESTAMP, last_seen DATETIME DEFAULT CURRENT_TIMESTAMP, last_ip VARCHAR(45) DEFAULT '', last_page TEXT DEFAULT '', UNIQUE KEY idx_user_agent_hash (user_agent_hash), INDEX idx_category (category), INDEX idx_agent_name (agent_name), INDEX idx_visit_count (visit_count), INDEX idx_last_seen (last_seen), INDEX idx_first_seen (first_seen) ) {$charset_collate}"; // Safe loading of upgrade.php with proper path handling $upgrade_file = wp_normalize_path( ABSPATH . 'wp-admin/includes/upgrade.php' );Safe to delete?
If you have uninstalled DreamCore Monitor, 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_dreamcore_monitor_user_agents`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from DreamCore Monitor