wp_a11yfy_jobs
StaticA job queue table for managing background tasks and scheduled operations.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| attachment_id | BIGINT UNSIGNED | NO |
| job_id | VARCHAR(64) | YES |
| idempotency_key | VARCHAR(128) | NO |
| file_hash | CHAR(64) | NO |
| file_name | VARCHAR(255) | NO |
| status | VARCHAR(20) | NO |
| credits_used | INT UNSIGNED | YES |
| treatment | VARCHAR(20) | YES |
| compliant | TINYINT(1) | YES |
| before_issues | INT UNSIGNED | YES |
| before_pages | INT UNSIGNED | YES |
| error_code | VARCHAR(64) | YES |
| error_message | TEXT | YES |
| source | VARCHAR(10) | NO |
| poll_attempts | INT UNSIGNED | NO |
| submitted_at | DATETIME | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
| attachment_id | BIGINT UNSIGNED | NO |
| job_row_id | BIGINT UNSIGNED | YES |
| mode | VARCHAR(20) | NO |
| backup_path | VARCHAR(1024) | YES |
| remediated_path | VARCHAR(1024) | YES |
| remediated_backup_path | VARCHAR(1024) | YES |
| remediated_hash | CHAR(64) | YES |
| original_hash | CHAR(64) | NO |
| treatment | VARCHAR(20) | YES |
| compliant | TINYINT(1) | YES |
| before_issues | INT UNSIGNED | YES |
| credits_used | INT UNSIGNED | YES |
| source | VARCHAR(10) | NO |
| status | VARCHAR(20) | NO |
| opt_out | TINYINT(1) | NO |
| remediated_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE wp_a11yfy_jobs ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, attachment_id BIGINT UNSIGNED NOT NULL, job_id VARCHAR(64) NULL, idempotency_key VARCHAR(128) NOT NULL, file_hash CHAR(64) NOT NULL, file_name VARCHAR(255) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'queued', credits_used INT UNSIGNED NULL, treatment VARCHAR(20) NULL, compliant TINYINT(1) NULL, before_issues INT UNSIGNED NULL, before_pages INT UNSIGNED NULL, error_code VARCHAR(64) NULL, error_message TEXT NULL, source VARCHAR(10) NOT NULL DEFAULT 'manual', poll_attempts INT UNSIGNED NOT NULL DEFAULT 0, submitted_at DATETIME NULL, created_at DATETIME NOT NULL, updated_at DATETIME NOT NULL, PRIMARY KEY (id), KEY attachment_id (attachment_id), KEY status (status), KEY job_id (job_id) ) $charset;"; // original attachment → remediated file mapping (report, restore, hash-gate). $map = "CREATE TABLE wp_a11yfy_map ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, attachment_id BIGINT UNSIGNED NOT NULL, job_row_id BIGINT UNSIGNED NULL, mode VARCHAR(20) NOT NULL DEFAULT 'inplace', backup_path VARCHAR(1024) NULL, remediated_path VARCHAR(1024) NULL, remediated_backup_path VARCHAR(1024) NULL, remediated_hash CHAR(64) NULL, original_hash CHAR(64) NOT NULL, treatment VARCHAR(20) NULL, compliant TINYINT(1) NULL, before_issues INT UNSIGNED NULL, credits_used INT UNSIGNED NULL, source VARCHAR(10) NOT NULL DEFAULT 'manual', status VARCHAR(20) NOT NULL DEFAULT 'active', opt_out TINYINT(1) NOT NULL DEFAULT 0, remediated_at DATETIME NULL, PRIMARY KEY (id), UNIQUE KEY attachment_id (attachment_id) ) $charset;"; dbDelta( $jobs );
Safe to delete?
If you have uninstalled a11yfy – PDF Accessibility Checker & Fixer, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_a11yfy_jobs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from a11yfy – PDF Accessibility Checker & Fixer