@rhorny
I think the cleanup of the markup changes by the editor didn’t go well. Can you try the following:
add_action( 'plugins_loaded', 'my_burst_install_statistics_table', 10 );
function my_burst_install_statistics_table() {
require_once ABSPATH . 'wp-admin/includes/upgrade.php';
global $wpdb;
$charset_collate = $wpdb->get_charset_collate();
$table_name = $wpdb->prefix . 'burst_statistics';
$sql = "CREATE TABLE $table_name (
ID int NOT NULL AUTO_INCREMENT ,
page_url varchar(191) NOT NULL,
time int NOT NULL,
uid varchar(255) NOT NULL,
time_on_page int,
entire_page_url varchar(255) NOT NULL,
page_id int NOT NULL,
referrer varchar(255),
browser varchar(255),
browser_version varchar(255),
platform varchar(255),
device varchar(255),
device_resolution varchar(255),
session_id int,
first_time_visit tinyint,
bounce tinyint DEFAULT 1,
PRIMARY KEY (ID),
INDEX time_index (time),
INDEX bounce_index (bounce),
INDEX page_url_index (page_url),
INDEX session_id_index (session_id),
INDEX time_page_url_index (time, page_url)
) $charset_collate;";
dbDelta( $sql );
}