wp_redirects

Column Definitions

CREATE TABLE Statement

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);

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_redirects`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Pylon SEO