From 754a8998388e0252919f833007b65e072312f0b7 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期二, 21 三月 2023 09:56:31 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 19 ++++++++++++++++---
1 files changed, 16 insertions(+), 3 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index b1de64d..289835a 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -37,6 +37,7 @@
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;
insert into lf.sys_layer (pid, cn_name, en_name, url, type, level, order_num, is_show, create_user, data_type) values
((select coalesce(id, 0) from lf.sys_layer where cn_name = '鑷姩鍙戝竷妯″瀷' limit 1), '妯″瀷', 'model', 'http://', 2,
@@ -45,10 +46,22 @@
select * from bs.s_explorationpoint
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_token order by id limit 10
+select * from lf.sys_meta where id in (1523,1525)
-select * from lf.sys_meta where name like '%shp%'
-delete from lf.sys_meta where guid in ('20e9c84639279604e9539f8003a49747','44bb08c1a69b7ba2b3a8096e22d067f3','d1da4cc853172da980dd36e9d8e26b24')
+-- http://{host}/LFData/3d/3dtiles/rvt/1521/tileset.json
+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;
+
+
+
+
+
+
+
+
+
+
--
Gitblit v1.9.3