wp_burst_statistics

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_id` int unsigned NOT NULL DEFAULT 0, `time_on_page` int, `max_scroll` int(3) NOT NULL DEFAULT 0, `dwell_zones` text, `parameters` TEXT NOT NULL, `fragment` varchar(255) NOT NULL, `session_id` int, PRIMARY KEY (ID) ) $charset_collate;", 'burst_uids' => "CREATE TABLE wp_burst_uids ( `ID` int unsigned NOT NULL AUTO_INCREMENT, `uid` varchar(64) NOT NULL, PRIMARY KEY (ID), UNIQUE KEY uid (uid) ) $uids_charset_collate;", 'burst_browsers' => "CREATE TABLE wp_burst_browsers ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL UNIQUE, PRIMARY KEY (ID) ) $charset_collate;", 'burst_browser_versions' => "CREATE TABLE wp_burst_browser_versions ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL UNIQUE, PRIMARY KEY (ID) ) $charset_collate;", 'burst_platforms' => "CREATE TABLE wp_burst_platforms ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL UNIQUE, PRIMARY KEY (ID) ) $charset_collate;", 'burst_devices' => "CREATE TABLE wp_burst_devices ( `ID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL UNIQUE, 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, `block_goal` tinyint NOT NULL DEFAULT 0, `page_id` int(11) NULL, `element_page` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (ID) ) $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, `date_range_days` int NOT NULL DEFAULT 0, PRIMARY KEY (ID), UNIQUE KEY sql_hash (sql_hash) ) $charset_collate;", 'burst_page_weights' => "CREATE TABLE wp_burst_page_weights ( `ID` bigint unsigned NOT NULL AUTO_INCREMENT, `page_id` int NOT NULL, `page_weight` bigint unsigned NOT NULL, `samples` int unsigned NOT NULL, `measured_at` int unsigned NOT NULL, PRIMARY KEY (ID), UNIQUE KEY page_id (page_id) ) $charset_collate;", 'burst_page_weight_history' => "CREATE TABLE wp_burst_page_weight_history ( `ID` bigint unsigned NOT NULL AUTO_INCREMENT, `page_id` int NOT NULL, `page_weight` bigint unsigned NOT NULL, `measured_at` int unsigned NOT NULL, PRIMARY KEY (ID), UNIQUE KEY page_id_measured_at (page_id, measured_at) ) $charset_collate;", ]; foreach ( $tables as $table_name => $sql ) { dbDelta( $sql );

Safe to delete?

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 – Simple WordPress Analytics (Google Analytics Alternative)