{"table_name":"metasync_redirections","full_table_name":"wp_metasync_redirections","description":"Stores metasync redirections data created by this plugin.","detection_method":"static","confidence":"medium","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);","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}],"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/"}}