{"slug":"metasync","name":"Search Atlas SEO – OTTO AI SEO Automation for WordPress","description":"AI-powered SEO & GEO for WordPress: OTTO auto-optimizes meta, schema & content, and helps you rank on Google and in AI search.","author":"Search Atlas Group","active_installs":7000,"version":"2.7.3","wp_org_url":"https://wordpress.org/plugins/metasync/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"aioseo_posts","full_table_name":"wp_aioseo_posts","description":"Stores aioseo posts data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"aioseo_terms","full_table_name":"wp_aioseo_terms","description":"Stores aioseo terms data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"metasync_404_logs","full_table_name":"wp_metasync_404_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"uri","type":"TEXT","nullable":false,"primary_key":false},{"name":"hits_count","type":"BIGINT(20) unsigned","nullable":false,"primary_key":false},{"name":"date_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"referer","type":"TEXT","nullable":true,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_metasync_404_logs ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, uri TEXT NOT NULL, hits_count BIGINT(20) unsigned NOT NULL DEFAULT '1', date_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, user_agent TEXT NULL, referer TEXT NULL, ip_address VARCHAR(45) NULL, PRIMARY KEY id (id), KEY uri (uri(191)), KEY hits_count (hits_count), KEY date_time (date_time) ) $collate;\"; dbDelta($table_sql);"},{"table_name":"metasync_otto_bot_logs","full_table_name":"wp_metasync_otto_bot_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"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","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}],"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);"},{"table_name":"metasync_otto_excluded_urls","full_table_name":"wp_metasync_otto_excluded_urls","description":"Stores metasync otto excluded urls data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"url_pattern","type":"TEXT","nullable":false,"primary_key":false},{"name":"pattern_type","type":"ENUM('exact', 'contain', 'start', 'end', 'regex')","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"is_permanent","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"auto_excluded","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"recheck_after","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_metasync_otto_excluded_urls ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, url_pattern TEXT NOT NULL, pattern_type ENUM('exact', 'contain', 'start', 'end', 'regex') NOT NULL DEFAULT 'exact', description TEXT NULL, status VARCHAR(25) NOT NULL DEFAULT 'active', is_permanent TINYINT(1) NOT NULL DEFAULT 0, auto_excluded TINYINT(1) NOT NULL DEFAULT 0, recheck_after DATETIME NULL DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY id (id), KEY status (status), KEY pattern_type (pattern_type), KEY created_at (created_at), KEY is_permanent (is_permanent), KEY auto_excluded (auto_excluded), KEY recheck_after (recheck_after), UNIQUE KEY url_pattern_type_unique (url_pattern(191), pattern_type) ) $collate;\"; dbDelta($table_sql);"},{"table_name":"metasync_redirections","full_table_name":"wp_metasync_redirections","description":"Stores metasync redirections data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"sources_from","type":"TEXT","nullable":false,"primary_key":false},{"name":"url_redirect_to","type":"TEXT","nullable":false,"primary_key":false},{"name":"http_code","type":"SMALLINT(4) unsigned","nullable":false,"primary_key":false},{"name":"hits_count","type":"BIGINT(20) unsigned","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"pattern_type","type":"ENUM('exact', 'contain', 'start', 'end', 'regex', 'wildcard')","nullable":false,"primary_key":false},{"name":"regex_pattern","type":"TEXT","nullable":true,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"last_accessed_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_metasync_redirections ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, sources_from TEXT NOT NULL, url_redirect_to TEXT NOT NULL, http_code SMALLINT(4) unsigned NOT NULL DEFAULT 301, hits_count BIGINT(20) unsigned NOT NULL DEFAULT '0', status VARCHAR(25) NOT NULL DEFAULT 'active', pattern_type ENUM('exact', 'contain', 'start', 'end', 'regex', 'wildcard') NOT NULL DEFAULT 'exact', regex_pattern TEXT NULL, description TEXT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', updated_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', last_accessed_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY id (id), KEY status (status), KEY pattern_type (pattern_type), KEY created_at (created_at), KEY idx_active_redirects (status, sources_from(191)) ) $collate;\"; dbDelta($table_sql);"},{"table_name":"metasync_robots_txt_backups","full_table_name":"wp_metasync_robots_txt_backups","description":"Stores metasync robots txt backups data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_by","type":"bigint(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_metasync_robots_txt_backups ( id bigint(20) NOT NULL AUTO_INCREMENT, content longtext NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, created_by bigint(20) DEFAULT NULL, PRIMARY KEY (id), KEY created_at (created_at) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta($sql);"},{"table_name":"metasync_sync_history","full_table_name":"wp_metasync_sync_history","description":"Stores metasync sync history data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(25)","nullable":false,"primary_key":false},{"name":"content_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"url","type":"TEXT","nullable":true,"primary_key":false},{"name":"meta_data","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_metasync_sync_history ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL DEFAULT '', source VARCHAR(50) NOT NULL DEFAULT '', status VARCHAR(25) NOT NULL DEFAULT 'draft', content_type VARCHAR(50) NOT NULL DEFAULT '', url TEXT NULL, meta_data TEXT NULL, created_at DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY id (id), KEY source (source), KEY status (status), KEY created_at (created_at), KEY idx_dedup (source, created_at), KEY idx_search (title(50), source, created_at) ) $collate;\"; dbDelta($table_sql);"},{"table_name":"yoast_indexable","full_table_name":"wp_yoast_indexable","description":"Stores yoast indexable data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":10}