From 55828b0389182ac0e0e20636bf2714f32271883c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 29 五月 2023 17:00:05 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 8 +++++---
1 files changed, 5 insertions(+), 3 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 44a8183..8cfb38e 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -7,6 +7,7 @@
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);
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;
-- 鍒犻櫎鍐椾綑鏁版嵁锛屼慨澶峵ab_guid鍊�
select id,name,path,tab,tab_guid from lf.sys_attach where tab != 'bd.b_borehole' order by id desc limit 200;
@@ -48,9 +49,10 @@
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';
+--delete from bs.s_explorationpoint where dirid in ('00','04');
+select * from bs.s_surveyworksite where createtime < '2023-05-26 10:00:00';
+--delete from bs.s_surveyworksite where createtime < '2023-05-26 10:00:00';
--
Gitblit v1.9.3