From eaaf1e7f6bcbae2e7152db7ea996d4d98d7b036e Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 03 七月 2023 14:54:02 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 20 +++++++-------------
1 files changed, 7 insertions(+), 13 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index aca2bc4..ea8853f 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -15,25 +15,23 @@
select id,name,path,tab,tab_guid from lf.sys_attach where tab != 'bd.b_borehole' order by id desc limit 200;
--delete from bs.s_explorationpointstratum where parentid in (select eventid from lf.sys_meta where name='鍕樻帰鐐瑰湴灞傝〃.xlsx');
select * from lf.sys_meta where type = 'tif' or type = 'tiff' or lower(name) in ('骞抽潰鍥剧储寮曟枃浠�.xlsx', '绌胯法瓒婂湴褰㈠浘.dwg', '涓嚎鎴愭灉琛�.xlsx', '绂绘暎鐐�.xlsx', '鎺у埗鐐�.xlsx', '鍦伴潰绾�.xlsx');
-
--- delete from lf.sys_apply where id > 47; delete from lf.sys_flow where applyid > 47;
+
select * from lf.sys_layer where is_project=1 order by id desc;
select * from lf.sys_layer order by id desc;
select a.*,st_astext(geom) from lf.sys_publish a order by id desc;
-select * from lf.sys_meta_pub order by id desc;
+select * from lf.sys_meta_pub where metaid = 10516 order by id desc;
select * from lf.sys_download order by id desc limit 20; --downid
select * from lf.sys_apply order by id desc;
select * from lf.sys_flow order by id desc;
select * from lf.sys_meta where type='las' order by id desc limit 100;
select * from lf.sys_fme_log order by id desc;
-select * from lf.sys_pub_down order by id desc;
select * from lf.sys_dir where pid = 0 order by id;
select * from lf.sys_dict order by id desc;
-select * from lf.sys_meta where type in ('3dml');
-select * from lf.sys_ars;
+select * from lf.sys_meta where id = 10516;
select * from lf.sys_report;
+select * from lf.sys_publish where type = 'cpt';
+select * from lf.sys_meta_pub where pubid = 132;
-select serve_type from lf.sys_layer group by serve_type;
update lf.sys_layer set serve_type = null where type = 2;
update lf.sys_layer set serve_type = 'WMS' where type = 2 and position('LF:' in url) > 0;
update lf.sys_layer set serve_type = '3DML' where type = 2 and serve_type is null and position('b3dm' in url) > 0;
@@ -43,15 +41,11 @@
update lf.sys_layer set serve_type = 'DEM' where type = 2 and serve_type is null and position('terrain/' in url) > 0;
select id, pid, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak
-from lf.sys_layer where type = 2 and serve_type is not null order by id;
+from lf.sys_layer where type = 2 and serve_type='WMS' order by id;
-- update lf.sys_publish a set url = replace(url, '192.168.20.205:80', '{host}') where position('192.' in url) > 0;
select id, pid, type, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak from lf.sys_layer order by id; -- 8-299
-select * from lf.sys_meta where type='xlsx' order by id desc limit 20;
-select * from lf.sys_dict where tab_desc in('鍦拌〃褰㈠彉鏁版嵁鏃跺簭琛�','宕╁') order by id; -- m_surface_deformation_data_date
-select count(*) from bd.b_hy20w_s11 where 1=1 and (dirid like '0B%');
-
-
+select id,name,url,path,type,dirid from lf.sys_publish where position('/SG/' in url) > 0 order by type;
--
Gitblit v1.9.3