From 9be9c3784b2881a3fa25e93ae2033dc2803c0ed0 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周五, 19 9月 2025 08:59:51 +0800 Subject: [PATCH] 优化查询 --- siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql | 24 ++++++++++++++++++++++++ 1 files changed, 24 insertions(+), 0 deletions(-) diff --git a/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql b/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql index 38ae33c..d940386 100644 --- a/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql +++ b/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql @@ -287,3 +287,27 @@ +-- YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail definition + +-- Drop table + +-- DROP TABLE YrtWMS_Siemens2.deviceGeneralInfoForDetail; + +CREATE TABLE YrtWMS_Siemens2.dbo.deviceGeneralInfoForDetail ( + id int IDENTITY(1,1) NOT NULL, + taskEnterCount int NULL, + taskOutCount int NULL, + stockProportion int NULL, + outDate int NULL, + deviceRunTime decimal(18,0) NULL, + deviceWaitTime decimal(18,0) NULL, + deviceAlarmTime decimal(18,0) NULL, + createTime datetime NULL, + ext1 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + ext2 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + ext3 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + ext4 nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL, + CONSTRAINT PK_deviceGeneralInfoForDetail PRIMARY KEY (id) +); + + -- Gitblit v1.9.3