wp_fone_jobs
StaticA job queue table for managing background tasks and scheduled operations.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| job_id | BIGINT UNSIGNED | NO |
| q8 | payload | NO |
| error | TEXT | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_fone_jobs` ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, job_id BIGINT UNSIGNED NOT NULL, -- = _facturaone_status_backgroundid seq INT UNSIGNED NOT NULL, -- orden de ejecución task_file VARCHAR(64) NOT NULL, -- p.ej. 'update_productos.php' func VARCHAR(32) NOT NULL, -- 'q2','q3','q4','q5','q6','q7','q8' payload LONGTEXT NOT NULL, -- JSON con el array status TINYINT UNSIGNED NOT NULL DEFAULT 0, -- 0=pending,1=processing,2=done,3=error worker_id VARCHAR(64) DEFAULT NULL, -- quién lo está procesando tries TINYINT UNSIGNED NOT NULL DEFAULT 0, error TEXT DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY job_status_seq (job_id, status, seq), KEY job_status (job_id, status) ) $charset_collate;"; dbDelta($sql);
Safe to delete?
If you have uninstalled FacturaONE para WooCommerce con VeriFactu, 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_fone_jobs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from FacturaONE para WooCommerce con VeriFactu