From 2a19504209e763a7c0e957e4ee265dd419486ef1 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周五, 06 9月 2024 10:21:48 +0800 Subject: [PATCH] 入库优化 --- DBScript/02_DDL_TABLE_Edit.sql | 28 +++++++++++++++++++++++++++- 1 files changed, 27 insertions(+), 1 deletions(-) diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index 4225b18..e98605c 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -382,4 +382,30 @@ alter table WorkPieceInfo Add UnLineStageName nvarchar(255) alter table WorkPieceInfo Add WorkPieceUnLineTime datetime alter table WorkPieceInfo Add WorkPieceUnLineUserId bigint - alter table WorkPieceInfo Add WorkPieceUnLineUserName nvarchar(255) \ No newline at end of file + alter table WorkPieceInfo Add WorkPieceUnLineUserName nvarchar(255) + + + -- 澧炲姞 瀵瑰垱寤轰汉銆佷慨鏀逛汉鐨勮В閲� [Editby shaocx,2024-08-31] + alter table WorkPieceLog Add DataCapturePointCname nvarchar(255) + alter table WorkPieceLog Add UpdateDataCapturePointCname nvarchar(255) + + + alter table WorkPieceInfo Add DataCapturePointCname nvarchar(255) + alter table WorkPieceInfo Add UpdateDataCapturePointCname nvarchar(255) + + + alter table WorkPieceProcess Add DataCapturePointCname nvarchar(255) + alter table WorkPieceProcess Add UpdateDataCapturePointCname nvarchar(255) + + alter table WorkPieceProcess Add MyRemarks nvarchar(255) -- 鑷垜鎻忚堪鐨勫娉� + + + alter table AccessInterfaceLog Add WorkPieceID nvarchar(255) + alter table AccessInterfaceLog Add WorkingProcedureCurrent nvarchar(255) + + + + alter table WorkPieceLog Add MyRemarks nvarchar(255) -- 鑷垜鎻忚堪鐨勫娉� + + alter table WorkPieceLog Add PieceLogType int + alter table WorkPieceLog Add PieceLogTypeName nvarchar(255) \ No newline at end of file -- Gitblit v1.9.3