From 06492d128df5d7d0905539dd04faa9d475e9de59 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 13 二月 2023 15:12:59 +0800
Subject: [PATCH] 1
---
data/ts.sql | 41 ++++++++++++-----------------------------
1 files changed, 12 insertions(+), 29 deletions(-)
diff --git a/data/ts.sql b/data/ts.sql
index b52d793..7f2221e 100644
--- a/data/ts.sql
+++ b/data/ts.sql
@@ -106,33 +106,8 @@
-- 瀵嗙爜锛歵est@12345_lf
select * from lf.sys_user where id in (47,48,49);
select * from lf.sys_download;
------------------------------------------------------------------------
+----------------------------------------------------------------------- 缁熻鎶ュ憡
-- alter sequence lf.sys_dict_id_seq restart with 11118;
-select * from bs.m_marker where parentid is not null; -- delete from bs.m_marker; createtime
-select * from bs.m_hydraulic_protection;
-
-insert into lf.sys_fme_log (pg_ns,tcdm,create_time) values ('bs','m_marker',20230206132933); delete lf.sys_fme_log where id = 99;
-select * from lf.sys_meta where type in ('xls', 'xlsx') and eventid is not null and tab is not null and rows > 0 and id in (1209,1180,1387);
-select * from lf.sys_attach order by id desc;
-select * from lf.sys_dir where id = 74;
-
-select * from lf.sys_dict where field='gid';
-select field,type,count(*) from lf.sys_dict where field='gid' group by field,type;
-update lf.sys_dict set type='integer' where field='updateuser';
-select * from lf.sys_layer;
-alter sequence lf.sys_layer_id_seq restart with 1;
-
-select * from lf.sys_menu where position('http:' in url)>0;
-select * from bd.b_hydrogeology_attach limit 1;
-select * from bd.b_pac_hydrogeology limit 1;
-
-select * from lf.sys_serve_log;
-select * from lf.sys_meta;
-select * from lf.sys_operate order by id desc limit 20;
-select * from lf.sys_report order by id;
-select * from lf.sys_attach order by id;
-select * from lf.sys_download order by id desc;
-
select fn_rec_query(depid, 'dep') "m1", count(sizes) "sizes"
from lf.sys_meta
group by depid
@@ -147,10 +122,18 @@
from lf.sys_operate
group by modular1,modular2
order by modular1 desc,modular2;
+-----------------------------------------------------------------------
+select * from lf.sys_menu where position('http:' in url)>0;
+select * from bs.m_marker where parentid is not null; -- delete from bs.m_marker; createtime
+select * from bs.m_hydraulic_protection;
-select * from lf.sys_operate where modular2 = '' or modular2 = '2' or modular2 is null;
-delete from lf.sys_operate where modular2 = '' or modular2 = '2' or modular2 is null;
-select * from lf.sys_report
+select * from lf.sys_layer where url is not null;
+
+
+
+
+
+
--
Gitblit v1.9.3