From f15294cf82b71dfbf75d0821dd8eb13d14a9d936 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期一, 27 二月 2023 16:35:55 +0800 Subject: [PATCH] 1 --- data/update.sql | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/data/update.sql b/data/update.sql index 628100c..1306483 100644 --- a/data/update.sql +++ b/data/update.sql @@ -67,7 +67,7 @@ select * from lf.sys_menu where cn_name = '璧勬簮瀹℃牳'; update lf.sys_menu set url = 'http://10.7.0.186:88/resm/#/resapproval?embed=true&token=' where cn_name = '璧勬簮瀹℃牳'; ---------------------------------------------------------- 鍒濆鍖栨簮鏁版嵁 +--------------------------------------------------------- 鍒濆鍖栧厓鏁版嵁 insert into lf.sys_meta (name,dirid) values ('椤圭洰WBS瀵煎嚭.xlsx',57); insert into lf.sys_meta (name,dirid) values ('00116BT02-CR001#ESV-DW-0101 灏侀潰.docx',62); insert into lf.sys_meta (name,dirid) values ('00116BT02-CR001#ESV-DW-0101锛堝ぇ娌虫部娌崇┛瓒婂湴褰㈠浘锛�0.dwg',62); @@ -107,7 +107,8 @@ update lf.sys_dict set type='integer' where field='updateuser' and type='text'; --------------------------------------------------------- 01 lf.sys_dep -- alter sequence lf.sys_meta_id_seq restart with 1; -update lf.sys_operate set modular2='婧愭暟鎹鐞�' where modular2='鍏冩暟鎹�'; +update lf.sys_operate set modular2='鍏冩暟鎹鐞�' where modular2='婧愭暟鎹鐞�'; +select modular1,modular2 from lf.sys_operate group by modular1,modular2; delete from lf.sys_dep where id = 59; update lf.sys_dep set bak = null where bak = ' '; @@ -222,7 +223,7 @@ -- 鎸夋枃浠剁被鍨嬬粺璁� select type,count(*),sum(sizes) from lf.sys_meta group by type; --- type绫诲瀷锛�1-Shp鏂囦欢锛�2-涓撻鍥撅紝3-婧愭暟鎹紝4-涓氬姟鏁版嵁锛�5-绠¢亾鍒嗘瀽锛�6-缁熻鎶ュ憡 +-- type绫诲瀷锛�1-Shp鏂囦欢锛�2-涓撻鍥撅紝3-鍏冩暟鎹紝4-涓氬姟鏁版嵁锛�5-绠¢亾鍒嗘瀽锛�6-缁熻鎶ュ憡 select * from lf.sys_download; select * from lf.sys_serve_log -- Gitblit v1.9.3