From da3528953feea71e85a8e6d2ccdd56d423e4f6e3 Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期二, 09 三月 2021 10:16:26 +0800
Subject: [PATCH] 1.0.4 库物料状态维护-新增待检状态的物料查询

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

diff --git a/version/version/wjh.sql b/version/version/wjh.sql
index f97db7a..3a44f95 100644
--- a/version/version/wjh.sql
+++ b/version/version/wjh.sql
@@ -21,9 +21,17 @@
 	[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]

--
Gitblit v1.9.1