{"table_name":"burst_statistics","full_table_name":"wp_burst_statistics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"high","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 );","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}],"plugin":{"slug":"burst-statistics","name":"Burst Statistics – Privacy-Friendly WordPress Analytics (Google Analytics Alternative)","active_installs":200000,"version":"3.3.0","wp_org_url":"https://wordpress.org/plugins/burst-statistics/"}}