wp_ahc_site_searches
StaticStores ahc site searches data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑srch_id | INT(11) UNSIGNED | NO |
| site_id | INT(11) | NO |
| srch_date | DATE | NO |
| srch_term | VARCHAR(100) | NO |
| srch_count | INT(11) UNSIGNED | NO |
| srch_results | INT(11) UNSIGNED | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `ahc_site_searches` ( `srch_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `site_id` INT(11) NOT NULL DEFAULT 1, `srch_date` DATE NOT NULL, `srch_term` VARCHAR(100) NOT NULL, `srch_count` INT(11) UNSIGNED NOT NULL DEFAULT 0, `srch_results` INT(11) UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`srch_id`), UNIQUE KEY `ahcfree_uq_site_date_term` (`site_id`, `srch_date`, `srch_term`) ) 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_site_searches`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Visitor Traffic Real Time Statistics