From 7d5a5b6c8fa20720a01986e9498a4cee6ec3674b Mon Sep 17 00:00:00 2001 From: xubinbin <1323875150@qq.com> Date: 星期二, 30 五月 2023 13:24:46 +0800 Subject: [PATCH] 删除2.6.8升级2.6.9.sql文件中给表gb_stream添加主键sql,保证升级脚本能正常执行。 --- src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java | 6 ------ 1 files changed, 0 insertions(+), 6 deletions(-) diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java index 67cdccd..c96aeaf 100644 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/UserMapper.java @@ -50,12 +50,6 @@ @ResultMap(value="roleMap") List<User> selectAll(); -// @Select("select * from (select user.*, concat(concat(#{call_id}, '_'), push_key) as str1 from wvp_user) as u where md5(u.str1) = #{sign}") -// List<User> checkPushAuthorityByCallIdAndSign(String callId, String sign); -// -// @Select("select * from wvp_user where md5(push_key) = #{sign}") -// List<User> checkPushAuthorityByCallId(String sign); - @Select("select u.id, u.username,u.push_key,u.role_id, r.id as role_id, r.name as role_name, r.authority as role_authority , r.create_time as role_create_time , r.update_time as role_update_time from wvp_user u join wvp_user_role r on u.role_id=r.id") @ResultMap(value="roleMap") List<User> getUsers(); -- Gitblit v1.8.0