From eb34d2f6e8ae329a8094bdb921eafa904c9440db Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周三, 04 9月 2024 13:39:04 +0800 Subject: [PATCH] 11 --- DBScript/01_DDL_TABLE.sql | 33 +++++++++++++++++++++++++++++++++ DBScript/02_DDL_TABLE_Edit.sql | 9 ++++++++- 2 files changed, 41 insertions(+), 1 deletions(-) diff --git a/DBScript/01_DDL_TABLE.sql b/DBScript/01_DDL_TABLE.sql index 6113a1b..1e98921 100644 --- a/DBScript/01_DDL_TABLE.sql +++ b/DBScript/01_DDL_TABLE.sql @@ -243,3 +243,36 @@ EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'璐ㄩ噺鏁版嵁鏍囧噯鍊奸厤缃�' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'EquipmentQualityConfig' GO + + + + +-- [iWare.SCADA].dbo.AccessInterfaceLogForRequest definition + +-- Drop table + +-- DROP TABLE [iWare.SCADA].dbo.AccessInterfaceLogForRequest; + +CREATE TABLE [iWare.SCADA].dbo.AccessInterfaceLogForRequest ( + Id bigint NOT NULL, + [Action] int NOT NULL, + OperateAddress nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, + OperateUserId nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, + OperateUserName nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, + IPAddress nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + Param1 nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, + Param2 nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, + Param3 nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL, + ParaJSON nvarchar(MAX) COLLATE Chinese_PRC_CI_AS NULL, + ResultJson nvarchar(MAX) COLLATE Chinese_PRC_CI_AS NULL, + Keys nvarchar(MAX) COLLATE Chinese_PRC_CI_AS NULL, + CreatedTime datetimeoffset NULL, + UpdatedTime datetimeoffset NULL, + CreatedUserId bigint NULL, + CreatedUserName nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + UpdatedUserId bigint NULL, + UpdatedUserName nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + IsDeleted bit NOT NULL, + WorkPieceID nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL, + WorkingProcedureCurrent nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL +); \ No newline at end of file diff --git a/DBScript/02_DDL_TABLE_Edit.sql b/DBScript/02_DDL_TABLE_Edit.sql index 76a51c1..e98605c 100644 --- a/DBScript/02_DDL_TABLE_Edit.sql +++ b/DBScript/02_DDL_TABLE_Edit.sql @@ -401,4 +401,11 @@ alter table AccessInterfaceLog Add WorkPieceID nvarchar(255) - alter table AccessInterfaceLog Add WorkingProcedureCurrent nvarchar(255) \ No newline at end of file + 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