{"slug":"onecraft-block-insights","name":"OneCraft Block Insights","description":"It names the block your readers stop at: reach, dwell and clicks, block by block.","author":"onecraftne","active_installs":0,"version":"1.0.5","wp_org_url":"https://wordpress.org/plugins/onecraft-block-insights/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"bi_","full_table_name":"wp_bi_","description":"Stores bi  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"blockinsights_","full_table_name":"wp_blockinsights_","description":"Stores blockinsights  data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"blockinsights_blocks","full_table_name":"wp_blockinsights_blocks","description":"Stores blockinsights blocks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"block_id","type":"BINARY(8)","nullable":false,"primary_key":false},{"name":"block_name","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"seen_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_blockinsights_blocks` ( `post_id` BIGINT UNSIGNED NOT NULL, `block_id` BINARY(8) NOT NULL, `block_name` VARCHAR(80) NOT NULL, `label` VARCHAR(120) NULL, `seen_at` DATETIME NOT NULL, PRIMARY KEY (`post_id`,`block_id`) ) ENGINE"},{"table_name":"blockinsights_changes","full_table_name":"wp_blockinsights_changes","description":"Stores blockinsights changes data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"changed_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"block_count","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"kind","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"changed_ids","type":"VARCHAR(255)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_blockinsights_changes` ( `post_id` BIGINT UNSIGNED NOT NULL, `changed_at` DATETIME NOT NULL, `block_count` SMALLINT UNSIGNED NOT NULL, `kind` VARCHAR(32) NOT NULL DEFAULT '', `changed_ids` VARCHAR(255) NOT NULL DEFAULT '', PRIMARY KEY (`post_id`,`changed_at`) ) ENGINE"},{"table_name":"blockinsights_daily","full_table_name":"wp_blockinsights_daily","description":"Stores blockinsights daily data created by this plugin.","detection_method":"static","confidence":"medium","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}],"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"},{"table_name":"blockinsights_monthly","full_table_name":"wp_blockinsights_monthly","description":"Stores blockinsights monthly data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"block_id","type":"BINARY(8)","nullable":false,"primary_key":false},{"name":"month","type":"DATE","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}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_blockinsights_monthly` ( `post_id` BIGINT UNSIGNED NOT NULL, `block_id` BINARY(8) NOT NULL, `month` DATE 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`,`month`) ) ENGINE"}],"table_count":6}