From 43870ea90711808e22f99c460821f98a4de7a60c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 29 六月 2023 09:23:16 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 24 +++---------------------
1 files changed, 3 insertions(+), 21 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 006c9e6..d51eef4 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -9,6 +9,7 @@
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 fn_get_fullname(depcode, 1) "m1", cast(sum(sizes) as decimal(18, 3)) "sizes" from lf.sys_meta group by depcode order by depcode;
select fn_get_fullname(code, 2) from lf.sys_dir where code='0A05'; -- 鏌ヨ瀹屾暣璺緞
+select * from lf.sys_token where token ='c36e4f94-dfde-401e-9967-2c4a449f1300'; -- FME
-- 鍒犻櫎鍐椾綑鏁版嵁锛屼慨澶峵ab_guid鍊�
select id,name,path,tab,tab_guid from lf.sys_attach where tab != 'bd.b_borehole' order by id desc limit 200;
@@ -34,7 +35,6 @@
select * from lf.sys_ars;
select * from lf.sys_report;
--- ALL -> 560, type=2 -> 442, WMS -> 340, url=null -> 77, type=2 & url -> 25, .json -> 17
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;
@@ -47,28 +47,10 @@
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;
-- update lf.sys_publish a set url = replace(url, '192.168.20.205:80', '{host}') where position('192.' in url) > 0;
-
-select * from bs.s_explorationpoint where createtime < '2023-05-26 10:00:00';
-select * from bs.s_surveyworksite where createtime < '2023-05-26 10:00:00';
-select * from lf.sys_meta where type='cpt';
-select id,name,code from lf.sys_dir where pid=0 order by code
-
-select * from bs.dlg_resnt2000;
-alter table bs.dlg_resnt2000 alter column floors type varchar(20);
-select * from lf.sys_layer l where cn_name='鍊炬枩鎽勫奖鏁版嵁';
-
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
--- update lf.sys_layer set is_project = 1 where id between 8 and 299;
-update lf.sys_layer set is_project = null where id between 8 and 299 and type = 1;
-select id, pid, type, cn_name, en_name, url, serve_type, data_type, elev, pubid, is_project, bak
-from lf.sys_layer where serve_type = 'WMS' order by id;
-select id,uid,uname,pwd from lf.sys_user order by uid;
-select * from lf.sys_meta where type='osgb' order by id desc limit 20;
-
-select * from lf.sys_token where token ='c36e4f94-dfde-401e-9967-2c4a449f1300';
-select * from lf.sys_user where id=61;
-select bak,count(*) from lf.sys_dict group by bak order by bak;
+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
--
Gitblit v1.9.3