From 7f1e7ceb7faca00b1d15f9b85eafe7deb70708f9 Mon Sep 17 00:00:00 2001 From: gongchunyi <deslre0381@gmail.com> Date: 星期四, 11 六月 2026 19:30:35 +0800 Subject: [PATCH] docs: 生产领料小数点更新sql --- doc/河南-鹤壁.sql | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git "a/doc/\346\262\263\345\215\227-\351\271\244\345\243\201.sql" "b/doc/\346\262\263\345\215\227-\351\271\244\345\243\201.sql" new file mode 100644 index 0000000..d3f9ccf --- /dev/null +++ "b/doc/\346\262\263\345\215\227-\351\271\244\345\243\201.sql" @@ -0,0 +1,15 @@ +-- 鏇存敼 production_order_pick + +ALTER TABLE `production_order_pick` + MODIFY COLUMN `quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '鏁伴噺' AFTER `product_model_id`, + MODIFY COLUMN `demanded_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '闇�姹傛暟閲�' AFTER `technology_operation_id`, + MODIFY COLUMN `feeding_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '琛ユ枡鎬婚噺' AFTER `is_returned`, + MODIFY COLUMN `return_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '閫�鏂欐暟閲�' AFTER `feeding_qty`, + MODIFY COLUMN `actual_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '瀹為檯鏁伴噺' AFTER `return_qty`; + +-- 鏇存敼 production_order_pick_record + +ALTER TABLE `production_order_pick_record` + MODIFY COLUMN `pick_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '棰嗘枡鏁伴噺' AFTER `batch_no`, + MODIFY COLUMN `before_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '棰嗘枡鍓嶆暟閲�' AFTER `pick_quantity`, + MODIFY COLUMN `after_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '棰嗘枡鍚庡墿浣欐暟閲�' AFTER `before_quantity`; -- Gitblit v1.9.3