{"table_name":"a11yfy_jobs","full_table_name":"wp_a11yfy_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"medium","create_sql":"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 );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"attachment_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"job_id","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"idempotency_key","type":"VARCHAR(128)","nullable":false,"primary_key":false},{"name":"file_hash","type":"CHAR(64)","nullable":false,"primary_key":false},{"name":"file_name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"credits_used","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"treatment","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"compliant","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"before_issues","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"before_pages","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"error_code","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"error_message","type":"TEXT","nullable":true,"primary_key":false},{"name":"source","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"poll_attempts","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"submitted_at","type":"DATETIME","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":"attachment_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"job_row_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"mode","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"backup_path","type":"VARCHAR(1024)","nullable":true,"primary_key":false},{"name":"remediated_path","type":"VARCHAR(1024)","nullable":true,"primary_key":false},{"name":"remediated_backup_path","type":"VARCHAR(1024)","nullable":true,"primary_key":false},{"name":"remediated_hash","type":"CHAR(64)","nullable":true,"primary_key":false},{"name":"original_hash","type":"CHAR(64)","nullable":false,"primary_key":false},{"name":"treatment","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"compliant","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"before_issues","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"credits_used","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"source","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"opt_out","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"remediated_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"a11yfy-pdf-accessibility-checker-fixer","name":"a11yfy – PDF Accessibility Checker & Fixer","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/a11yfy-pdf-accessibility-checker-fixer/"}}