From 1c090243771f3aea29e5d5de6d8291cd54a31356 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期三, 15 二月 2023 14:42:05 +0800 Subject: [PATCH] 1 --- data/update.sql | 11 +++++------ 1 files changed, 5 insertions(+), 6 deletions(-) diff --git a/data/update.sql b/data/update.sql index c29911a..1020117 100644 --- a/data/update.sql +++ b/data/update.sql @@ -182,20 +182,19 @@ select * from lf.sys_res; select * from lf.sys_ver; - select c.* from lf.sys_role a inner join lf.sys_role_user b on a.id = b.roleid inner join lf.sys_user c on b.userid = c.id where a.is_admin = 2 and c.depcode = '000204' -order by c.id limit 1 +order by c.id limit 1; select c.* from lf.sys_role a inner join lf.sys_role_user b on a.id = b.roleid inner join lf.sys_user c on b.userid = c.id where a.is_admin = 2 and a.depid = 20 -order by c.id limit 1 +order by c.id limit 1; -select * from lf.sys_user -select * from lf.sys_role -select * from lf.sys_download +select * from lf.sys_user; +select * from lf.sys_role; +select * from lf.sys_download where guid = '5f0d5b61ca8cd79a07502f308c2f4dcc'; -- Gitblit v1.9.3