wp_autoseo_issues

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_autoseo_issues ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NOT NULL, issue_type VARCHAR(50) NOT NULL, severity ENUM('critical','major','minor') DEFAULT 'minor', status ENUM('open','fixed','ignored') DEFAULT 'open', details LONGTEXT NULL COMMENT 'JSON', priority_score TINYINT UNSIGNED DEFAULT 0, priority_tier VARCHAR(20) DEFAULT '', geo_score TINYINT UNSIGNED NULL, resolved_by_fix_id BIGINT UNSIGNED NULL, detected_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_post_id (post_id), KEY idx_status (status), KEY idx_severity (severity), KEY idx_issue_type (issue_type), KEY idx_priority (priority_score), KEY idx_post_status (post_id, status) ) $charset_collate;"; // Table: wp_autoseo_fixes $sql_fixes = "CREATE TABLE wp_autoseo_fixes ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NOT NULL, field_name VARCHAR(100) NOT NULL, original_value LONGTEXT NULL, new_value LONGTEXT NULL, fix_type ENUM('ai','rule','manual') DEFAULT 'ai', status ENUM('pending','applied','rejected','rolled_back') DEFAULT 'pending', pre_fix_position DECIMAL(6,2) NULL, pre_fix_impressions INT NULL, pre_fix_clicks INT NULL, pre_fix_ctr DECIMAL(5,4) NULL, post_fix_position_7d DECIMAL(6,2) NULL, post_fix_impressions_7d INT NULL, post_fix_clicks_7d INT NULL, post_fix_ctr_7d DECIMAL(5,4) NULL, post_fix_position_14d DECIMAL(6,2) NULL, post_fix_impressions_14d INT NULL, post_fix_clicks_14d INT NULL, post_fix_ctr_14d DECIMAL(5,4) NULL, impact_score TINYINT UNSIGNED NULL, impact_measured_at DATETIME NULL, applied_at DATETIME NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_post_id (post_id), KEY idx_status (status), KEY idx_created_at (created_at) ) $charset_collate;"; // Table: wp_autoseo_snapshots $sql_snapshots = "CREATE TABLE wp_autoseo_snapshots ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NOT NULL, snapshot_data LONGTEXT NOT NULL COMMENT 'JSON', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_post_id (post_id) ) $charset_collate;"; // Table: wp_autoseo_audit_runs $sql_audit_runs = "CREATE TABLE wp_autoseo_audit_runs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, started_at DATETIME DEFAULT CURRENT_TIMESTAMP, completed_at DATETIME NULL, posts_scanned INT UNSIGNED DEFAULT 0, issues_found INT UNSIGNED DEFAULT 0, fixes_applied INT UNSIGNED DEFAULT 0, fixes_generated INT UNSIGNED DEFAULT 0, fixes_queued INT UNSIGNED DEFAULT 0, pages_skipped_low_priority INT UNSIGNED DEFAULT 0, pages_skipped_cwv INT UNSIGNED DEFAULT 0, status ENUM('running','completed','failed') DEFAULT 'running', run_type ENUM('manual','scheduled','autonomous') DEFAULT 'manual', run_log LONGTEXT NULL COMMENT 'JSON array of step log entries', PRIMARY KEY (id), KEY idx_status (status), KEY idx_started_at (started_at) ) $charset_collate;"; dbDelta( $sql_issues );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_autoseo_issues`;

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

Other tables from ThemeMiles SEO Agent