{"table_name":"blockinsights_daily","full_table_name":"wp_blockinsights_daily","description":"Stores blockinsights daily data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_blockinsights_daily` ( `post_id` BIGINT UNSIGNED NOT NULL, `block_id` BINARY(8) NOT NULL, `day` DATE NOT NULL, `device` TINYINT UNSIGNED NOT NULL, `impressions` INT UNSIGNED NOT NULL DEFAULT 0, `dwell_ms` BIGINT UNSIGNED NOT NULL DEFAULT 0, `clicks` INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (`post_id`,`block_id`,`day`,`device`) ) ENGINE","columns":[{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"block_id","type":"BINARY(8)","nullable":false,"primary_key":false},{"name":"day","type":"DATE","nullable":false,"primary_key":false},{"name":"device","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"impressions","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"dwell_ms","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"clicks","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"plugin":{"slug":"onecraft-block-insights","name":"OneCraft Block Insights","active_installs":0,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/onecraft-block-insights/"}}