{"slug":"burst-statistics","name":"Burst Statistics – Privacy-Friendly WordPress Analytics (Google Analytics Alternative)","description":"Analytics you'll actually use. Privacy-friendly, zero config, and designed to be actionable. Get insights, not just raw data.","author":"Burst Statistics B.V.","active_installs":200000,"version":"3.3.0","wp_org_url":"https://wordpress.org/plugins/burst-statistics/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"burst_","full_table_name":"wp_burst_","description":"Stores burst  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"burst_archived_months","full_table_name":"wp_burst_archived_months","description":"Stores burst archived months data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"burst_browser_versions","full_table_name":"wp_burst_browser_versions","description":"Stores burst browser versions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"burst_browsers","full_table_name":"wp_burst_browsers","description":"Stores burst browsers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"burst_devices","full_table_name":"wp_burst_devices","description":"Stores burst devices data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"burst_goal_statistics","full_table_name":"wp_burst_goal_statistics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int","nullable":false,"primary_key":true},{"name":"statistic_id","type":"int","nullable":false,"primary_key":false},{"name":"goal_id","type":"int","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_burst_goal_statistics ( `ID` int NOT NULL AUTO_INCREMENT, `statistic_id` int NOT NULL, `goal_id` int NOT NULL, PRIMARY KEY (ID), UNIQUE KEY goal_statistic_unique (goal_id, statistic_id) ) $charset_collate;\"; dbDelta( $sql );"},{"table_name":"burst_goals","full_table_name":"wp_burst_goals","description":"Stores burst goals data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"burst_known_uids","full_table_name":"wp_burst_known_uids","description":"Stores burst known uids data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"burst_platforms","full_table_name":"wp_burst_platforms","description":"Stores burst platforms data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"burst_query_stats","full_table_name":"wp_burst_query_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"burst_referrers","full_table_name":"wp_burst_referrers","description":"Stores burst referrers data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"burst_report_logs","full_table_name":"wp_burst_report_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"bigint unsigned","nullable":false,"primary_key":true},{"name":"report_id","type":"bigint unsigned","nullable":false,"primary_key":false},{"name":"queue_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"batch_id","type":"int unsigned","nullable":true,"primary_key":false},{"name":"status","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"time","type":"int unsigned","nullable":false,"primary_key":false},{"name":"date","type":"varchar(10)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_burst_report_logs ( ID bigint unsigned NOT NULL AUTO_INCREMENT, report_id bigint unsigned NOT NULL, queue_id varchar(32) NOT NULL, batch_id int unsigned DEFAULT NULL, status varchar(32) NOT NULL, message text DEFAULT NULL, time int unsigned NOT NULL, date varchar(10) NOT NULL, PRIMARY KEY (ID) ) {$charset};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"},{"table_name":"burst_reports","full_table_name":"wp_burst_reports","description":"Stores burst reports data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"ID","type":"int unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"date_range","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"format","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"frequency","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"fixed_end_date","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"day_of_week","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"week_of_month","type":"int","nullable":true,"primary_key":false},{"name":"send_time","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"last_edit","type":"int unsigned","nullable":false,"primary_key":false},{"name":"enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"scheduled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"recipients","type":"longtext","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_burst_reports ( `ID` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `date_range` varchar(255) NOT NULL, `format` varchar(32) NOT NULL, `frequency` varchar(16) NOT NULL, `fixed_end_date` varchar(16) NOT NULL, `day_of_week` varchar(16) DEFAULT NULL, `week_of_month` int DEFAULT NULL, `send_time` varchar(16) NOT NULL, `last_edit` int unsigned NOT NULL, `enabled` tinyint(1) NOT NULL DEFAULT 1, `scheduled` tinyint(1) NOT NULL DEFAULT 0, `content` longtext NOT NULL, `recipients` longtext NOT NULL, PRIMARY KEY (`ID`) ) {$charset_collate};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );"},{"table_name":"burst_sessions","full_table_name":"wp_burst_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"burst_statistics","full_table_name":"wp_burst_statistics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","columns":[{"name":"ID","type":"int","nullable":false,"primary_key":true},{"name":"page_url","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"page_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"page_type","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"time","type":"int","nullable":false,"primary_key":false},{"name":"uid","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"time_on_page","type":"int","nullable":true,"primary_key":false},{"name":"parameters","type":"TEXT","nullable":false,"primary_key":false},{"name":"fragment","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"session_id","type":"int","nullable":true,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"conversion_metric","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"date_created","type":"int","nullable":false,"primary_key":false},{"name":"server_side","type":"int","nullable":false,"primary_key":false},{"name":"date_start","type":"int","nullable":false,"primary_key":false},{"name":"date_end","type":"int","nullable":false,"primary_key":false},{"name":"selector","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"hook","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"first_seen","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"last_seen","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"sql_hash","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"sql_query","type":"text","nullable":false,"primary_key":false},{"name":"avg_execution_time","type":"float","nullable":false,"primary_key":false},{"name":"max_execution_time","type":"float","nullable":false,"primary_key":false},{"name":"min_execution_time","type":"float","nullable":false,"primary_key":false},{"name":"last_updated","type":"int","nullable":false,"primary_key":false},{"name":"execution_count","type":"int","nullable":false,"primary_key":false}],"create_sql":"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, `session_id` int, 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 );"}],"table_count":15}