wp_burst_statistics
StaticStores analytics or statistics data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑ID | int | NO |
| page_url | varchar(191) | NO |
| page_id | int(11) | NO |
| page_type | varchar(191) | NO |
| time | int | NO |
| uid | varchar(64) | NO |
| time_on_page | int | YES |
| parameters | TEXT | NO |
| fragment | varchar(255) | NO |
| browser_id | int(11) | NO |
| browser_version_id | int(11) | NO |
| platform_id | int(11) | NO |
| device_id | int(11) | NO |
| session_id | int | YES |
| first_time_visit | tinyint | YES |
| bounce | tinyint | YES |
| name | varchar(255) | NO |
| name | varchar(255) | NO |
| name | varchar(255) | NO |
| name | varchar(255) | NO |
| name | varchar(255) | NO |
| title | varchar(255) | NO |
| type | varchar(30) | NO |
| status | varchar(30) | NO |
| url | varchar(255) | NO |
| conversion_metric | varchar(255) | NO |
| date_created | int | NO |
| server_side | int | NO |
| date_start | int | NO |
| date_end | int | NO |
| selector | varchar(255) | NO |
| hook | varchar(255) | NO |
| first_seen | INT UNSIGNED | NO |
| last_seen | INT UNSIGNED | NO |
| sql_hash | varchar(16) | NO |
| sql_query | text | NO |
| avg_execution_time | float | NO |
| max_execution_time | float | NO |
| min_execution_time | float | NO |
| last_updated | int | NO |
| execution_count | int | NO |
CREATE TABLE Statement
CREATE TABLE wp_burst_statistics ( `ID` int NOT NULL AUTO_INCREMENT, `page_url` varchar(191) NOT NULL, `page_id` int(11) NOT NULL, `page_type` varchar(191) NOT NULL, `time` int NOT NULL, `uid` varchar(64) NOT NULL, `time_on_page` int, `parameters` TEXT NOT NULL, `fragment` varchar(255) NOT NULL, `browser_id` int(11) NOT NULL, `browser_version_id` int(11) NOT NULL, `platform_id` int(11) NOT NULL, `device_id` int(11) NOT NULL, `session_id` int, `first_time_visit` tinyint, `bounce` tinyint DEFAULT 1, PRIMARY KEY (ID) ) $charset_collate;", 'burst_browsers' => "CREATE TABLE wp_burst_browsers ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (ID) ) $charset_collate;", 'burst_browser_versions' => "CREATE TABLE wp_burst_browser_versions ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (ID) ) $charset_collate;", 'burst_platforms' => "CREATE TABLE wp_burst_platforms ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (ID) ) $charset_collate;", 'burst_devices' => "CREATE TABLE wp_burst_devices ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, PRIMARY KEY (ID) ) $charset_collate;", 'burst_referrers' => "CREATE TABLE wp_burst_referrers ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL UNIQUE, PRIMARY KEY (ID) ) $charset_collate;", 'burst_goals' => "CREATE TABLE wp_burst_goals ( `ID` int NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `type` varchar(30) NOT NULL, `status` varchar(30) NOT NULL, `url` varchar(255) NOT NULL, `conversion_metric` varchar(255) NOT NULL, `date_created` int NOT NULL, `server_side` int NOT NULL, `date_start` int NOT NULL, `date_end` int NOT NULL, `selector` varchar(255) NOT NULL, `hook` varchar(255) NOT NULL, PRIMARY KEY (ID) ) $charset_collate;", 'burst_known_uids' => "CREATE TABLE wp_burst_known_uids ( `uid` varchar(64) NOT NULL, `first_seen` INT UNSIGNED NOT NULL, `last_seen` INT UNSIGNED NOT NULL, PRIMARY KEY (uid) ) $charset_collate;", 'burst_query_stats' => "CREATE TABLE wp_burst_query_stats ( `ID` int NOT NULL AUTO_INCREMENT, `sql_hash` varchar(16) NOT NULL, `sql_query` text NOT NULL, `avg_execution_time` float NOT NULL, `max_execution_time` float NOT NULL, `min_execution_time` float NOT NULL, `last_updated` int NOT NULL, `execution_count` int NOT NULL, PRIMARY KEY (ID), UNIQUE KEY sql_hash (sql_hash) ) $charset_collate;", ]; // Create tables. foreach ( $tables as $table_name => $sql ) { dbDelta( $sql );Safe to delete?
If you have uninstalled Burst Statistics – Privacy-Friendly WordPress Analytics (Google Analytics Alternative), 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_burst_statistics`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Burst Statistics – Privacy-Friendly WordPress Analytics (Google Analytics Alternative)