| | |
| | | DROP COLUMN `diff_total`; |
| | | |
| | | ALTER TABLE `product-inventory-management-zsjc`.`production_settlement_batches` |
| | | MODIFY COLUMN `period_time` varchar(255) NULL DEFAULT NULL COMMENT '鏍哥畻褰掑睘骞存湀' AFTER `id`; |
| | | MODIFY COLUMN `period_time` varchar(255) NULL DEFAULT NULL COMMENT '鏍哥畻褰掑睘骞存湀' AFTER `id`; |
| | | |
| | | ALTER TABLE `product-inventory-management-zsjc`.`production_product_route_item_file` |
| | | ADD COLUMN `url` varchar(255) NULL COMMENT '璁块棶鍦板潃' AFTER `file_name`, |
| | | MODIFY COLUMN `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囦欢鍦板潃' AFTER `file_name`; |
| | | |
| | | ALTER TABLE `product-inventory-management-zsjc`.`production_product_route_item_file` |
| | | MODIFY COLUMN `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囦欢瀛樺偍鍦板潃' AFTER `file_name`, |
| | | MODIFY COLUMN `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囦欢璁块棶鍦板潃' AFTER `file_url`; |