From 179c9d6b6a98292e4e2bec9a01c620d38d13c54a Mon Sep 17 00:00:00 2001 From: zss <zss@example.com> Date: 星期六, 05 七月 2025 16:37:17 +0800 Subject: [PATCH] 质量不合格添加productId字段+删除库存模块代码 --- doc/add.sql | 8 ++++++++ 1 files changed, 8 insertions(+), 0 deletions(-) diff --git a/doc/add.sql b/doc/add.sql index 2d53f4a..35b95ae 100644 --- a/doc/add.sql +++ b/doc/add.sql @@ -74,3 +74,11 @@ alter table product_record add 鍒梍name int null comment 'sale_ledger_projectI_id'; +# 娣诲姞璁惧鍚嶇О鍜岃鏍煎瀷鍙� +ALTER TABLE `product-inventory-management`.`device_repair` + ADD COLUMN `device_name` varchar(255) NULL AFTER `tenant_id`, + ADD COLUMN `device_model` varchar(255) NULL AFTER `device_name`; + +ALTER TABLE `product-inventory-management`.`device_maintenance` + ADD COLUMN `device_name` varchar(255) NULL AFTER `tenant_id`, + ADD COLUMN `device_model` varchar(255) NULL AFTER `device_name`; \ No newline at end of file -- Gitblit v1.9.3