{"table_name":"metasync_otto_bot_stats","full_table_name":"wp_metasync_otto_bot_stats","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_metasync_otto_bot_stats ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, stat_key varchar(100) NOT NULL, stat_value bigint(20) NOT NULL DEFAULT 0, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY stat_key (stat_key), KEY updated_at (updated_at) ) $charset_collate;\"; // Logs table v2: unique entries with hit_count $logs_sql = \"CREATE TABLE wp_metasync_otto_bot_logs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, bot_name varchar(255) NOT NULL, bot_type varchar(50) NOT NULL, user_agent text NOT NULL, ip_address varchar(45) NOT NULL DEFAULT '', detection_method varchar(50) DEFAULT NULL, url text DEFAULT NULL, hit_count bigint(20) unsigned NOT NULL DEFAULT 1, first_seen_at datetime NOT NULL, last_seen_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY unique_bot_ip (bot_name(100), ip_address), KEY bot_type (bot_type), KEY last_seen_at (last_seen_at), KEY hit_count (hit_count) ) $charset_collate;\"; dbDelta($stats_sql);","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"stat_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"stat_value","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"bot_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"bot_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"user_agent","type":"text","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"detection_method","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"url","type":"text","nullable":true,"primary_key":false},{"name":"hit_count","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"first_seen_at","type":"datetime","nullable":false,"primary_key":false},{"name":"last_seen_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"metasync","name":"Search Atlas SEO – OTTO AI SEO Automation for WordPress","active_installs":7000,"version":"2.7.3","wp_org_url":"https://wordpress.org/plugins/metasync/"}}