From 3faea5bad90c8e55e8bf83f7a9c603f789ed6c84 Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期五, 10 四月 2026 11:41:46 +0800
Subject: [PATCH] feat: 原料生产统计单耗表接口
---
doc/宁夏-中盛建材.sql | 8 +++++++-
1 files changed, 7 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 1164c9f..afbf1e9 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"
@@ -536,4 +536,10 @@
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
+ MODIFY COLUMN `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囦欢璁块棶鍦板潃' AFTER `file_url`;
+
+ALTER TABLE `product-inventory-management-zsjc`.`product_material_sku`
+ ADD COLUMN `type` int NULL COMMENT '鏁版嵁鏉ユ簮(1-瀹滄惌/2-閽夐拤)' AFTER `update_time`;
+
+ALTER TABLE `product-inventory-management-zsjc`.`customer`
+ ADD COLUMN `type` int NULL COMMENT '鏁版嵁鏉ユ簮(1-瀹滄惌/2-鎵嬪姩鏂板)' AFTER `form_modified_time`;
\ No newline at end of file
--
Gitblit v1.9.3