From 664a30f7ff0bc0206961b40247d41d28377ed09d Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期四, 13 四月 2023 12:45:31 +0800 Subject: [PATCH] 1 --- data/db_cx.sql | 25 +++++++++++++++++++------ 1 files changed, 19 insertions(+), 6 deletions(-) diff --git a/data/db_cx.sql b/data/db_cx.sql index 99beea0..8d502fd 100644 --- a/data/db_cx.sql +++ b/data/db_cx.sql @@ -18,13 +18,26 @@ select * from lf.sys_apply order by id desc; select * from lf.sys_flow order by id desc; select * from lf.sys_meta order by id desc; -select depcode from lf.sys_meta where id in (1393,1392,1383,1382) and depcode not like '000305%' group by depcode order by depcode; -select * from lf.sys_user where id=1 -select * from lf.sys_meta where id in (1393,1392,1383,1382) --- tabs=鍏冩暟鎹〃,entities=sysmeta,gids=1393,1392,1383,1382 - select * from lf.sys_layer order by id desc; -select * from bs.s_explorationpoint order by gid desc; +update lf.sys_dir set name='娴嬬粯锛圗SV锛�' where name='娴嬮噺锛圗SV锛�'; + +select id from lf.sys_layer where cn_name = '涓夌淮鍦拌川妯″瀷' and pid = (select id from lf.sys_layer where cn_name = '鍕樺療' order by pid limit 1); + +select id from lf.sys_layer where cn_name = '鍗曚綋妯″瀷' and pid = (select id from lf.sys_layer where cn_name = '娴嬬粯' order by pid limit 1); +select id from lf.sys_layer where cn_name = '鏁板瓧姝ｅ皠褰卞儚鍥�' and pid = (select id from lf.sys_layer where cn_name = '娴嬬粯' order by pid limit 1); +select id from lf.sys_layer where cn_name = '涓夌淮鍦板舰妯″瀷' and pid = (select id from lf.sys_layer where cn_name = '娴嬬粯' order by pid limit 1); + +select id from lf.sys_layer where cn_name = '涓夌淮鍦拌川妯″瀷' and pid = (select id from lf.sys_layer where cn_name = '鍦扮伨' order by pid limit 1); + +select id from lf.sys_layer where cn_name = '娲炲簱妯″瀷' and pid = (select id from lf.sys_layer where cn_name = '娲炲簱' order by pid limit 1); + +select id from lf.sys_layer where cn_name = '鍏朵粬' and pid = (select id from lf.sys_layer where cn_name = '宸ョ▼鏁版嵁' order by pid limit 1); + +insert into lf.sys_layer (pid, cn_name, en_name, url, type, level, order_num, is_show, create_user, data_type, serve_type, pubid, elev) values +(@pid, @cnName, @enName, @url, 2, (select coalesce(level, 0) + 1 from lf.sys_layer where id = @pid), (select coalesce(max(order_num), 0) + 1 from lf.sys_layer where pid = @pid), 0, @user, @name, @serve, @pubid, @elev) + +select fn_get_fullname(dircode, 2) from lf.sys_meta where id = 1407 + -- Gitblit v1.9.3