From f2beaeeb5a1811dbc38b386d7a5b5d0f9c8c6f7c Mon Sep 17 00:00:00 2001
From: 王佳豪 <g675230687@126.com>
Date: 星期五, 12 三月 2021 08:42:25 +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