| version/边锋数据库改动20230526/入库修改sql.txt | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
version/±ß·æÊý¾Ý¿â¸Ä¶¯20230526/Èë¿âÐÞ¸Äsql.txt
New file @@ -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
