From df5675b4e548eff2dbab6c780b173c346551f508 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周五, 19 9月 2025 11:38:33 +0800
Subject: [PATCH] 修复bug
---
siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 55 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 7ff15f6..d940386 100644
--- a/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
+++ b/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
@@ -255,4 +255,59 @@
GO
+use YrtWMS_Siemens2;
+go
+
+/*==============================================================*/
+/* Table: Purchase_OrderList_EmptyMaterialCode */
+/* Description: PO鏄庣粏绌虹墿鏂欏彿琛� */
+/* Author:shaocx */
+/* CreateTime:2025-09-09 */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('Purchase_OrderList_EmptyMaterialCode') AND TYPE = 'U')
+create table Purchase_OrderList_EmptyMaterialCode (
+ ID bigint NOT NULL, -- 涓婚敭
+
+ PoCode nvarchar(50) null,-- 閲囪喘鍗曞彿
+ ProductName nvarchar(500) null,-- 鐗╂枡鍚嶇О
+ Quantity decimal null, -- 鏁伴噺
+ ItemNumber nvarchar(50) null,-- 椤瑰彿
+ BatchNumber nvarchar(50) null,-- 鎵规鍙�
+
+ Remark nvarchar(2000) null, -- 澶囨敞
+
+ Creator varchar(128) null,-- 鍒涘缓浜�
+ CreateTime datetime null,-- 鍒涘缓鏃堕棿
+ LastModifier varchar(128) null,-- 淇敼浜�
+ LastModifyTime datetime null -- 淇敼鏃堕棿
+
+ constraint PK_Purchase_OrderList_EmptyMaterialCode_Id primary key (ID)
+)
+GO
+
+
+
+-- 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