From 2b05362eba2f989b7857349cc9a3a1c12f8181b6 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周五, 26 9月 2025 11:35:50 +0800 Subject: [PATCH] 222 --- DBScript/02_DDL_TABLE_Edit.sql | 40 +++++++++++++++++++++++++++++++++++++++- 1 files changed, 39 insertions(+), 1 deletions(-) diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index 4225b18..df42102 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -382,4 +382,42 @@ 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) + + + alter table AccessInterfaceLog Add QualityState int + + + alter table WorkPieceProcess Add Update70Flag int -- 闇�瑕佹洿鏂�70璐ㄩ噺鏁版嵁鐨勬爣璁� 锛� 1锛氶渶瑕佹洿鏂� 2锛氫笉闇�瑕佹洿鏂帮級 + + + alter table WorkPieceProcess Add JiaJuGongWei nvarchar(50) -- 澶瑰叿宸ヤ綅 + + alter table WorkPieceLog Add JiaJuGongWei nvarchar(50) -- 澶瑰叿宸ヤ綅 + \ No newline at end of file -- Gitblit v1.9.3