From 6bfa6ba153338df9e17eb5fcda4ecfc20e88ceca Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期三, 08 四月 2026 15:34:47 +0800
Subject: [PATCH] fix: 报工工序上传的图片预览
---
doc/宁夏-中盛建材.sql | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql" "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
index 67f4c6f..1164c9f 100644
--- "a/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
+++ "b/doc/\345\256\201\345\244\217-\344\270\255\347\233\233\345\273\272\346\235\220.sql"
@@ -528,4 +528,12 @@
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`;
\ No newline at end of file
+ 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`;
\ No newline at end of file
--
Gitblit v1.9.3