{"slug":"wp-facturaone","name":"FacturaONE para WooCommerce con VeriFactu","description":"Conecta WooCommerce con FacturaONE ERP para sincronizar productos, pedidos, stock y facturación con VeriFactu y TicketBAI.","author":"facturaone","active_installs":40,"version":"5.39","wp_org_url":"https://wordpress.org/plugins/wp-facturaone/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"fone_item_clients","full_table_name":"wp_fone_item_clients","description":"Stores fone item clients data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"item_client_id","type":"INT(11)","nullable":false,"primary_key":true},{"name":"item_create_date","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"client_id","type":"INT(1)","nullable":false,"primary_key":false},{"name":"item_lookup_id","type":"INT(1)","nullable":false,"primary_key":false},{"name":"item_client_price","type":"DECIMAL(20,4)","nullable":false,"primary_key":false},{"name":"item_tax_rate_id","type":"INT(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_fone_item_clients` ( `item_client_id` INT(11) NOT NULL AUTO_INCREMENT, `item_create_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `client_id` INT(1) NOT NULL DEFAULT '0', `item_lookup_id` INT(1) NOT NULL DEFAULT '0', `item_client_price` DECIMAL(20,4) NOT NULL DEFAULT '0.0000', `item_tax_rate_id` INT(11) NULL DEFAULT '0', PRIMARY KEY (`item_client_id`) USING BTREE, UNIQUE INDEX `client_id_item_lookup_id` (`client_id`, `item_lookup_id`) USING BTREE ) \".$charset_collate.\" ENGINE=InnoDB AUTO_INCREMENT=1; \"; dbDelta( $sql );"},{"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","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}],"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);"},{"table_name":"wc_product_meta_lookup","full_table_name":"wp_wc_product_meta_lookup","description":"Stores additional metadata (key-value pairs) for wc product meta lookup records.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":3}