From beb0fc04f59f4f448e70d8de9ae39161632de2fb Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期四, 03 七月 2025 11:22:28 +0800
Subject: [PATCH] 2025-07-01 添加设备维修保养的设备名称合型号字段
---
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