From 10af82e4a5571713c8821ddd319523b89beadd0e Mon Sep 17 00:00:00 2001
From: zss <zss@example.com>
Date: 星期六, 05 七月 2025 16:56:54 +0800
Subject: [PATCH] 质量不合格筛选修改
---
doc/add.sql | 28 +++++++++++++++++++++++++++-
1 files changed, 27 insertions(+), 1 deletions(-)
diff --git a/doc/add.sql b/doc/add.sql
index 359bc49..35b95ae 100644
--- a/doc/add.sql
+++ b/doc/add.sql
@@ -55,4 +55,30 @@
create_user varchar(255) not null comment '褰曞叆浜�',
update_user varchar(255) not null comment '鏇存柊浜�',
tenant_id bigint not null comment '绉熸埛id'
-);
\ No newline at end of file
+);
+
+
+alter table purchase_ledger
+ add payment_method varchar(255) null;
+alter table sales_ledger
+ add payment_method varchar(255) null;
+
+
+alter table payment_registration
+ modify sale_ledger_id bigint default 0 null comment '閿�鍞彴璐d';
+
+
+alter table ticket_registration
+ add enter_date timestamp null;
+
+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