From 4c35f89a5523eda144e7c4180e8773033ab1edff Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 22 二月 2023 14:31:20 +0800
Subject: [PATCH] 1

---
 data/update.sql |   23 ++++++++++++++---------
 1 files changed, 14 insertions(+), 9 deletions(-)

diff --git a/data/update.sql b/data/update.sql
index f47958d..ca9c676 100644
--- a/data/update.sql
+++ b/data/update.sql
@@ -216,16 +216,19 @@
 select a.*,fn_uname(a.create_user) uname,fn_get_fullname(a.depcode, 1) depName,fn_ver(a.verid) verName,fn_get_fullname(a.dircode, 2) dirName
 from lf.sys_meta a where a.dircode like (select code from lf.sys_dir where name='瑗挎皵涓滆緭鍥涚嚎澶╃劧姘旂閬撳伐绋嬶紙鍚愰瞾鐣�-涓崼锛夛紙00116DT02锛�') || '%';
 
-select * from lf.sys_report order by code
-select * from lf.sys_layer
-select * from lf.sys_meta;
+select a.*, fn_get_fullname(a.code, 2) fullName from lf.sys_dir a where code = '01';
+select * from lf.sys_meta where id = 1420 or metaid = 1420;
+select * from lf.sys_meta order by id desc;
 select a.* from lf.sys_dir a where pid = 0;
-select a.* from lf.sys_dir a where code = '06' order by code;
 
-select a.*, fn_get_fullname(a.code, 2) fullName from lf.sys_dir a where code = '01'
-select count(*) from lf.sys_meta where metaid = 0
-select * from lf.sys_meta where id = 1420 or metaid = 1420
-select * from lf.sys_fme_log order by id desc
+select * from lf.sys_fme_log order by id desc;
+select * from bs.m_sitepoint
+select type from lf.sys_dict where field='verid' group by type;
+
+
+
+
+
 
 
 
@@ -260,7 +263,9 @@
 where dircode like '040000%' or dircode like '0100000000%' or dircode like '02000000%' or dircode like '030000%';
 
 -- 鏁版嵁鐢宠
-select * from lf.sys_apply a inner join lf.sys_user b on a.userid = b.id
+select * from lf.sys_apply a
+inner join lf.sys_user b on a.userid = b.id
+inner join lf.sys_dep c on b.depid = c.id;
 
 -- 璁块棶娆℃暟
 select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;

--
Gitblit v1.9.3