From 1f81840839e868b5a0c9689e78767ff97b683e4e Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期二, 08 七月 2025 11:07:58 +0800
Subject: [PATCH] yys 1.新增入库查询 2.新增入库 3.入库分页查询 4.编辑
---
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