wp_ahc_hits
StaticStores ahc hits data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑hit_id | INT(11) UNSIGNED | NO |
| hit_ip_address | VARCHAR(50) | NO |
| hit_user_agent | VARCHAR(200) | NO |
| hit_request_uri | VARCHAR(200) | YES |
| hit_page_id | VARCHAR(30) | NO |
| hit_page_title | VARCHAR(200) | YES |
| ctr_id | INT(3) UNSIGNED | YES |
| hit_referer | VARCHAR(300) | YES |
| hit_referer_site | VARCHAR(100) | YES |
| srh_id | INT(3) UNSIGNED | YES |
| hit_search_words | VARCHAR(200) | YES |
| bsr_id | INT(3) UNSIGNED | NO |
| hit_date | DATE | NO |
| hit_time | TIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `ahc_hits` ( `hit_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(`hit_id`), `hit_ip_address` VARCHAR(50) NOT NULL, `hit_user_agent` VARCHAR(200) NOT NULL, `hit_request_uri` VARCHAR(200) NULL, `hit_page_id` VARCHAR(30) NOT NULL, `hit_page_title` VARCHAR(200) NULL, `ctr_id` INT(3) UNSIGNED NULL, `hit_referer` VARCHAR(300) NULL, `hit_referer_site` VARCHAR(100) NULL, `srh_id` INT(3) UNSIGNED NULL, `hit_search_words` VARCHAR(200) NULL, `bsr_id` INT(3) UNSIGNED NOT NULL, `hit_date` DATE NOT NULL, `hit_time` TIME NOT 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_hits`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Visitor Traffic Real Time Statistics