wp_attentiq_hourly_stats
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | YES |
| post_id | BIGINT UNSIGNED | NO |
| stat_date | DATE | NO |
| stat_hour | TINYINT UNSIGNED | NO |
| device | VARCHAR(10) | NO |
| views | INT UNSIGNED | YES |
| total_time | FLOAT | YES |
| avg_scroll | FLOAT | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_attentiq_hourly_stats` ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, stat_date DATE NOT NULL, stat_hour TINYINT UNSIGNED NOT NULL, device VARCHAR(10) NOT NULL DEFAULT 'all', views INT UNSIGNED DEFAULT 0, unique_views INT UNSIGNED DEFAULT 0, total_time FLOAT DEFAULT 0, avg_scroll FLOAT DEFAULT 0, UNIQUE KEY post_date_hour_device (post_id, stat_date, stat_hour, device), KEY idx_stat_date (stat_date) ) {$charset}" );Safe to delete?
If you have uninstalled AttentIQ, 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_attentiq_hourly_stats`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AttentIQ