Skip to content

Releases: LiuYuYang01/ThriveX-Server

2.4.4 解决已知问题

01 Feb 12:50
@LiuYuYang01 LiuYuYang01
2.4.4
eb083f4
Compare
Choose a tag to compare
2.4.4 解决已知问题 Latest
Latest 
解决已知问题
Assets 3
Loading

2.4.3 完成约束用户多设备登录

26 Jan 07:41
@LiuYuYang01 LiuYuYang01
2.4.3
5319697
Compare
Choose a tag to compare
2.4.3 完成约束用户多设备登录

更新说明

当用户在其他浏览器或设备登录时会自动挤掉之前的登录状态，最终只会确保在一个地方登录，加强了安全性

更新表结构

create table user_token
(
    id    int auto_increment
        primary key,
    uid   int  not null comment '用户 ID',
    token text not null comment '用户token',
    constraint user_token_pk_2
        unique (id),
    constraint user_token_pk_3
        unique (uid)
)
    comment '用户 token';
Assets 3
Loading

2.4.2 修复权限已知问题

25 Jan 13:47
@LiuYuYang01 LiuYuYang01
2.4.2
9ea439f
Compare
Choose a tag to compare
2.4.2 修复权限已知问题

去除即可

image

Assets 3
Loading

2.4.1 完善 RBAC 菜单以及按钮权限

25 Jan 12:33
@LiuYuYang01 LiuYuYang01
2.4.1
bbc399e
Compare
Choose a tag to compare
2.4.1 完善 RBAC 菜单以及按钮权限

旧版升级

导入此 Sql

DROP TABLE IF EXISTS role;
create table role
(
    id          int auto_increment
        primary key,
    name        varchar(255) not null comment '角色名称',
    mark        varchar(100) not null comment '角色标识',
    description varchar(255) not null comment '角色描述'
);

INSERT INTO role (name, mark, description) VALUES ('管理员', 'admin', '最高权限');
INSERT INTO role (name, mark, description) VALUES ('作者', 'author', '发布文章、查看文章列表');



DROP TABLE IF EXISTS permission;
create table permission
(
    id          int auto_increment
        primary key,
    name        varchar(100) not null comment '权限标识',
    description varchar(255) not null comment '权限介绍',
    `group`     varchar(50)  not null comment '权限分组',
    role_id     int          not null comment '角色ID',
    constraint Permission_pk_2
        unique (id)
)
    comment '角色权限';

INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:add', '新增用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:del', '删除用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:edit', '编辑用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:info', '获取用户', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:list', '获取用户列表', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('user:pass', '修改用户密码', 'user', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('data:add', '新增数据', 'data', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('data:del', '删除数据', 'data', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:add', '新增文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:del', '删除文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:reduction', '还原被删除的文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:del', '批量删除文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('article:edit', '编辑文章', 'article', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('cate:add', '新增分类', 'cate', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('cate:del', '删除分类', 'cate', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('cate:edit', '编辑分类', 'cate', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('comment:del', '删除评论', 'comment', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('comment:edit', '编辑评论', 'comment', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('comment:audit', '审核评论', 'comment', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('config:info', '获取项目配置', 'config', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('config:list', '获取项目配置列表', 'config', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('config:edit', '修改项目配置', 'config', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('email:dismiss', '驳回通知邮件', 'email', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:info', '获取文件信息', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:dir', '获取目录列表', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:list', '获取文件列表', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:add', '文件上传', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('file:del', '删除文件', 'file', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:add', '新增oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:del', '删除oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:edit', '更新oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:info', '获取oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:list', '获取oss配置列表', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:enable', '启用oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:getEnableOss', '获取当前启用的oss配置', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('oss:getPlatform', '获取支持的oss平台', 'oss', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('record:add', '新增说说', 'record', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('record:del', '删除说说', 'record', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('record:edit', '编辑说说', 'record', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:add', '新增角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:del', '删除角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:edit', '编辑角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:info', '获取角色', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:list', '获取角色列表', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:getRouteList', '获取角色路由列表', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:bindingRoute', '分配角色权限', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:add', '新增路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:del', '删除路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:edit', '编辑路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:info', '获取路由', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('route:list', '获取路由列表', 'route', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('swiper:add', '新增轮播图', 'swiper', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('swiper:del', '删除轮播图', 'swiper', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('swiper:edit', '编辑轮播图', 'swiper', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('tag:add', '新增标签', 'tag', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('tag:del', '删除标签', 'tag', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('tag:edit', '编辑标签', 'tag', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('wall:del', '删除留言', 'wall', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('wall:edit', '编辑留言', 'wall', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('wall:audit', '审核留言', 'wall', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('role:getPermissionList', '获取角色路由列表', 'role', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:add', '新增权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:del', '删除权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:edit', '编辑权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:info', '获取权限', 'permission', 1);
INSERT INTO permission (name, description, `group`, role_id) VALUES ('permission:list', '获取权限列表', 'permission', 1);




DROP TABLE IF EXISTS role_permission;
create table role_permission
(
    id            int auto_increment
        primary key,
    role_id       int not null comment '角色ID',
    permission_id int not null comment '权限ID',
    constraint role_permission_pk_2
        unique (id)
)
    comment '角色权限';

INSERT INTO role_permission (role_id, permission_id) VALUES (1, 1);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 2);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 3);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 4);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 5);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 6);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 7);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 8);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 9);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 10);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 11);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 12);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 13);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 14);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 15);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 16);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 17);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 18);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 19);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 20);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 21);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 22);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 23);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 24);
INSERT INTO role_permission (role_id, permission_id) VALUES (1, 25);
I...
Read more
Assets 3
Loading

2.3.1 一波大更新：支持多种主流平台文件存储

10 Jan 10:27
@LiuYuYang01 LiuYuYang01
2.3.1
5658c47
Compare
Choose a tag to compare
2.3.1 一波大更新：支持多种主流平台文件存储

一波大更新：支持阿里云、华为云、腾讯云、七牛云、Minio 等主流对象存储平台 及 本地存储

image
image

运行命令：
java -jar blog.jar
--PORT=端口号
--DB_INFO=数据库信息（localhost:3306/blog）
--DB_USERNAME=数据库用户名
--DB_PASSWORD=数据库密码
--EMAIL_HOST=邮箱服务器
--EMAIL_PORT=邮箱服务器端口
--EMAIL_USERNAME=邮箱用户名
--EMAIL_PASSWORD=邮箱授权码（不是邮箱密码）

Assets 3
Loading

2.1.5 解决已知问题

24 Dec 13:15
@LiuYuYang01 LiuYuYang01
2.1.5
722622c
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
2.1.5 解决已知问题 
Merge pull request #16 from JayFans2000/modify_Maven

删除重复依赖
Assets 3
Loading

2.1.4 修复文章草稿在分类页显示问题

13 Dec 07:47
@LiuYuYang01 LiuYuYang01
2.1.4
b49346f
Compare
Choose a tag to compare
2.1.4 修复文章草稿在分类页显示问题 
BUG：解决已知问题
Assets 3
Loading

2.1.3 完成说说管理功能

03 Dec 09:49
@LiuYuYang01 LiuYuYang01
2.1.3
06f22b4
Compare
Choose a tag to compare
2.1.3 完成说说管理功能 
调整：更新数据库
Assets 3
Loading

2.1.2 重构项目配置功能

28 Nov 18:20
@LiuYuYang01 LiuYuYang01
2.1.2
2599187
Compare
Choose a tag to compare
2.1.2 重构项目配置功能

之前：
image

之后：
image

Assets 3
Loading

2.1.1 完成文章草稿 && 回收站等功能

25 Nov 08:05
@LiuYuYang01 LiuYuYang01
2.1.1
8c123a3
Compare
Choose a tag to compare
2.1.1 完成文章草稿 && 回收站等功能 
调整：更新数据库&&文档
Assets 3
Loading