From ecfcf7efdba7aee5805263ed9c2b290519f56248 Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期五, 26 五月 2023 08:58:07 +0800
Subject: [PATCH] 数据库改动
---
version/边锋数据库改动20230526/入库修改sql.txt | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git "a/version/\350\276\271\351\224\213\346\225\260\346\215\256\345\272\223\346\224\271\345\212\25020230526/\345\205\245\345\272\223\344\277\256\346\224\271sql.txt" "b/version/\350\276\271\351\224\213\346\225\260\346\215\256\345\272\223\346\224\271\345\212\25020230526/\345\205\245\345\272\223\344\277\256\346\224\271sql.txt"
new file mode 100644
index 0000000..c2e024d
--- /dev/null
+++ "b/version/\350\276\271\351\224\213\346\225\260\346\215\256\345\272\223\346\224\271\345\212\25020230526/\345\205\245\345\272\223\344\277\256\346\224\271sql.txt"
@@ -0,0 +1,7 @@
+man_mat琛� mat_type int 鐗╂枡绫诲瀷{1:鍗曞搧,2:楂橀,3:娣锋斁}
+cust_wait_pakin琛� mat_type int 鐗╂枡绫诲瀷{1:鍗曞搧,2:楂橀,3:娣锋斁}
+cust_wait_pakin_log琛� mat_type int 鐗╂枡绫诲瀷{1:鍗曞搧,2:楂橀,3:娣锋斁}
+
+update asr_loc_mast set loc_type2 = 1 where row1 not in (3,4,11,12,18,19) and bay1 < 21
+update asr_loc_mast set loc_type2 = 2 where row1 in (3,4,11,12,18,19) and bay1 < 21
+update asr_loc_mast set loc_type2 = 3 where row1 >= 1 and bay1 >= 21
\ No newline at end of file
--
Gitblit v1.9.1