From 93daa0916a6d76275886e704f6735cb91c3baf4e Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期三, 01 四月 2026 10:51:29 +0800
Subject: [PATCH] feat: 生产成本核算功能接口
---
doc/宁夏-中盛建材.sql | 20 +++++++++++++++++++-
1 files changed, 19 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 3593ec5..67f4c6f 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"
@@ -510,4 +510,22 @@
KEY `idx_batch_id` (`batch_id`),
KEY `idx_product_id` (`product_id`) COMMENT '鏂逛究鎸変骇鍝佹煡璇㈠巻鍙叉垚鏈姣�'
) ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4 COMMENT ='鐢熶骇鎴愭湰鏍哥畻瀵规瘮鏄庣粏琛�';
\ No newline at end of file
+ DEFAULT CHARSET = utf8mb4 COMMENT ='鐢熶骇鎴愭湰鏍哥畻瀵规瘮鏄庣粏琛�';
+
+ALTER TABLE `product-inventory-management-zsjc`.`production_settlement_batches`
+ DROP INDEX `idx_period`;
+
+ALTER TABLE `product-inventory-management-zsjc`.`production_settlement_batches`
+ DROP COLUMN `batch_name`,
+ DROP COLUMN `status`;
+
+ALTER TABLE `product-inventory-management-zsjc`.`production_settlement_details`
+ DROP COLUMN `actual_qty`,
+ DROP COLUMN `actual_price`,
+ DROP COLUMN `actual_total`,
+ DROP COLUMN `diff_qty`,
+ DROP COLUMN `diff_price`,
+ 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
--
Gitblit v1.9.3