{"table_name":"fone_jobs","full_table_name":"wp_fone_jobs","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","create_sql":"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);","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"job_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"q8","type":"payload","nullable":false,"primary_key":false},{"name":"error","type":"TEXT","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}],"plugin":{"slug":"wp-facturaone","name":"FacturaONE para WooCommerce con VeriFactu","active_installs":40,"version":"5.39","wp_org_url":"https://wordpress.org/plugins/wp-facturaone/"}}