{"table_name":"burst_event_names","full_table_name":"wp_burst_event_names","description":"Stores burst event names data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_burst_event_names ( `ID` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, PRIMARY KEY (ID), UNIQUE KEY name (name) ) $charset_collate;\"; $events_sql = \"CREATE TABLE wp_burst_events ( `ID` int NOT NULL AUTO_INCREMENT, `statistic_id` int NOT NULL, `uid_id` int unsigned NOT NULL DEFAULT 0, `time` int NOT NULL, `name_id` int unsigned NOT NULL, `value` float DEFAULT NULL, PRIMARY KEY (ID) ) $charset_collate;\"; $tables_to_install = [ 'burst_event_names' => $names_sql, 'burst_events' => $events_sql, ]; foreach ( $tables_to_install as $table_name => $sql ) { dbDelta( $sql );","columns":[{"name":"ID","type":"int unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"statistic_id","type":"int","nullable":false,"primary_key":false},{"name":"uid_id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"time","type":"int","nullable":false,"primary_key":false},{"name":"name_id","type":"int unsigned","nullable":false,"primary_key":false},{"name":"value","type":"float","nullable":true,"primary_key":false}],"plugin":{"slug":"burst-statistics","name":"Burst Statistics – Simple WordPress Analytics (Google Analytics Alternative)","active_installs":200000,"version":"3.7.3","wp_org_url":"https://wordpress.org/plugins/burst-statistics/"}}