From 70ddec6cf736c0174bafaef0a9bfe4c9412af133 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 25 三月 2023 16:37:32 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 35 +++++------------------------------
1 files changed, 5 insertions(+), 30 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 521d5f3..1207dfd 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -4,41 +4,16 @@
select * from lf.sys_layer where url is not null and serve_type='WMS' and data_type in ('宸ョ▼椤圭洰','宸ョ▼椤圭洰-鍦扮伨绫�','宸ョ▼椤圭洰-娴嬮噺绫�','宸ョ▼椤圭洰-娲炲簱绫�','宸ョ▼椤圭洰-鍕樺療绫�') order by id;
insert into lf.sys_layer (pid,cn_name,en_name,url,type,level,order_num,is_show,create_user,serve_type,data_type,elev) values
(423, '鍦伴潰灞�', 'fushun_site', 'tileset/o/39HBFG/tileset.json', 2, 3, 5, 0, 1, 'Tileset', '宸ョ▼娴嬮噺妯″瀷', 1200);
-update lf.sys_layer set elev=118,cn_name='鍦伴潰灞�' where id=427;
-
select concat(gb, '_', name) from bd.dlg_agnp limit 10;
-select a.*, fn_uname(create_user) createName, fn_uname(update_user) updateName from lf.sys_dict a limit 10
-select * from lf.sys_download where position('绠￠亾鍩虹澶ф暟鎹钩鍙�' in descr)>0 order by id desc;
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
--- 娣诲姞鑺傜偣
-alter table lf.sys_layer add column pubid integer;
-insert into lf.sys_layer (pid,cn_name,en_name,type,level,order_num,is_show,create_user,data_type) values (0,'褰卞儚','img',1,1,3,0,1,'褰卞儚鏁版嵁');
-insert into lf.sys_layer (pid,cn_name,en_name,type,level,order_num,is_show,create_user,data_type) values (430,'鑷姩鍙戝竷妯″瀷','auto_model',1,2,25,0,1,'鑷姩鍙戝竷妯″瀷');
-select * from lf.sys_layer order by id desc limit 20;
-
-select * from lf.sys_attach where tab = 'bs.s_explorationpoint' and tab_guid in (select eventid from bs.s_explorationpoint where exppointid = '001')
-select * from lf.sys_meta where id in (1523,1525)
-
--- update lf.sys_meta set path = '1\' || guid || '.' || type where id in (1523, 1525);
-select * from lf.sys_publish; -- delete from lf.sys_publish
-select * from lf.sys_meta_pub; -- delete from lf.sys_meta_pub
-select * from lf.sys_layer order by id desc limit 20; -- delete from lf.sys_layer where id > 441;
-
-select coalesce(max(order_num), 0) + 1 from lf.sys_layer where pid = (select id from lf.sys_layer where cn_name = '鑷姩鍙戝竷妯″瀷' limit 1);
-select * from lf.sys_meta where id in (1523,1529,1525);
-
-select * from lf.sys_publish order by id desc
-select * from lf.sys_meta_pub order by id desc
-select * from lf.sys_layer order by id desc limit 10
-select * from lf.sys_meta where name='鍕樻帰鐐硅〃.xlsx'
+select * from lf.sys_fme_log order by id desc limit 10; -- 236
+select * from lf.sys_meta order by id desc limit 10; -- 1686 > 1696
select * from lf.sys_fme_log
---where tcdm='u_sectionline'
-order by id desc;
-
-
-
+where count > 0 and update_time is null and
+position(tcdm in 'bd.b_pac_hydrogeology,bd.b_pac_frozensoil,bd.b_pac_geologic_hazard,bd.b_pac_marine_meteorological,bd.b_pac_meteorological,bs.m_equipment_nameplate,bs.m_hydraulic_protection,bs.m_marker,bs.s_explorationpoint,bs.u_sectionline') > 0
+ --and create_time > now()::timestamp + '-1 min'
--
Gitblit v1.9.3