wp_blockinsights_daily
StaticStores blockinsights daily data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| post_id | BIGINT UNSIGNED | NO |
| block_id | BINARY(8) | NO |
| day | DATE | NO |
| device | TINYINT UNSIGNED | NO |
| impressions | INT UNSIGNED | NO |
| dwell_ms | BIGINT UNSIGNED | NO |
| clicks | INT UNSIGNED | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_blockinsights_daily` ( `post_id` BIGINT UNSIGNED NOT NULL, `block_id` BINARY(8) NOT NULL, `day` DATE NOT NULL, `device` TINYINT UNSIGNED NOT NULL, `impressions` INT UNSIGNED NOT NULL DEFAULT 0, `dwell_ms` BIGINT UNSIGNED NOT NULL DEFAULT 0, `clicks` INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`post_id`,`block_id`,`day`,`device`) ) ENGINE
Safe to delete?
If you have uninstalled OneCraft Block Insights, 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_blockinsights_daily`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from OneCraft Block Insights