From deff787716b00b4f491de429ba092915d7fa1a9e Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期五, 27 三月 2026 13:07:05 +0800
Subject: [PATCH] 过程检数据查询+原有生产订单表增加产品规格id

---
 doc/宁夏-中盛建材.sql |    5 ++++-
 1 files changed, 4 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 f91a888..f16e44e 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"
@@ -414,4 +414,7 @@
 
 DROP TABLE IF EXISTS process_route_item_instance;
 DROP TABLE IF EXISTS process_route_item_param_instance;
-DROP TABLE IF EXISTS product_structure_instance;
\ No newline at end of file
+DROP TABLE IF EXISTS product_structure_instance;
+
+ALTER TABLE `product-inventory-management-zsjc`.`production_product_route_item_param`
+    MODIFY COLUMN `order_item_param_id` bigint NULL DEFAULT NULL COMMENT '鐢熶骇璁㈠崟缁戝畾鐨勫伐鑹鸿矾绾垮伐搴�--鍙傛暟琛↖D' AFTER `production_product_route_item_id`;
\ No newline at end of file

--
Gitblit v1.9.3