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 | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/doc/add.sql b/doc/add.sql
index 2980a2f..35b95ae 100644
--- a/doc/add.sql
+++ b/doc/add.sql
@@ -63,3 +63,22 @@
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