{"table_name":"ftbai_facturas","full_table_name":"wp_ftbai_facturas","description":"Stores ftbai facturas data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_ftbai_facturas` ( `id_transaccion` INT(11) NOT NULL AUTO_INCREMENT, `user_dni` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `user_apikey` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `fecha_transaccion` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `pedido_numero` INT(11) NOT NULL DEFAULT '0', `pedido_fecha` DATETIME NOT NULL, `factura_estado` VARCHAR(20) NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_tipo` VARCHAR(20) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_rectificada_en` INT(11) NOT NULL DEFAULT '0', `factura_rectificativa_de` INT(11) NOT NULL DEFAULT '0', `factura_vista` DATETIME NOT NULL, `factura_serie` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_numero` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `factura_fecha` DATETIME NOT NULL, `factura_total` DECIMAL(20,4) NOT NULL DEFAULT '0.0000', `cliente_nombre` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `cliente_nif` VARCHAR(20) NULL DEFAULT '' COLLATE 'utf8_general_ci', `tbai_num` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8_general_ci', `tbai_qr` VARCHAR(250) NULL DEFAULT '' COLLATE 'utf8_general_ci', PRIMARY KEY (`id_transaccion`, `user_dni`, `user_apikey`) USING BTREE ) \".$charset_collate.\" ENGINE=InnoDB AUTO_INCREMENT=1; \"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );","columns":[{"name":"id_transaccion","type":"INT(11)","nullable":false,"primary_key":true},{"name":"user_dni","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"user_apikey","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"fecha_transaccion","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"pedido_numero","type":"INT(11)","nullable":false,"primary_key":false},{"name":"pedido_fecha","type":"DATETIME","nullable":false,"primary_key":false},{"name":"factura_estado","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"factura_tipo","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"factura_rectificada_en","type":"INT(11)","nullable":false,"primary_key":false},{"name":"factura_rectificativa_de","type":"INT(11)","nullable":false,"primary_key":false},{"name":"factura_vista","type":"DATETIME","nullable":false,"primary_key":false},{"name":"factura_serie","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"factura_numero","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"factura_fecha","type":"DATETIME","nullable":false,"primary_key":false},{"name":"factura_total","type":"DECIMAL(20,4)","nullable":false,"primary_key":false},{"name":"cliente_nombre","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"cliente_nif","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"tbai_num","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"tbai_qr","type":"VARCHAR(250)","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-ticketbai","name":"TicketBAI Facturas para WooCommerce","active_installs":70,"version":"3.47","wp_org_url":"https://wordpress.org/plugins/wp-ticketbai/"}}