ALTER TABLE `vitex`.`nota_bodega` DROP INDEX `order_text`, ADD INDEX `order_text` (`bodega_id`, `numero_order_text`, `numero`, `tipo`, `ano`, `entrada_salida`) USING BTREE;

ALTER TABLE nota_bodega_verificacion ADD COLUMN ano int GENERATED ALWAYS AS (YEAR(fecha)), ADD COLUMN mes int GENERATED ALWAYS AS (MONTH(fecha));

