From dc1ad2b146bd1f66b4f411d02cc920ccc80ec88e Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期六, 10 六月 2023 16:06:04 +0800
Subject: [PATCH] 解决矢量数据批量插入过多时报错
---
data/db_cx.sql | 19 ++-----------------
1 files changed, 2 insertions(+), 17 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 6e53c3e..7ea959a 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -44,28 +44,13 @@
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 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';
---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';
+select * from lf.sys_meta where type='cpt';
-select * from lf.sys_dict where tab='u_sectionline';
-select * from bs.u_sectionline where parentid='5bf5fe98-31a0-4dd9-9fa6-5e6d1570ae00';
-select * from lf.sys_attach;
-select * from lf.sys_dir where pid=0 order by id;
-select * from lf.sys_fme_log where tcdm='u_sectionline' order by id desc;
-select * from lf.sys_meta where name='鍕樻帰鐐硅〃.xlsx' and dircode like '0A%';
-select * from lf.sys_meta where name='宸ョ▼鍦拌川鍓栭潰鍥炬帶鍒剁偣.xlsx';
-select * from lf.sys_fme_log where parentid= '70ca841d-2103-485b-ab10-278cb9df85bd'
-select * from lf.sys_meta where eventid='aa690060-1266-4fd2-bde4-44b9d843948d';
-select * from bs.u_sectionline where parentid='aa690060-1266-4fd2-bde4-44b9d843948d';
---http://192.168.20.205:8088/server/dataQuery/selectFiles?tabName=bs.u_sectionline&eventid=f68f5041-329e-407a-b6ef-deacc8d79910
-select * from lf.sys_attach where tab='bs.u_sectionline' order by id desc;
--
Gitblit v1.9.3