From db5338c2246acbc0826a9b683392512cf00eba04 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期日, 26 三月 2023 09:11:32 +0800
Subject: [PATCH] 1

---
 data/db_cx.sql |   20 ++++++--------------
 1 files changed, 6 insertions(+), 14 deletions(-)

diff --git a/data/db_cx.sql b/data/db_cx.sql
index 418a8ba..371299b 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -7,23 +7,15 @@
 select concat(gb, '_', name) from bd.dlg_agnp limit 10;
 select ST_AsText(geom) "geom", a.*, fn_get_fullname(a.depid, 1) depName, fn_get_fullname(a.dirid, 2) dirName, fn_uname(create_user) createName, fn_uname(update_user) updateName from lf.sys_publish a
 
-select * from lf.sys_fme_log order by id desc limit 10; -- 255 > 
-select * from lf.sys_meta order by id desc limit 10; -- 1723 > 
+-- 鍒犻櫎鍐椾綑鏁版嵁锛屼慨澶峵ab_guid鍊�
+select id,name,path,tab,tab_guid from lf.sys_attach where tab != 'bd.b_borehole' order by id desc limit 200; 
 
-select * from lf.sys_fme_log
-where count > 0 and update_time is null and create_time > now()::timestamp + '-1 min'
-select * from bs.s_explorationpoint where parentid='df3ee967-3eb8-4685-b49c-d0ae06918069'
-select * from lf.sys_dir where pid=0 order by id
+select * from lf.sys_fme_log order by id desc limit 15; -- 255 > 
+select * from lf.sys_meta order by id desc limit 15; -- 1723 > 
+select * from lf.sys_attach where tab != 'bd.b_borehole' order by id desc limit 50; -- 358042
+select * from lf.sys_meta where tab is not null order by id desc
 
-select * from bs.s_explorationpoint
-select * from lf.sys_attach order by id desc limit 100; -- 358042
 
-insert into lf.sys_attach (name, guid, path, sizes, create_user, tab, tab_guid)
-select name, guid, path, sizes, create_user, 'bs.s_explorationpoint', '8de99768-1da3-4784-9423-bb026411fa48'
-from lf.sys_meta
-where name = 'PH02T01-CR004-C04#EGE-DW-0105.pdf' and create_time > now()::timestamp + '-10 min'
-order by id desc
-limit 1;
 
 
 

--
Gitblit v1.9.3