{"table_name":"redirects","full_table_name":"wp_redirects","description":"Stores redirects data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_redirects ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, source_url TEXT NOT NULL, target_url TEXT NOT NULL, type SMALLINT UNSIGNED DEFAULT 301, match_type VARCHAR(20) DEFAULT 'exact', hits BIGINT UNSIGNED DEFAULT 0, last_accessed DATETIME NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_source_url (source_url(191)), INDEX idx_match_type (match_type) ) $charset;\", \"CREATE TABLE IF NOT EXISTS wp_404_log ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, url TEXT NOT NULL, referer TEXT NULL, user_agent TEXT NULL, ip VARCHAR(45) NULL, hits BIGINT UNSIGNED DEFAULT 1, first_seen DATETIME DEFAULT CURRENT_TIMESTAMP, last_seen DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_url (url(191)) ) $charset;\", \"CREATE TABLE IF NOT EXISTS wp_audit_log ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, object_id BIGINT UNSIGNED NULL, object_type VARCHAR(50) NOT NULL DEFAULT 'post', field VARCHAR(100) NOT NULL, old_value LONGTEXT NULL, new_value LONGTEXT NULL, user_id BIGINT UNSIGNED NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX idx_object (object_id, object_type) ) $charset;\", \"CREATE TABLE IF NOT EXISTS wp_sitemap_cache ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, type VARCHAR(50) NOT NULL, content LONGTEXT NOT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX idx_type (type) ) $charset;\", \"CREATE TABLE IF NOT EXISTS wp_indexnow_log ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, url TEXT NOT NULL, endpoint VARCHAR(255) NOT NULL, status VARCHAR(20) DEFAULT 'submitted', response_code INT DEFAULT 0, submitted_at DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX idx_submitted_at (submitted_at) ) $charset;\", \"CREATE TABLE IF NOT EXISTS wp_broken_links ( id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, link_url TEXT NOT NULL, anchor_text TEXT, status_code INT UNSIGNED DEFAULT 0, checked_at DATETIME DEFAULT NULL, ignored TINYINT UNSIGNED DEFAULT 0, INDEX idx_post (post_id), INDEX idx_ignored (ignored), INDEX idx_link_url (link_url(191)), INDEX idx_checked_at (checked_at) ) $charset;\", \"CREATE TABLE IF NOT EXISTS wp_indexables ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL UNIQUE, object_type VARCHAR(20) NOT NULL DEFAULT 'post', object_subtype VARCHAR(20) NOT NULL DEFAULT '', title TEXT, description TEXT, canonical TEXT, focus_keyword VARCHAR(255) DEFAULT '', schema_type VARCHAR(50) DEFAULT '', seo_score INT UNSIGNED DEFAULT 0, citeability_score INT UNSIGNED DEFAULT 0, aeo_score INT UNSIGNED DEFAULT 0, freshness_score INT UNSIGNED DEFAULT 0, word_count INT UNSIGNED DEFAULT 0, links_count INT UNSIGNED DEFAULT 0, heading_count INT UNSIGNED DEFAULT 0, image_count INT UNSIGNED DEFAULT 0, last_modified DATETIME DEFAULT NULL, indexed_at DATETIME DEFAULT CURRENT_TIMESTAMP, INDEX idx_post (post_id), INDEX idx_object_type (object_type), INDEX idx_seo_score (seo_score), INDEX idx_citeability (citeability_score), INDEX idx_aeo (aeo_score) ) $charset;\", \"CREATE TABLE IF NOT EXISTS wp_audit_history ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, post_id BIGINT UNSIGNED NOT NULL, score INT UNSIGNED NOT NULL DEFAULT 0, grade VARCHAR(2) NOT NULL DEFAULT '', total_checks INT UNSIGNED NOT NULL DEFAULT 0, passed INT UNSIGNED NOT NULL DEFAULT 0, warnings INT UNSIGNED NOT NULL DEFAULT 0, failed INT UNSIGNED NOT NULL DEFAULT 0, checked_at DATETIME NOT NULL, INDEX idx_post (post_id), INDEX idx_checked (checked_at) ) $charset;\", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ($tables as $sql) { dbDelta($sql);","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"source_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"target_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"type","type":"SMALLINT UNSIGNED","nullable":true,"primary_key":false},{"name":"match_type","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"hits","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"last_accessed","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"referer","type":"TEXT","nullable":true,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"ip","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"hits","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"first_seen","type":"DATETIME","nullable":true,"primary_key":false},{"name":"last_seen","type":"DATETIME","nullable":true,"primary_key":false},{"name":"object_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"object_type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"field","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"old_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"new_value","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"endpoint","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"response_code","type":"INT","nullable":true,"primary_key":false},{"name":"submitted_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"link_url","type":"TEXT","nullable":false,"primary_key":false},{"name":"anchor_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"status_code","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"ignored","type":"TINYINT UNSIGNED","nullable":true,"primary_key":false},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"object_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"object_subtype","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"title","type":"TEXT","nullable":true,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"canonical","type":"TEXT","nullable":true,"primary_key":false},{"name":"focus_keyword","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"schema_type","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"seo_score","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"citeability_score","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"aeo_score","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"freshness_score","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"word_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"links_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"heading_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"image_count","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"last_modified","type":"DATETIME","nullable":true,"primary_key":false},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"score","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"grade","type":"VARCHAR(2)","nullable":false,"primary_key":false},{"name":"total_checks","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"passed","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"warnings","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"failed","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"plugin":{"slug":"pylon-seo","name":"Pylon SEO","active_installs":0,"version":"1.0.4","wp_org_url":"https://wordpress.org/plugins/pylon-seo/"}}