wp_ahc_recent_visitors
StaticStores ahc recent visitors data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑vtr_id | INT(11) UNSIGNED | NO |
| vtr_ip_address | VARCHAR(50) | NO |
| vtr_referer | VARCHAR(300) | YES |
| srh_id | INT(3) UNSIGNED | YES |
| bsr_id | INT(3) UNSIGNED | NO |
| ctr_id | INT(5) UNSIGNED | YES |
| vtr_date | DATE | NO |
| vtr_time | TIME | NO |
| ahc_city | varchar(230) | YES |
| ahc_region | varchar(230) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `ahc_recent_visitors` ( `vtr_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (`vtr_id`), `vtr_ip_address` VARCHAR(50) NOT NULL, `vtr_referer` VARCHAR(300) NULL, `srh_id` INT(3) UNSIGNED NULL, `bsr_id` INT(3) UNSIGNED NOT NULL, `ctr_id` INT(5) UNSIGNED NULL, `vtr_date` DATE NOT NULL, `vtr_time` TIME NOT NULL, `ahc_city` varchar(230) NULL, `ahc_region` varchar(230) NULL ) DEFAULT CHARSET
Safe to delete?
If you have uninstalled Visitor Traffic Real Time Statistics, 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_ahc_recent_visitors`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Visitor Traffic Real Time Statistics