From 653ab219fdf13b30ff4b2c6c298df8f3929b283a Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期二, 25 十月 2022 16:25:06 +0800 Subject: [PATCH] 1 --- data/db_fn.sql | 5 +---- 1 files changed, 1 insertions(+), 4 deletions(-) diff --git a/data/db_fn.sql b/data/db_fn.sql index 335da85..56087ae 100644 --- a/data/db_fn.sql +++ b/data/db_fn.sql @@ -235,11 +235,8 @@ select to_char(optime,'yyyy-mm-dd') as optime,count(*) from lf.sys_login where optime between (select optime - interval '30 day') and optime group by to_char(optime, 'yyyy-mm-dd') order by to_char(optime, 'yyyy-mm-dd') asc; ----------------------------------------------------------------------------------------------------- -select * from lf.sys_user; +select a.*,coalesce(a.native,'') from lf.sys_user a; select * from lf.sys_menu order by id; - - - -- Gitblit v1.9.3