From 39e35df1c928a6dbceb216a315f5238b8839af8e Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期五, 10 二月 2023 15:11:12 +0800 Subject: [PATCH] 1 --- data/ts.sql | 24 +++++++++++++++++++----- 1 files changed, 19 insertions(+), 5 deletions(-) diff --git a/data/ts.sql b/data/ts.sql index 191b43c..3dfba03 100644 --- a/data/ts.sql +++ b/data/ts.sql @@ -119,10 +119,8 @@ 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_dict where ns='md'; select * from lf.sys_menu where position('http:' in url)>0; select * from bd.b_hydrogeology_attach limit 1; @@ -130,11 +128,27 @@ select * from lf.sys_serve_log; select * from lf.sys_meta; -select * from lf.sys_operate order by id limit 20; +select * from lf.sys_operate order by id desc limit 20; -select modular1,modular2,count(*) from lf.sys_operate group by modular1,modular2 order by modular1 desc,modular2; -select type from lf.sys_operate group by type + + + + + + + + + + + + + + + + + + -- Gitblit v1.9.3