From 3f9b7886fa35a79db3ff2a5f47bd44214f5202e0 Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期六, 13 三月 2021 15:22:35 +0800
Subject: [PATCH] 1.0.3 pda关联嘱托-隐藏物料名称，显示生成单号，并传入生成单号，组托根据（物料编号+生成单号+通知单号）判断唯一性

---
 version/version/wjh.sql |   22 +++++++++++++++++-----
 1 files changed, 17 insertions(+), 5 deletions(-)

diff --git a/version/version/wjh.sql b/version/version/wjh.sql
index f97db7a..487a86c 100644
--- a/version/version/wjh.sql
+++ b/version/version/wjh.sql
@@ -21,9 +21,21 @@
 	[modi_time] [datetime] NULL,
 	[appe_user] [bigint] NULL,
 	[appe_time] [datetime] NULL,
-	[state] [varchar](10) NULL,
- CONSTRAINT [PK_asr_loc_normal] PRIMARY KEY CLUSTERED
-(
-	[matnr] ASC
-)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+	[state] [varchar](10) NULL
 ) ON [PRIMARY]
+
+CREATE TABLE [dbo].[asr_loc_area](
+	[id] [bigint] IDENTITY(1,1) NOT NULL,
+	[uuid] [varchar](50) NULL,
+	[name] [varchar](255) NULL,
+	[status] [int] NULL,
+	[create_by] [bigint] NULL,
+	[create_time] [datetime] NULL,
+	[update_by] [bigint] NULL,
+	[update_time] [datetime] NULL,
+	[memo] [varchar](255) NULL
+) ON [PRIMARY]
+
+/* v1.0.3 2021.03.11 */
+--琛ㄧ粨鏋勫彉鏇�
+alter table asr_loc_normal add id int identity(1,1)
\ No newline at end of file

--
Gitblit v1.9.1