From b885fe8d0c0f7c7053b998758f84da054e8cfc6a Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 03 四月 2023 13:42:11 +0800
Subject: [PATCH] 1

---
 data/db_cx.sql |    7 ++-----
 1 files changed, 2 insertions(+), 5 deletions(-)

diff --git a/data/db_cx.sql b/data/db_cx.sql
index 142566a..541f67a 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -17,11 +17,8 @@
 select * from lf.sys_meta where name='鍕樻帰鐐瑰湴灞傝〃.xlsx' or type='fbx'
 --delete from bs.s_explorationpointstratum where parentid in (select eventid from lf.sys_meta where name='鍕樻帰鐐瑰湴灞傝〃.xlsx');
 --delete from lf.sys_meta where name='鍕樻帰鐐瑰湴灞傝〃.xlsx';
-
-select * from lf.sys_attach where tab = 'bs.s_explorationpoint' and tab_guid in (select eventid from bs.s_explorationpoint where gid > 1)
-select * from lf.sys_attach where tab != 'bd.b_borehole'
-select * from lf.sys_publish
-
+select * from lf.sys_meta where 
+type = 'tif' or type = 'tiff' or lower(name) in ('骞抽潰鍥剧储寮曟枃浠�.xlsx', '绌胯法瓒婂湴褰㈠浘.dwg', '涓嚎鎴愭灉琛�.xlsx', '绂绘暎鐐�.xlsx', '鎺у埗鐐�.xlsx', '鍦伴潰绾�.xlsx')
 
 
 

--
Gitblit v1.9.3