From 3f8fc49de0a57774e8fb51ae015b71c030b36ae8 Mon Sep 17 00:00:00 2001
From: lixuliang <lixuliang_hd@126.com>
Date: 星期四, 29 八月 2024 18:02:31 +0800
Subject: [PATCH] 后台 未修改
---
se-modules/se-system/src/main/java/com/se/system/service/impl/SysPermissionServiceImpl.java | 58 +-
.gitignore | 1
se-api/se-api-system/src/main/java/com/se/system/api/domain/SysUser.java | 14
se-auth/src/main/java/com/se/auth/service/AsyncService.java | 35 +
se-modules/se-system/src/main/resources/mapper/system/SysUserMapper.xml | 12
se-gateway/src/main/resources/bootstrap.yml | 3
docker-compose/mysql/initdb/se_cloud_20240629.sql | 184 +++++----
se-common/se-common-core/src/main/java/com/se/common/core/constant/TokenConstants.java | 19
se-auth/src/main/java/com/se/auth/controller/HealthController.java | 20 +
se-auth/src/main/java/com/se/auth/service/SysPasswordService.java | 5
se-modules/se-system/src/main/java/com/se/system/controller/HealthController.java | 19 +
se-common/se-common-core/src/main/java/com/se/common/core/utils/AesUtils.java | 130 ++++++
docker-compose/mysql/initdb/se_quartz.sql | 2
se-modules/se-system/src/main/java/com/se/system/controller/SysUserController.java | 6
se-auth/src/main/java/com/se/auth/controller/TokenController.java | 22
docker-compose/docker-compose.yml | 20 +
docker-compose/mysql/initdb/se_config_20231204.sql | 6
se-gateway/src/main/java/com/se/gateway/handler/SwaggerHandler.java | 5
docker-compose/dc.yml | 61 +++
docker-compose/mysql/initdb/se_seata_20210128.sql | 4
se-auth/src/main/resources/bootstrap.yml | 2
se-cloud.iml | 0
se-common/se-common-core/src/main/java/com/se/common/core/utils/RsaUtils.java | 212 +++++++++++
se-modules/se-system/src/main/resources/bootstrap.yml | 2
/dev/null | 80 ----
se-auth/se-auth.iml | 13
se-common/se-common-core/src/main/java/com/se/common/core/utils/StringUtils.java | 18
se-common/se-common-security/src/main/java/com/se/common/security/utils/SecurityUtils.java | 17
docker-compose/nginx/conf/nginx.conf | 18
docker-compose/nacos/conf/application.properties | 4
se-modules/se-system/src/main/java/com/se/system/service/ISysPermissionService.java | 16
se-auth/pom.xml | 9
se-gateway/src/main/java/com/se/gateway/config/CorsConfig.java | 59 +++
se-gateway/src/main/java/com/se/gateway/handler/HealthController.java | 21 +
34 files changed, 867 insertions(+), 230 deletions(-)
diff --git a/.gitignore b/.gitignore
index f79a3e8..31adb1f 100644
--- a/.gitignore
+++ b/.gitignore
@@ -47,3 +47,4 @@
/logs
*.jar
/docker-compose/nginx/html
+/docker-compose/mysql/data
diff --git a/docker-compose/dc.yml b/docker-compose/dc.yml
new file mode 100644
index 0000000..9b59f13
--- /dev/null
+++ b/docker-compose/dc.yml
@@ -0,0 +1,61 @@
+version : '3.8'
+services:
+ # mysql
+ se-mysql:
+ image: mysql:5.7
+ ports:
+ - 3307:3306
+ volumes:
+ - ./mysql/logs:/logs
+ - ./mysql/data:/var/lib/mysql
+ - ./mysql/conf:/etc/mysql/conf.d
+ - ./mysql/initdb:/docker-entrypoint-initdb.d
+ command: [
+ 'mysqld',
+ '--innodb-buffer-pool-size=80M',
+ '--character-set-server=utf8mb4',
+ '--collation-server=utf8mb4_unicode_ci',
+ '--default-time-zone=+8:00',
+ '--lower-case-table-names=1'
+ ]
+ environment:
+ TZ: Asia/Shanghai
+ MYSQL_DATABASE: 'se-cloud'
+ MYSQL_ROOT_PASSWORD: My_Sql_s!E_v5.7
+ networks:
+ - network-se
+ restart: always
+ # nacos
+ se-nacos:
+ image: nacos/nacos-server:v2.4.1
+ environment:
+ MODE: standalone
+ TZ: Asia/Shanghai
+ volumes:
+ - ./nacos/logs/:/home/nacos/logs
+ - ./nacos/conf/application.properties:/home/nacos/conf/application.properties
+ ports:
+ - 8848:8848
+ - 9848:9848
+ - 9849:9849
+ depends_on:
+ - se-mysql
+ networks:
+ - network-se
+ restart: always
+ # redis,Redis_s!E_6.2.6
+ se-redis:
+ image: redis:latest
+ ports:
+ - 6379:6379
+ volumes:
+ - ./redis/data/redis.conf:/data/redis.conf
+ - ./redis/data:/data
+ command: redis-server /data/redis.conf
+ networks:
+ - network-se
+ restart: always
+# networks
+networks:
+ network-se:
+ driver: bridge
diff --git a/docker-compose/docker-compose.yml b/docker-compose/docker-compose.yml
index 6323696..ffd797f 100644
--- a/docker-compose/docker-compose.yml
+++ b/docker-compose/docker-compose.yml
@@ -22,6 +22,8 @@
TZ: Asia/Shanghai
MYSQL_DATABASE: 'se-cloud'
MYSQL_ROOT_PASSWORD: My_Sql_s!E_v5.7
+ networks:
+ - network-se
restart: always
# nacos
se-nacos:
@@ -38,8 +40,10 @@
- 9849:9849
depends_on:
- se-mysql
+ networks:
+ - network-se
restart: always
- # redis
+ # redis,Redis_s!E_6.2.6
se-redis:
image: redis:latest
ports:
@@ -48,6 +52,8 @@
- ./redis/data/redis.conf:/data/redis.conf
- ./redis/data:/data
command: redis-server /data/redis.conf
+ networks:
+ - network-se
restart: always
# gateway
se-gateway:
@@ -65,6 +71,8 @@
links:
- se-redis
- se-nacos
+ networks:
+ - network-se
restart: always
# auth
se-auth:
@@ -79,6 +87,8 @@
depends_on:
- se-redis
- se-nacos
+ networks:
+ - network-se
restart: always
# system
se-system:
@@ -94,6 +104,8 @@
- se-redis
- se-nacos
- se-mysql
+ networks:
+ - network-se
restart: always
# nginx
se-nginx:
@@ -109,4 +121,10 @@
- ./nginx/conf/nginx.conf:/etc/nginx/nginx.conf
depends_on:
- se-gateway
+ networks:
+ - network-se
restart: always
+# networks
+networks:
+ network-se:
+ driver: bridge
diff --git a/docker-compose/mysql/initdb/se_cloud_20240629.sql b/docker-compose/mysql/initdb/se_cloud_20240629.sql
index 4cacedf..edff4ac 100644
--- a/docker-compose/mysql/initdb/se_cloud_20240629.sql
+++ b/docker-compose/mysql/initdb/se_cloud_20240629.sql
@@ -53,6 +53,7 @@
user_name varchar(30) not null comment '鐢ㄦ埛璐﹀彿',
nick_name varchar(30) not null comment '鐢ㄦ埛鏄电О',
user_type varchar(2) default '00' comment '鐢ㄦ埛绫诲瀷锛�00绯荤粺鐢ㄦ埛锛�',
+ secret_level varchar(2) default '1' comment '瀵嗙骇绫诲瀷',
email varchar(50) default '' comment '鐢ㄦ埛閭',
phonenumber varchar(11) default '' comment '鎵嬫満鍙风爜',
sex char(1) default '0' comment '鐢ㄦ埛鎬у埆锛�0鐢� 1濂� 2鏈煡锛�',
@@ -73,9 +74,9 @@
-- ----------------------------
-- 鍒濆鍖�-鐢ㄦ埛淇℃伅琛ㄦ暟鎹�
-- ----------------------------
-insert into sys_user values(1, 103, 'admin', '', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '绠＄悊鍛�');
-insert into sys_user values(2, 105, 'ry', '', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '娴嬭瘯鍛�');
-
+insert into sys_user values(1, 103, 'admin', '', '00', '1', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '绠＄悊鍛�');
+insert into sys_user values(2, 105, 'ry', '', '00', '1', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '娴嬭瘯鍛�');
+-- select * from sys_user;
-- ----------------------------
-- 3銆佸矖浣嶄俊鎭〃
@@ -125,14 +126,17 @@
update_time datetime comment '鏇存柊鏃堕棿',
remark varchar(500) default null comment '澶囨敞',
primary key (role_id)
-) engine=innodb auto_increment=3 comment = '瑙掕壊淇℃伅琛�';
+) engine=innodb auto_increment=6 comment = '瑙掕壊淇℃伅琛�';
-- ----------------------------
-- 鍒濆鍖�-瑙掕壊淇℃伅琛ㄦ暟鎹�
-- ----------------------------
-insert into sys_role values('1', '瓒呯骇绠＄悊鍛�', 'admin', 1, 1, 1, 1, '0', '0', 'admin', sysdate(), '', null, '瓒呯骇绠＄悊鍛�');
-insert into sys_role values('2', '鏅�氳鑹�', 'common', 2, 2, 1, 1, '0', '0', 'admin', sysdate(), '', null, '鏅�氳鑹�');
-
+insert into sys_role values('1', '绯荤粺绠＄悊鍛�', 'admin', 1, 1, 1, 1, '0', '0', 'admin', sysdate(), '', null, '绯荤粺绠＄悊鍛�');
+insert into sys_role values('2', '瓒呯骇鐢ㄦ埛', 'superuser', 2, 2, 1, 1, '0', '0', 'admin', sysdate(), '', null, '瓒呯骇鐢ㄦ埛');
+insert into sys_role values('3', '鏅�氱敤鎴�', 'common', 3, 4, 1, 1, '0', '0', 'admin', sysdate(), '', null, '鏅�氱敤鎴�');
+insert into sys_role values('4', '鍙楅檺鐢ㄦ埛', 'limited', 4, 4, 1, 1, '0', '0', 'admin', sysdate(), '', null, '鍙楅檺鐢ㄦ埛');
+insert into sys_role values('5', '鍙鐢ㄦ埛', 'readonly', 5, 4, 1, 1, '0', '0', 'admin', sysdate(), '', null, '鍙鐢ㄦ埛');
+-- select * from sys_role;
-- ----------------------------
-- 5銆佽彍鍗曟潈闄愯〃
@@ -167,9 +171,9 @@
-- ----------------------------
-- 涓�绾ц彍鍗�
insert into sys_menu values('1', '绯荤粺绠＄悊', '0', '1', 'system', null, '', '', 1, 0, 'M', '0', '0', '', 'system', 'admin', sysdate(), '', null, '绯荤粺绠＄悊鐩綍');
-insert into sys_menu values('2', '绯荤粺鐩戞帶', '0', '2', 'monitor', null, '', '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', sysdate(), '', null, '绯荤粺鐩戞帶鐩綍');
-insert into sys_menu values('3', '绯荤粺宸ュ叿', '0', '3', 'tool', null, '', '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', sysdate(), '', null, '绯荤粺宸ュ叿鐩綍');
-insert into sys_menu values('4', '瀹樼綉', '0', '4', 'http://se.vip', null, '', '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', sysdate(), '', null, '瀹樼綉鍦板潃');
+-- insert into sys_menu values('2', '绯荤粺鐩戞帶', '0', '2', 'monitor', null, '', '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', sysdate(), '', null, '绯荤粺鐩戞帶鐩綍');
+-- insert into sys_menu values('3', '绯荤粺宸ュ叿', '0', '3', 'tool', null, '', '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', sysdate(), '', null, '绯荤粺宸ュ叿鐩綍');
+-- insert into sys_menu values('4', '瀹樼綉', '0', '4', 'http://se.vip', null, '', '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', sysdate(), '', null, '瀹樼綉鍦板潃');
-- 浜岀骇鑿滃崟
insert into sys_menu values('100', '鐢ㄦ埛绠＄悊', '1', '1', 'user', 'system/user/index', '', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', sysdate(), '', null, '鐢ㄦ埛绠＄悊鑿滃崟');
insert into sys_menu values('101', '瑙掕壊绠＄悊', '1', '2', 'role', 'system/role/index', '', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', sysdate(), '', null, '瑙掕壊绠＄悊鑿滃崟');
@@ -177,17 +181,17 @@
insert into sys_menu values('103', '閮ㄩ棬绠＄悊', '1', '4', 'dept', 'system/dept/index', '', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', sysdate(), '', null, '閮ㄩ棬绠＄悊鑿滃崟');
insert into sys_menu values('104', '宀椾綅绠＄悊', '1', '5', 'post', 'system/post/index', '', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', sysdate(), '', null, '宀椾綅绠＄悊鑿滃崟');
insert into sys_menu values('105', '瀛楀吀绠＄悊', '1', '6', 'dict', 'system/dict/index', '', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', sysdate(), '', null, '瀛楀吀绠＄悊鑿滃崟');
-insert into sys_menu values('106', '鍙傛暟璁剧疆', '1', '7', 'config', 'system/config/index', '', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', sysdate(), '', null, '鍙傛暟璁剧疆鑿滃崟');
-insert into sys_menu values('107', '閫氱煡鍏憡', '1', '8', 'notice', 'system/notice/index', '', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, '閫氱煡鍏憡鑿滃崟');
+-- insert into sys_menu values('106', '鍙傛暟璁剧疆', '1', '7', 'config', 'system/config/index', '', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', sysdate(), '', null, '鍙傛暟璁剧疆鑿滃崟');
+-- insert into sys_menu values('107', '閫氱煡鍏憡', '1', '8', 'notice', 'system/notice/index', '', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, '閫氱煡鍏憡鑿滃崟');
insert into sys_menu values('108', '鏃ュ織绠＄悊', '1', '9', 'log', '', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, '鏃ュ織绠＄悊鑿滃崟');
-insert into sys_menu values('109', '鍦ㄧ嚎鐢ㄦ埛', '2', '1', 'online', 'monitor/online/index', '', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, '鍦ㄧ嚎鐢ㄦ埛鑿滃崟');
-insert into sys_menu values('110', '瀹氭椂浠诲姟', '2', '2', 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, '瀹氭椂浠诲姟鑿滃崟');
-insert into sys_menu values('111', 'Sentinel鎺у埗鍙�', '2', '3', 'http://localhost:8718', '', '', '', 0, 0, 'C', '0', '0', 'monitor:sentinel:list', 'sentinel', 'admin', sysdate(), '', null, '娴侀噺鎺у埗鑿滃崟');
-insert into sys_menu values('112', 'Nacos鎺у埗鍙�', '2', '4', 'http://localhost:8848/nacos', '', '', '', 0, 0, 'C', '0', '0', 'monitor:nacos:list', 'nacos', 'admin', sysdate(), '', null, '鏈嶅姟娌荤悊鑿滃崟');
-insert into sys_menu values('113', 'Admin鎺у埗鍙�', '2', '5', 'http://localhost:9100/login', '', '', '', 0, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', sysdate(), '', null, '鏈嶅姟鐩戞帶鑿滃崟');
-insert into sys_menu values('114', '琛ㄥ崟鏋勫缓', '3', '1', 'build', 'tool/build/index', '', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, '琛ㄥ崟鏋勫缓鑿滃崟');
-insert into sys_menu values('115', '浠ｇ爜鐢熸垚', '3', '2', 'gen', 'tool/gen/index', '', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, '浠ｇ爜鐢熸垚鑿滃崟');
-insert into sys_menu values('116', '绯荤粺鎺ュ彛', '3', '3', 'http://localhost:8080/swagger-ui/index.html', '', '', '', 0, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', sysdate(), '', null, '绯荤粺鎺ュ彛鑿滃崟');
+-- insert into sys_menu values('109', '鍦ㄧ嚎鐢ㄦ埛', '2', '1', 'online', 'monitor/online/index', '', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, '鍦ㄧ嚎鐢ㄦ埛鑿滃崟');
+-- insert into sys_menu values('110', '瀹氭椂浠诲姟', '2', '2', 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, '瀹氭椂浠诲姟鑿滃崟');
+-- insert into sys_menu values('111', 'Sentinel鎺у埗鍙�', '2', '3', 'http://localhost:8718', '', '', '', 0, 0, 'C', '0', '0', 'monitor:sentinel:list', 'sentinel', 'admin', sysdate(), '', null, '娴侀噺鎺у埗鑿滃崟');
+-- insert into sys_menu values('112', 'Nacos鎺у埗鍙�', '2', '4', 'http://localhost:8848/nacos', '', '', '', 0, 0, 'C', '0', '0', 'monitor:nacos:list', 'nacos', 'admin', sysdate(), '', null, '鏈嶅姟娌荤悊鑿滃崟');
+-- insert into sys_menu values('113', 'Admin鎺у埗鍙�', '2', '5', 'http://localhost:9100/login', '', '', '', 0, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', sysdate(), '', null, '鏈嶅姟鐩戞帶鑿滃崟');
+-- insert into sys_menu values('114', '琛ㄥ崟鏋勫缓', '3', '1', 'build', 'tool/build/index', '', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, '琛ㄥ崟鏋勫缓鑿滃崟');
+-- insert into sys_menu values('115', '浠ｇ爜鐢熸垚', '3', '2', 'gen', 'tool/gen/index', '', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, '浠ｇ爜鐢熸垚鑿滃崟');
+-- insert into sys_menu values('116', '绯荤粺鎺ュ彛', '3', '3', 'http://localhost:8080/swagger-ui/index.html', '', '', '', 0, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', sysdate(), '', null, '绯荤粺鎺ュ彛鑿滃崟');
-- 涓夌骇鑿滃崟
insert into sys_menu values('500', '鎿嶄綔鏃ュ織', '108', '1', 'operlog', 'system/operlog/index', '', '', 1, 0, 'C', '0', '0', 'system:operlog:list', 'form', 'admin', sysdate(), '', null, '鎿嶄綔鏃ュ織鑿滃崟');
insert into sys_menu values('501', '鐧诲綍鏃ュ織', '108', '2', 'logininfor', 'system/logininfor/index', '', '', 1, 0, 'C', '0', '0', 'system:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, '鐧诲綍鏃ュ織鑿滃崟');
@@ -228,16 +232,16 @@
insert into sys_menu values('1028', '瀛楀吀鍒犻櫎', '105', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1029', '瀛楀吀瀵煎嚭', '105', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, '');
-- 鍙傛暟璁剧疆鎸夐挳
-insert into sys_menu values('1030', '鍙傛暟鏌ヨ', '106', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1031', '鍙傛暟鏂板', '106', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1032', '鍙傛暟淇敼', '106', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1033', '鍙傛暟鍒犻櫎', '106', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1034', '鍙傛暟瀵煎嚭', '106', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1030', '鍙傛暟鏌ヨ', '106', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1031', '鍙傛暟鏂板', '106', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1032', '鍙傛暟淇敼', '106', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1033', '鍙傛暟鍒犻櫎', '106', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1034', '鍙傛暟瀵煎嚭', '106', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
-- 閫氱煡鍏憡鎸夐挳
-insert into sys_menu values('1035', '鍏憡鏌ヨ', '107', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1036', '鍏憡鏂板', '107', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1037', '鍏憡淇敼', '107', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1038', '鍏憡鍒犻櫎', '107', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1035', '鍏憡鏌ヨ', '107', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1036', '鍏憡鏂板', '107', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1037', '鍏憡淇敼', '107', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1038', '鍏憡鍒犻櫎', '107', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
-- 鎿嶄綔鏃ュ織鎸夐挳
insert into sys_menu values('1039', '鎿嶄綔鏌ヨ', '500', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:operlog:query', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1040', '鎿嶄綔鍒犻櫎', '500', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:operlog:remove', '#', 'admin', sysdate(), '', null, '');
@@ -248,23 +252,23 @@
insert into sys_menu values('1044', '鏃ュ織瀵煎嚭', '501', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:export', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1045', '璐︽埛瑙ｉ攣', '501', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:unlock', '#', 'admin', sysdate(), '', null, '');
-- 鍦ㄧ嚎鐢ㄦ埛鎸夐挳
-insert into sys_menu values('1046', '鍦ㄧ嚎鏌ヨ', '109', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1047', '鎵归噺寮洪��', '109', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1048', '鍗曟潯寮洪��', '109', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1046', '鍦ㄧ嚎鏌ヨ', '109', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1047', '鎵归噺寮洪��', '109', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1048', '鍗曟潯寮洪��', '109', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
-- 瀹氭椂浠诲姟鎸夐挳
-insert into sys_menu values('1049', '浠诲姟鏌ヨ', '110', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1050', '浠诲姟鏂板', '110', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1051', '浠诲姟淇敼', '110', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1052', '浠诲姟鍒犻櫎', '110', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1053', '鐘舵�佷慨鏀�', '110', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1054', '浠诲姟瀵煎嚭', '110', '6', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1049', '浠诲姟鏌ヨ', '110', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1050', '浠诲姟鏂板', '110', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1051', '浠诲姟淇敼', '110', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1052', '浠诲姟鍒犻櫎', '110', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1053', '鐘舵�佷慨鏀�', '110', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1054', '浠诲姟瀵煎嚭', '110', '6', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', sysdate(), '', null, '');
-- 浠ｇ爜鐢熸垚鎸夐挳
-insert into sys_menu values('1055', '鐢熸垚鏌ヨ', '115', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1056', '鐢熸垚淇敼', '115', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1057', '鐢熸垚鍒犻櫎', '115', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1058', '瀵煎叆浠ｇ爜', '115', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1059', '棰勮浠ｇ爜', '115', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1060', '鐢熸垚浠ｇ爜', '115', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1055', '鐢熸垚鏌ヨ', '115', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1056', '鐢熸垚淇敼', '115', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1057', '鐢熸垚鍒犻櫎', '115', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1058', '瀵煎叆浠ｇ爜', '115', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1059', '棰勮浠ｇ爜', '115', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
+-- insert into sys_menu values('1060', '鐢熸垚浠ｇ爜', '115', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
-- ----------------------------
@@ -298,26 +302,26 @@
-- 鍒濆鍖�-瑙掕壊鍜岃彍鍗曞叧鑱旇〃鏁版嵁
-- ----------------------------
insert into sys_role_menu values ('2', '1');
-insert into sys_role_menu values ('2', '2');
-insert into sys_role_menu values ('2', '3');
-insert into sys_role_menu values ('2', '4');
+-- insert into sys_role_menu values ('2', '2');
+-- insert into sys_role_menu values ('2', '3');
+-- insert into sys_role_menu values ('2', '4');
insert into sys_role_menu values ('2', '100');
insert into sys_role_menu values ('2', '101');
insert into sys_role_menu values ('2', '102');
insert into sys_role_menu values ('2', '103');
insert into sys_role_menu values ('2', '104');
insert into sys_role_menu values ('2', '105');
-insert into sys_role_menu values ('2', '106');
-insert into sys_role_menu values ('2', '107');
+-- insert into sys_role_menu values ('2', '106');
+-- insert into sys_role_menu values ('2', '107');
insert into sys_role_menu values ('2', '108');
-insert into sys_role_menu values ('2', '109');
-insert into sys_role_menu values ('2', '110');
-insert into sys_role_menu values ('2', '111');
-insert into sys_role_menu values ('2', '112');
-insert into sys_role_menu values ('2', '113');
-insert into sys_role_menu values ('2', '114');
-insert into sys_role_menu values ('2', '115');
-insert into sys_role_menu values ('2', '116');
+-- insert into sys_role_menu values ('2', '109');
+-- insert into sys_role_menu values ('2', '110');
+-- insert into sys_role_menu values ('2', '111');
+-- insert into sys_role_menu values ('2', '112');
+-- insert into sys_role_menu values ('2', '113');
+-- insert into sys_role_menu values ('2', '114');
+-- insert into sys_role_menu values ('2', '115');
+-- insert into sys_role_menu values ('2', '116');
insert into sys_role_menu values ('2', '500');
insert into sys_role_menu values ('2', '501');
insert into sys_role_menu values ('2', '1000');
@@ -350,15 +354,15 @@
insert into sys_role_menu values ('2', '1027');
insert into sys_role_menu values ('2', '1028');
insert into sys_role_menu values ('2', '1029');
-insert into sys_role_menu values ('2', '1030');
-insert into sys_role_menu values ('2', '1031');
-insert into sys_role_menu values ('2', '1032');
-insert into sys_role_menu values ('2', '1033');
-insert into sys_role_menu values ('2', '1034');
-insert into sys_role_menu values ('2', '1035');
-insert into sys_role_menu values ('2', '1036');
-insert into sys_role_menu values ('2', '1037');
-insert into sys_role_menu values ('2', '1038');
+-- insert into sys_role_menu values ('2', '1030');
+-- insert into sys_role_menu values ('2', '1031');
+-- insert into sys_role_menu values ('2', '1032');
+-- insert into sys_role_menu values ('2', '1033');
+-- insert into sys_role_menu values ('2', '1034');
+-- insert into sys_role_menu values ('2', '1035');
+-- insert into sys_role_menu values ('2', '1036');
+-- insert into sys_role_menu values ('2', '1037');
+-- insert into sys_role_menu values ('2', '1038');
insert into sys_role_menu values ('2', '1039');
insert into sys_role_menu values ('2', '1040');
insert into sys_role_menu values ('2', '1041');
@@ -366,21 +370,21 @@
insert into sys_role_menu values ('2', '1043');
insert into sys_role_menu values ('2', '1044');
insert into sys_role_menu values ('2', '1045');
-insert into sys_role_menu values ('2', '1046');
-insert into sys_role_menu values ('2', '1047');
-insert into sys_role_menu values ('2', '1048');
-insert into sys_role_menu values ('2', '1049');
-insert into sys_role_menu values ('2', '1050');
-insert into sys_role_menu values ('2', '1051');
-insert into sys_role_menu values ('2', '1052');
-insert into sys_role_menu values ('2', '1053');
-insert into sys_role_menu values ('2', '1054');
-insert into sys_role_menu values ('2', '1055');
-insert into sys_role_menu values ('2', '1056');
-insert into sys_role_menu values ('2', '1057');
-insert into sys_role_menu values ('2', '1058');
-insert into sys_role_menu values ('2', '1059');
-insert into sys_role_menu values ('2', '1060');
+-- insert into sys_role_menu values ('2', '1046');
+-- insert into sys_role_menu values ('2', '1047');
+-- insert into sys_role_menu values ('2', '1048');
+-- insert into sys_role_menu values ('2', '1049');
+-- insert into sys_role_menu values ('2', '1050');
+-- insert into sys_role_menu values ('2', '1051');
+-- insert into sys_role_menu values ('2', '1052');
+-- insert into sys_role_menu values ('2', '1053');
+-- insert into sys_role_menu values ('2', '1054');
+-- insert into sys_role_menu values ('2', '1055');
+-- insert into sys_role_menu values ('2', '1056');
+-- insert into sys_role_menu values ('2', '1057');
+-- insert into sys_role_menu values ('2', '1058');
+-- insert into sys_role_menu values ('2', '1059');
+-- insert into sys_role_menu values ('2', '1060');
-- ----------------------------
-- 8銆佽鑹插拰閮ㄩ棬鍏宠仈琛� 瑙掕壊1-N閮ㄩ棬
@@ -464,7 +468,7 @@
remark varchar(500) default null comment '澶囨敞',
primary key (dict_id),
unique (dict_type)
-) engine=innodb auto_increment=11 comment = '瀛楀吀绫诲瀷琛�';
+) engine=innodb auto_increment=13 comment = '瀛楀吀绫诲瀷琛�';
insert into sys_dict_type values(1, '鐢ㄦ埛鎬у埆', 'sys_user_sex', '0', 'admin', sysdate(), '', null, '鐢ㄦ埛鎬у埆鍒楄〃');
insert into sys_dict_type values(2, '鑿滃崟鐘舵��', 'sys_show_hide', '0', 'admin', sysdate(), '', null, '鑿滃崟鐘舵�佸垪琛�');
@@ -476,7 +480,9 @@
insert into sys_dict_type values(8, '閫氱煡鐘舵��', 'sys_notice_status', '0', 'admin', sysdate(), '', null, '閫氱煡鐘舵�佸垪琛�');
insert into sys_dict_type values(9, '鎿嶄綔绫诲瀷', 'sys_oper_type', '0', 'admin', sysdate(), '', null, '鎿嶄綔绫诲瀷鍒楄〃');
insert into sys_dict_type values(10, '绯荤粺鐘舵��', 'sys_common_status', '0', 'admin', sysdate(), '', null, '鐧诲綍鐘舵�佸垪琛�');
-
+insert into sys_dict_type values(11, '鍔犲瘑绫诲瀷', 'sys_encryption_method','0', 'admin', sysdate(), '', null, '鍔犲瘑绫诲瀷鍒楄〃');
+insert into sys_dict_type values(12, '瀵嗙骇绫诲瀷', 'sys_secret_level', '0', 'admin', sysdate(), '', null, '瀵嗙骇绫诲瀷鍒楄〃');
+-- select * from sys_dict_type;
-- ----------------------------
-- 12銆佸瓧鍏告暟鎹〃
@@ -499,7 +505,7 @@
update_time datetime comment '鏇存柊鏃堕棿',
remark varchar(500) default null comment '澶囨敞',
primary key (dict_code)
-) engine=innodb auto_increment=30 comment = '瀛楀吀鏁版嵁琛�';
+) engine=innodb auto_increment=37 comment = '瀛楀吀鏁版嵁琛�';
insert into sys_dict_data values(1, 1, '鐢�', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', sysdate(), '', null, '鎬у埆鐢�');
insert into sys_dict_data values(2, 2, '濂�', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', sysdate(), '', null, '鎬у埆濂�');
@@ -530,7 +536,15 @@
insert into sys_dict_data values(27, 9, '娓呯┖鏁版嵁', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '娓呯┖鎿嶄綔');
insert into sys_dict_data values(28, 1, '鎴愬姛', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', sysdate(), '', null, '姝ｅ父鐘舵��');
insert into sys_dict_data values(29, 2, '澶辫触', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍋滅敤鐘舵��');
-
+-- https://blog.csdn.net/weixin_56154577/article/details/136803617
+insert into sys_dict_data values(30, 1, 'AES鍔犲瘑', '1', 'sys_encryption_method', '', '', 'Y', '0', 'admin', sysdate(), '', null, 'AES鍔犲瘑绠楁硶');
+insert into sys_dict_data values(31, 2, 'DES鍔犲瘑', '2', 'sys_encryption_method', '', '', 'N', '0', 'admin', sysdate(), '', null, 'DES鍔犲瘑绠楁硶');
+insert into sys_dict_data values(32, 3, 'RSA鍔犲瘑', '3', 'sys_encryption_method', '', '', 'N', '0', 'admin', sysdate(), '', null, 'RSA鍔犲瘑绠楁硶');
+insert into sys_dict_data values(33, 1, '鍏紑', '1', 'sys_secret_level', '', '', 'Y', '0', 'admin', sysdate(), '', null, '鍏紑瀵嗙骇');
+insert into sys_dict_data values(34, 2, '涓�鑸�', '2', 'sys_secret_level', '', '', 'N', '0', 'admin', sysdate(), '', null, '涓�鑸瘑绾�');
+insert into sys_dict_data values(35, 3, '閲嶈', '3', 'sys_secret_level', '', '', 'N', '0', 'admin', sysdate(), '', null, '閲嶈瀵嗙骇');
+insert into sys_dict_data values(36, 4, '鏍稿績', '4', 'sys_secret_level', '', '', 'N', '0', 'admin', sysdate(), '', null, '鏍稿績瀵嗙骇');
+-- select * from sys_dict_data;
-- ----------------------------
-- 13銆佸弬鏁伴厤缃〃
diff --git a/docker-compose/mysql/initdb/se_config_20231204.sql b/docker-compose/mysql/initdb/se_config_20231204.sql
index 6b1b9e1..abf0c60 100644
--- a/docker-compose/mysql/initdb/se_config_20231204.sql
+++ b/docker-compose/mysql/initdb/se_config_20231204.sql
@@ -1,6 +1,6 @@
-DROP DATABASE IF EXISTS `se-config`;
+-- DROP DATABASE IF EXISTS `se-config`;
-CREATE DATABASE `se-config` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
+CREATE DATABASE IF NOT EXISTS `se-config` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
@@ -34,7 +34,7 @@
insert into config_info(id, data_id, group_id, content, md5, gmt_create, gmt_modified, src_user, src_ip, app_name, tenant_id, c_desc, c_use, effect, type, c_schema, encrypted_data_key) values
(1,'application-dev.yml','DEFAULT_GROUP','spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\n\n# feign 閰嶇疆\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n client:\n config:\n default:\n connectTimeout: 10000\n readTimeout: 10000\n compression:\n request:\n enabled: true\n min-request-size: 8192\n response:\n enabled: true\n\n# 鏆撮湶鐩戞帶绔偣\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n','58dde4e3760499d3bac2d77a3a1e9018','2020-05-20 12:00:00','2023-12-04 08:08:23','nacos','0:0:0:0:0:0:0:1','','','閫氱敤閰嶇疆','null','null','yaml','',''),
-(2,'se-gateway-dev.yml','DEFAULT_GROUP','spring:\n redis:\n host: se-redis\n port: 6379\n password: Redis_s!E_6.2.6\n cloud:\n gateway:\n discovery:\n locator:\n lowerCaseServiceId: true\n enabled: true\n routes:\n # 璁よ瘉涓績\n - id: se-auth\n uri: lb://se-auth\n predicates:\n - Path=/auth/**\n filters:\n # 楠岃瘉鐮佸鐞哱n - CacheRequestFilter\n - ValidateCodeFilter\n - StripPrefix=1\n # 浠ｇ爜鐢熸垚\n - id: se-gen\n uri: lb://se-gen\n predicates:\n - Path=/code/**\n filters:\n - StripPrefix=1\n # 瀹氭椂浠诲姟\n - id: se-job\n uri: lb://se-job\n predicates:\n - Path=/schedule/**\n filters:\n - StripPrefix=1\n # 绯荤粺妯″潡\n - id: se-system\n uri: lb://se-system\n predicates:\n - Path=/system/**\n filters:\n - StripPrefix=1\n # 鏂囦欢鏈嶅姟\n - id: se-file\n uri: lb://se-file\n predicates:\n - Path=/file/**\n filters:\n - StripPrefix=1\n\n# 瀹夊叏閰嶇疆\nsecurity:\n # 楠岃瘉鐮� math,char\n captcha:\n enabled: false\n type: math\n # 闃叉XSS鏀诲嚮\n xss:\n enabled: true\n excludeUrls:\n - /system/notice\n # 涓嶆牎楠岀櫧鍚嶅崟\n ignore:\n whites:\n - /auth/logout\n - /auth/login\n - /auth/register\n - /*/v2/api-docs\n - /csrf\n','57cec5abd0e0a6b77d853750344a9dc0','2020-05-14 14:17:55','2022-09-29 02:48:32','nacos','0:0:0:0:0:0:0:1','','','缃戝叧妯″潡','null','null','yaml','',''),
+(2,'se-gateway-dev.yml','DEFAULT_GROUP','spring:\n redis:\n host: se-redis\n port: 6379\n password: Redis_s!E_6.2.6\n cloud:\n gateway:\n discovery:\n locator:\n lowerCaseServiceId: true\n enabled: true\n routes:\n # 璁よ瘉涓績\n - id: se-auth\n uri: lb://se-auth\n predicates:\n - Path=/auth/**\n filters:\n # 楠岃瘉鐮佸鐞哱n - CacheRequestFilter\n - ValidateCodeFilter\n - StripPrefix=1\n # 浠ｇ爜鐢熸垚\n - id: se-gen\n uri: lb://se-gen\n predicates:\n - Path=/code/**\n filters:\n - StripPrefix=1\n # 瀹氭椂浠诲姟\n - id: se-job\n uri: lb://se-job\n predicates:\n - Path=/schedule/**\n filters:\n - StripPrefix=1\n # 绯荤粺妯″潡\n - id: se-system\n uri: lb://se-system\n predicates:\n - Path=/system/**\n filters:\n - StripPrefix=1\n # 鏂囦欢鏈嶅姟\n - id: se-file\n uri: lb://se-file\n predicates:\n - Path=/file/**\n filters:\n - StripPrefix=1\n\n# 瀹夊叏閰嶇疆\nsecurity:\n # 楠岃瘉鐮� math,char\n captcha:\n enabled: false\n type: math\n # 闃叉XSS鏀诲嚮\n xss:\n enabled: true\n excludeUrls:\n - /system/notice\n # 涓嶆牎楠岀櫧鍚嶅崟\n ignore:\n whites:\n - /*/health\n - /auth/logout\n - /auth/login\n - /auth/register\n - /*/v2/api-docs\n - /csrf\n','57cec5abd0e0a6b77d853750344a9dc0','2020-05-14 14:17:55','2022-09-29 02:48:32','nacos','0:0:0:0:0:0:0:1','','','缃戝叧妯″潡','null','null','yaml','',''),
(3,'se-auth-dev.yml','DEFAULT_GROUP','spring:\n redis:\n host: se-redis\n port: 6379\n password: Redis_s!E_6.2.6\n','8bd9dada9a94822feeab40de55efced6','2020-11-20 00:00:00','2022-09-29 02:48:42','nacos','0:0:0:0:0:0:0:1','','','璁よ瘉涓績','null','null','yaml','',''),
(4,'se-monitor-dev.yml','DEFAULT_GROUP','# spring\nspring:\n security:\n user:\n name: se\n password: 123456\n boot:\n admin:\n ui:\n title: 鏈嶅姟鐘舵�佺洃鎺n','6f122fd2bfb8d45f858e7d6529a9cd44','2020-11-20 00:00:00','2022-09-29 02:48:54','nacos','0:0:0:0:0:0:0:1','','','鐩戞帶涓績','null','null','yaml','',''),
(5,'se-system-dev.yml','DEFAULT_GROUP','# spring閰嶇疆\nspring:\n redis:\n host: se-redis\n port: 6379\n password: Redis_s!E_6.2.6\n datasource:\n druid:\n stat-view-servlet:\n enabled: false\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n connectTimeout: 30000\n socketTimeout: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n # 涓诲簱鏁版嵁婧怽n master:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://se-mysql:3306/se-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: My_Sql_s!E_v5.7\n # 浠庡簱鏁版嵁婧怽n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\n# mybatis閰嶇疆\nmybatis:\n # 鎼滅储鎸囧畾鍖呭埆鍚峔n typeAliasesPackage: com.se.system\n # 閰嶇疆mapper鐨勬壂鎻忥紝鎵惧埌鎵�鏈夌殑mapper.xml鏄犲皠鏂囦欢\n mapperLocations: classpath:mapper/**/*.xml\n\n# swagger閰嶇疆\nswagger:\n title: 绯荤粺妯″潡鎺ュ彛鏂囨。\n license: Powered By se','00678c89684ec0b825cb9b71e032db64','2020-11-20 00:00:00','2023-12-04 07:51:28','nacos','0:0:0:0:0:0:0:1','','','绯荤粺妯″潡','null','null','yaml','',''),
diff --git a/docker-compose/mysql/initdb/se_quartz.sql b/docker-compose/mysql/initdb/se_quartz.sql
index 6b6e705..e3ccdff 100644
--- a/docker-compose/mysql/initdb/se_quartz.sql
+++ b/docker-compose/mysql/initdb/se_quartz.sql
@@ -1,6 +1,6 @@
-- DROP DATABASE IF EXISTS `se-cloud`;
-CREATE DATABASE IF NOT EXISTS `se-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
+CREATE DATABASE IF NOT EXISTS `se-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
diff --git a/docker-compose/mysql/initdb/se_seata_20210128.sql b/docker-compose/mysql/initdb/se_seata_20210128.sql
index a6b74a9..7405280 100644
--- a/docker-compose/mysql/initdb/se_seata_20210128.sql
+++ b/docker-compose/mysql/initdb/se_seata_20210128.sql
@@ -1,6 +1,6 @@
-DROP DATABASE IF EXISTS `se-seata`;
+-- DROP DATABASE IF EXISTS `se-seata`;
-CREATE DATABASE `se-seata` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
+CREATE DATABASE IF NOT EXISTS `se-seata` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
diff --git a/docker-compose/nacos/conf/application.properties b/docker-compose/nacos/conf/application.properties
index f5022db..f6169c8 100644
--- a/docker-compose/nacos/conf/application.properties
+++ b/docker-compose/nacos/conf/application.properties
@@ -155,7 +155,7 @@
nacos.core.auth.caching.enabled=true
### Since 1.4.1, Turn on/off white auth for user-agent: nacos-server, only for upgrade from old version.
-nacos.core.auth.enable.userAgentAuthWhite=false
+nacos.core.auth.enable.userAgentAuthWhite=true
### Since 1.4.1, worked when nacos.core.auth.enabled=true and nacos.core.auth.enable.userAgentAuthWhite=false.
### The two properties is the white list for auth and used by identity the request from other server.
@@ -167,7 +167,7 @@
nacos.core.auth.plugin.nacos.token.cache.enable=false
nacos.core.auth.plugin.nacos.token.expire.seconds=18000
### The default token (Base64 String):
-nacos.core.auth.plugin.nacos.token.secret.key=
+nacos.core.auth.plugin.nacos.token.secret.key=VGhpc0lzTXlDdXN0b21TZWNyZXRLZXkwMTIzNDU2Nzg=
### worked when nacos.core.auth.system.type=ldap锛寋0} is Placeholder,replace login username
#nacos.core.auth.ldap.url=ldap://localhost:389
diff --git a/docker-compose/nginx/conf/nginx.conf b/docker-compose/nginx/conf/nginx.conf
index ba639ab..e3efd20 100644
--- a/docker-compose/nginx/conf/nginx.conf
+++ b/docker-compose/nginx/conf/nginx.conf
@@ -19,8 +19,20 @@
try_files $uri $uri/ /index.html;
index index.html index.htm;
}
-
- location /prod-api/{
+
+ location /sso {
+ alias /usr/share/nginx/html/sso;
+ try_files $uri $uri/ /sso/;
+ #index index.html index.htm;
+ }
+
+ location /sys {
+ alias /usr/share/nginx/html/sys;
+ try_files $uri $uri/ /sys/;
+ #index index.html index.htm;
+ }
+
+ location /prod-api/ {
proxy_set_header Host $http_host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header REMOTE-HOST $remote_addr;
@@ -29,7 +41,7 @@
proxy_pass http://se-gateway:8080/;
}
- # 閬垮厤actuator鏆撮湶
+ # actuator
if ($request_uri ~ "/actuator") {
return 403;
}
diff --git a/se-api/se-api-system/src/main/java/com/se/system/api/domain/SysUser.java b/se-api/se-api-system/src/main/java/com/se/system/api/domain/SysUser.java
index 4c6525d..6c561d6 100644
--- a/se-api/se-api-system/src/main/java/com/se/system/api/domain/SysUser.java
+++ b/se-api/se-api-system/src/main/java/com/se/system/api/domain/SysUser.java
@@ -37,6 +37,10 @@
@Excel(name = "鐢ㄦ埛鍚嶇О")
private String nickName;
+ /** 瀵嗙骇绫诲瀷 */
+ @Excel(name = "瀵嗙骇绫诲瀷")
+ private String secretLevel;
+
/** 鐢ㄦ埛閭 */
@Excel(name = "鐢ㄦ埛閭")
private String email;
@@ -129,6 +133,16 @@
this.deptId = deptId;
}
+ @Xss(message = "瀵嗙骇绫诲瀷涓嶈兘鍖呭惈鑴氭湰瀛楃")
+ @Size(min = 1, max = 2, message = "瀵嗙骇绫诲瀷闀垮害涓嶈兘瓒呰繃2涓瓧绗�")
+ public String getSecretLevel() {
+ return secretLevel;
+ }
+
+ public void setSecretLevel(String secretLevel) {
+ this.secretLevel = secretLevel;
+ }
+
@Xss(message = "鐢ㄦ埛鏄电О涓嶈兘鍖呭惈鑴氭湰瀛楃")
@Size(min = 0, max = 30, message = "鐢ㄦ埛鏄电О闀垮害涓嶈兘瓒呰繃30涓瓧绗�")
public String getNickName()
diff --git a/se-auth/pom.xml b/se-auth/pom.xml
index 09989cd..711eefa 100644
--- a/se-auth/pom.xml
+++ b/se-auth/pom.xml
@@ -51,7 +51,14 @@
<groupId>com.se</groupId>
<artifactId>se-common-security</artifactId>
</dependency>
-
+
+ <!--lombok-->
+ <dependency>
+ <groupId>org.projectlombok</groupId>
+ <artifactId>lombok</artifactId>
+ <version>1.18.22</version>
+ <optional>true</optional>
+ </dependency>
</dependencies>
<build>
diff --git a/se-auth/se-auth.iml b/se-auth/se-auth.iml
index d25cbcd..bd45c6c 100644
--- a/se-auth/se-auth.iml
+++ b/se-auth/se-auth.iml
@@ -11,12 +11,12 @@
</facet>
</component>
<component name="NewModuleRootManager" LANGUAGE_LEVEL="JDK_1_8">
- <output url="file://$MODULE_DIR$/../se-auth/target/classes" />
- <output-test url="file://$MODULE_DIR$/../se-auth/target/test-classes" />
- <content url="file://$MODULE_DIR$/../se-auth">
- <sourceFolder url="file://$MODULE_DIR$/../se-auth/src/main/java" isTestSource="false" />
- <sourceFolder url="file://$MODULE_DIR$/../se-auth/src/main/resources" type="java-resource" />
- <excludeFolder url="file://$MODULE_DIR$/../se-auth/target" />
+ <output url="file://$MODULE_DIR$/target/classes" />
+ <output-test url="file://$MODULE_DIR$/target/test-classes" />
+ <content url="file://$MODULE_DIR$">
+ <sourceFolder url="file://$MODULE_DIR$/src/main/java" isTestSource="false" />
+ <sourceFolder url="file://$MODULE_DIR$/src/main/resources" type="java-resource" />
+ <excludeFolder url="file://$MODULE_DIR$/target" />
</content>
<orderEntry type="jdk" jdkName="jdk-1.8" jdkType="JavaSDK" />
<orderEntry type="sourceFolder" forTests="false" />
@@ -163,6 +163,7 @@
<orderEntry type="library" name="Maven: io.lettuce:lettuce-core:6.1.10.RELEASE" level="project" />
<orderEntry type="library" name="Maven: io.projectreactor:reactor-core:3.4.34" level="project" />
<orderEntry type="library" name="Maven: org.reactivestreams:reactive-streams:1.0.4" level="project" />
+ <orderEntry type="library" name="Maven: org.projectlombok:lombok:1.18.30" level="project" />
<orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-starter-bootstrap:3.1.7" level="project" />
<orderEntry type="library" name="Maven: org.springframework.cloud:spring-cloud-starter:3.1.7" level="project" />
<orderEntry type="library" name="Maven: org.springframework.security:spring-security-rsa:1.0.11.RELEASE" level="project" />
diff --git a/se-auth/src/main/java/com/se/auth/controller/HealthController.java b/se-auth/src/main/java/com/se/auth/controller/HealthController.java
new file mode 100644
index 0000000..dc39dc1
--- /dev/null
+++ b/se-auth/src/main/java/com/se/auth/controller/HealthController.java
@@ -0,0 +1,20 @@
+package com.se.auth.controller;
+
+import com.se.common.core.web.controller.BaseController;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+/**
+ * 鍋ュ悍鎺у埗鍣�
+ *
+ * @author WWW
+ * @date 2024-08-24
+ */
+@RestController
+public class HealthController extends BaseController {
+ @GetMapping("/health")
+ public long test() {
+ return System.currentTimeMillis();
+ }
+}
diff --git a/se-auth/src/main/java/com/se/auth/controller/TokenController.java b/se-auth/src/main/java/com/se/auth/controller/TokenController.java
index 843cd7e..7cba290 100644
--- a/se-auth/src/main/java/com/se/auth/controller/TokenController.java
+++ b/se-auth/src/main/java/com/se/auth/controller/TokenController.java
@@ -6,10 +6,7 @@
import com.se.auth.form.RegisterBody;
import com.se.auth.service.SysLoginService;
import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.web.bind.annotation.DeleteMapping;
-import org.springframework.web.bind.annotation.PostMapping;
-import org.springframework.web.bind.annotation.RequestBody;
-import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.bind.annotation.*;
import com.se.common.core.domain.R;
import com.se.common.core.utils.JwtUtils;
import com.se.common.core.utils.StringUtils;
@@ -41,6 +38,23 @@
return R.ok(tokenService.createToken(userInfo));
}
+ @GetMapping("validate")
+ @PostMapping("validate")
+ public R<Object> validate(HttpServletRequest request) {
+ try {
+ boolean flag = false;
+ String token = SecurityUtils.getToken(request);
+ if (!StringUtils.isNotEmpty(token)) {
+ String userName = JwtUtils.getUserName(token);
+ flag = !StringUtils.isEmpty(userName);
+ }
+
+ return R.ok(flag);
+ } catch (Exception ex) {
+ return R.fail(ex.getMessage());
+ }
+ }
+
@DeleteMapping("logout")
public R<?> logout(HttpServletRequest request)
{
diff --git a/se-auth/src/main/java/com/se/auth/service/AsyncService.java b/se-auth/src/main/java/com/se/auth/service/AsyncService.java
new file mode 100644
index 0000000..4c59740
--- /dev/null
+++ b/se-auth/src/main/java/com/se/auth/service/AsyncService.java
@@ -0,0 +1,35 @@
+package com.se.auth.service;
+
+import lombok.SneakyThrows;
+import lombok.extern.slf4j.Slf4j;
+import org.springframework.stereotype.Service;
+
+import java.util.concurrent.ExecutorService;
+import java.util.concurrent.Executors;
+
+/**
+ * 寮傛鏈嶅姟
+ *
+ * @author WWW
+ * @date 2024-08-25
+ */
+@Slf4j
+@Service
+@SuppressWarnings("ALL")
+public class AsyncService {
+ public void asyncCall() {
+ try {
+ ExecutorService executor = Executors.newSingleThreadExecutor();
+ executor.execute(new Runnable() {
+ @Override
+ @SneakyThrows
+ public void run() {
+ //
+ }
+ });
+ executor.shutdown();
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ }
+ }
+}
diff --git a/se-auth/src/main/java/com/se/auth/service/SysPasswordService.java b/se-auth/src/main/java/com/se/auth/service/SysPasswordService.java
index fbd3d8d..8efc6ab 100644
--- a/se-auth/src/main/java/com/se/auth/service/SysPasswordService.java
+++ b/se-auth/src/main/java/com/se/auth/service/SysPasswordService.java
@@ -16,6 +16,7 @@
* @author admin
*/
@Component
+@SuppressWarnings("ALL")
public class SysPasswordService
{
@Autowired
@@ -50,12 +51,12 @@
retryCount = 0;
}
- if (retryCount >= Integer.valueOf(maxRetryCount).intValue())
+ /*if (retryCount >= Integer.valueOf(maxRetryCount).intValue())
{
String errMsg = String.format("瀵嗙爜杈撳叆閿欒%s娆★紝甯愭埛閿佸畾%s鍒嗛挓", maxRetryCount, lockTime);
recordLogService.recordLogininfor(username, Constants.LOGIN_FAIL,errMsg);
throw new ServiceException(errMsg);
- }
+ }*/
if (!matches(user, password))
{
diff --git a/se-auth/src/main/resources/bootstrap.yml b/se-auth/src/main/resources/bootstrap.yml
index b1cd911..5e1086f 100644
--- a/se-auth/src/main/resources/bootstrap.yml
+++ b/se-auth/src/main/resources/bootstrap.yml
@@ -14,9 +14,11 @@
nacos:
discovery:
# 鏈嶅姟娉ㄥ唽鍦板潃
+ #server-addr: 192.168.11.203:8848
server-addr: 127.0.0.1:8848
config:
# 閰嶇疆涓績鍦板潃
+ #server-addr: 192.168.11.203:8848
server-addr: 127.0.0.1:8848
# 閰嶇疆鏂囦欢鏍煎紡
file-extension: yml
diff --git a/se.iml b/se-cloud.iml
similarity index 100%
rename from se.iml
rename to se-cloud.iml
diff --git a/se-common/se-common-core/src/main/java/com/se/common/core/constant/TokenConstants.java b/se-common/se-common-core/src/main/java/com/se/common/core/constant/TokenConstants.java
index 626e5a9..51fa6f1 100644
--- a/se-common/se-common-core/src/main/java/com/se/common/core/constant/TokenConstants.java
+++ b/se-common/se-common-core/src/main/java/com/se/common/core/constant/TokenConstants.java
@@ -5,8 +5,22 @@
*
* @author admin
*/
-public class TokenConstants
-{
+public class TokenConstants {
+ /**
+ * 浠ょ墝鏍囪瘑-URL
+ */
+ public static final String TOKEN = "token";
+
+ /**
+ * 浠ょ墝鏍囪瘑-URL
+ */
+ public static final String ACCESS_TOKEN = "accessToken";
+
+ /**
+ * 浠ょ墝鏍囪瘑-Cookie
+ */
+ public static final String COOKIE_TOKEN = "Admin-Token";
+
/**
* 浠ょ墝鑷畾涔夋爣璇�
*/
@@ -21,5 +35,4 @@
* 浠ょ墝绉橀挜
*/
public final static String SECRET = "abcdefghijklmnopqrstuvwxyz";
-
}
diff --git a/se-common/se-common-core/src/main/java/com/se/common/core/utils/AesUtils.java b/se-common/se-common-core/src/main/java/com/se/common/core/utils/AesUtils.java
new file mode 100644
index 0000000..1076e28
--- /dev/null
+++ b/se-common/se-common-core/src/main/java/com/se/common/core/utils/AesUtils.java
@@ -0,0 +1,130 @@
+package com.se.common.core.utils;
+
+import javax.crypto.Cipher;
+import javax.crypto.spec.SecretKeySpec;
+import java.util.Base64;
+
+/**
+ * AES鍔犲瘑宸ュ叿
+ *
+ * @author WWW
+ * @date 2024-08-25
+ */
+@SuppressWarnings("ALL")
+public class AesUtils {
+ /**
+ * 瀵嗛挜闀垮害蹇呴』鏄�16
+ */
+ private static final String DEFAULT_KEY = "A#s_zZ_sErve_k.y";
+
+ private static final String KEY_ALGORITHM = "AES";
+
+ /**
+ * 绠楁硶
+ */
+ private static final String ALGORITHMSTR = "AES/ECB/PKCS5Padding";
+
+ /**
+ * aes瑙ｅ瘑
+ *
+ * @param encrypt 鍐呭
+ * @return
+ * @throws Exception
+ */
+ public static String decrypt(String encrypt) throws Exception {
+ return decrypt(encrypt, DEFAULT_KEY);
+ }
+
+ /**
+ * aes鍔犲瘑
+ *
+ * @param content 鍐呭
+ * @return
+ * @throws Exception
+ */
+ public static String encrypt(String content) throws Exception {
+ return encrypt(content, DEFAULT_KEY);
+ }
+
+ /**
+ * base 64 encode
+ *
+ * @param bytes 寰呯紪鐮佺殑byte[]
+ * @return 缂栫爜鍚庣殑base64 code
+ */
+ private static String base64Encode(byte[] bytes) {
+ return Base64.getEncoder().encodeToString(bytes);
+ }
+
+ /**
+ * base 64 decode
+ *
+ * @param base64Code 寰呰В鐮佺殑base64 code
+ * @return 瑙ｇ爜鍚庣殑byte[]
+ * @throws Exception
+ */
+ private static byte[] base64Decode(String base64Code) {
+ return StringUtils.isEmpty(base64Code) ? null : Base64.getDecoder().decode(base64Code);
+ }
+
+ /**
+ * AES鍔犲瘑
+ *
+ * @param content 寰呭姞瀵嗙殑鍐呭
+ * @param encryptKey 鍔犲瘑瀵嗛挜
+ * @return 鍔犲瘑鍚庣殑byte[]
+ * @throws Exception
+ */
+ private static byte[] aesEncryptToBytes(String content, String encryptKey) throws Exception {
+ // KeyGenerator kGen = KeyGenerator.getInstance(KEY_ALGORITHM)
+ // kGen.init(128)
+
+ Cipher cipher = Cipher.getInstance(ALGORITHMSTR);
+ cipher.init(Cipher.ENCRYPT_MODE, new SecretKeySpec(encryptKey.getBytes(), KEY_ALGORITHM));
+
+ return cipher.doFinal(content.getBytes("utf-8"));
+ }
+
+ /**
+ * AES鍔犲瘑涓篵ase 64 code
+ *
+ * @param content 寰呭姞瀵嗙殑鍐呭
+ * @param encryptKey 鍔犲瘑瀵嗛挜
+ * @return 鍔犲瘑鍚庣殑base 64 code
+ * @throws Exception
+ */
+ public static String encrypt(String content, String encryptKey) throws Exception {
+ return base64Encode(aesEncryptToBytes(content, encryptKey));
+ }
+
+ /**
+ * 灏哹ase 64 code AES瑙ｅ瘑
+ *
+ * @param encryptStr 寰呰В瀵嗙殑base 64 code
+ * @param decryptKey 瑙ｅ瘑瀵嗛挜
+ * @return 瑙ｅ瘑鍚庣殑string
+ * @throws Exception
+ */
+ public static String decrypt(String encryptStr, String decryptKey) throws Exception {
+ return StringUtils.isEmpty(encryptStr) ? null : aesDecryptByBytes(base64Decode(encryptStr), decryptKey);
+ }
+
+ /**
+ * AES瑙ｅ瘑
+ *
+ * @param encryptBytes 寰呰В瀵嗙殑byte[]
+ * @param decryptKey 瑙ｅ瘑瀵嗛挜
+ * @return 瑙ｅ瘑鍚庣殑String
+ * @throws Exception
+ */
+ private static String aesDecryptByBytes(byte[] encryptBytes, String decryptKey) throws Exception {
+ // KeyGenerator kGen = KeyGenerator.getInstance(KEY_ALGORITHM)
+ // kGen.init(128)
+
+ Cipher cipher = Cipher.getInstance(ALGORITHMSTR);
+ cipher.init(Cipher.DECRYPT_MODE, new SecretKeySpec(decryptKey.getBytes(), KEY_ALGORITHM));
+ byte[] decryptBytes = cipher.doFinal(encryptBytes);
+
+ return new String(decryptBytes);
+ }
+}
diff --git a/se-common/se-common-core/src/main/java/com/se/common/core/utils/RsaUtils.java b/se-common/se-common-core/src/main/java/com/se/common/core/utils/RsaUtils.java
new file mode 100644
index 0000000..27010cf
--- /dev/null
+++ b/se-common/se-common-core/src/main/java/com/se/common/core/utils/RsaUtils.java
@@ -0,0 +1,212 @@
+package com.se.common.core.utils;
+
+import org.apache.commons.codec.binary.Base64;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+import org.springframework.core.io.ClassPathResource;
+
+import javax.crypto.Cipher;
+import java.io.*;
+import java.nio.charset.StandardCharsets;
+import java.security.*;
+import java.security.interfaces.RSAPrivateKey;
+import java.security.interfaces.RSAPublicKey;
+import java.security.spec.PKCS8EncodedKeySpec;
+import java.security.spec.X509EncodedKeySpec;
+import java.util.HashMap;
+import java.util.Map;
+
+/**
+ * RSA宸ュ叿绫�
+ *
+ * @author WWW
+ * @date 2024-08-25
+ */
+public class RsaUtils {
+ /**
+ * 绉侀挜
+ */
+ private static String privateKey;
+
+ /**
+ * 鍏挜
+ */
+ private static String publicKey;
+
+ /**
+ * 瀵嗛挜绠楁硶
+ */
+ private static final String KEY_ALGORITHM = "RSA";
+
+ /**
+ * RSA瀵嗛挜闀垮害锛�1024 鎴� 2048
+ */
+ private static final int DEFAULT_RSA_KEY_SIZE = 1024;
+
+ /**
+ * 鏃ュ織
+ */
+ private static final Logger log = LoggerFactory.getLogger(RsaUtils.class);
+
+ /**
+ * 鐢熸垚鍏閽�
+ */
+ public static void generate() {
+ Map<String, String> result = generateRsaKey(DEFAULT_RSA_KEY_SIZE);
+ System.out.println("鍏挜涓猴細" + result.get("publicKey"));
+ System.out.println("绉侀挜涓猴細" + result.get("privateKey"));
+ }
+
+ /**
+ * 鑾峰彇RSA鍔犲瘑绉侀挜
+ *
+ * @return
+ * @throws IOException
+ */
+ public static String getPrivateKey() throws IOException {
+ if (privateKey == null) {
+ InputStream inPrivate = new ClassPathResource("config" + File.separator + "rsa_private_key.txt").getInputStream();
+ privateKey = inputStream2String(inPrivate);
+ inPrivate.close();
+ }
+
+ return privateKey;
+ }
+
+ /**
+ * 鑾峰彇RSA鍔犲瘑鍏挜
+ *
+ * @return
+ * @throws IOException
+ */
+ public static String getPublicKey() throws IOException {
+ if (publicKey == null) {
+ InputStream inPrivate = new ClassPathResource("config" + File.separator + "rsa_public_key.txt").getInputStream();
+ publicKey = inputStream2String(inPrivate);
+ inPrivate.close();
+ }
+
+ return publicKey;
+ }
+
+ /**
+ * 璇诲彇鏂囨湰鏂囦欢
+ *
+ * @param fileName 鏂囦欢璺緞
+ * @return
+ * @throws IOException
+ */
+ public static String readFile(String fileName) throws IOException {
+ File file = new File(fileName);
+ BufferedReader br = new BufferedReader(new FileReader(file));
+
+ StringBuilder result = new StringBuilder();
+
+ String line = null;
+ while ((line = br.readLine()) != null) {
+ result.append(System.lineSeparator() + line);
+ }
+ br.close();
+
+ return result.toString();
+ }
+
+ /**
+ * 鎶奿nputStream杞垚String
+ *
+ * @param is
+ * @return
+ * @throws IOException
+ */
+ private static String inputStream2String(InputStream is) throws IOException {
+ ByteArrayOutputStream baos = new ByteArrayOutputStream();
+
+ int i = -1;
+ while ((i = is.read()) != -1) {
+ baos.write(i);
+ }
+
+ String str = baos.toString();
+ baos.close();
+
+ return str;
+ }
+
+ /**
+ * 鐢熸垚RSA鐨勫叕绉侀挜
+ *
+ * @param keySize 1025 鎴� 2048
+ * @return
+ */
+ public static Map<String, String> generateRsaKey(int keySize) {
+ Map<String, String> result = new HashMap<>(2);
+ try {
+ KeyPairGenerator keyPairGen = KeyPairGenerator.getInstance(KEY_ALGORITHM);
+
+ // 鍒濆鍖栧瘑閽ュ鐢熸垚鍣紝瀵嗛挜澶у皬涓�1024 2048浣�
+ keyPairGen.initialize(keySize, new SecureRandom());
+
+ // 鐢熸垚涓�涓瘑閽ュ锛屼繚瀛樺湪keyPair涓�
+ KeyPair keyPair = keyPairGen.generateKeyPair();
+
+ // 寰楀埌鍏挜瀛楃涓�
+ String pub = new String(Base64.encodeBase64(keyPair.getPublic().getEncoded()));
+ result.put("publicKey", pub);
+
+ // 寰楀埌绉侀挜瀛楃涓�
+ String pri = new String(Base64.encodeBase64(keyPair.getPrivate().getEncoded()));
+ result.put("privateKey", pri);
+ } catch (Exception ex) {
+ log.error(ex.getMessage(), ex);
+ }
+
+ return result;
+ }
+
+ /**
+ * RSA绉侀挜瑙ｅ瘑
+ *
+ * @param str 鍔犲瘑鐨勫瓧绗︿覆
+ * @return 瑙ｅ瘑瀛楃涓�
+ * @throws Exception 鍔犲瘑杩囩▼涓殑寮傚父淇℃伅
+ */
+ public static String decrypt(String str) throws Exception {
+ // 64浣嶈В鐮佸姞瀵嗗悗鐨勫瓧绗︿覆
+ byte[] inputByte = Base64.decodeBase64(str.getBytes(StandardCharsets.UTF_8));
+
+ // Base64缂栫爜鐨勭閽�
+ byte[] decoded = Base64.decodeBase64(getPrivateKey());
+ RSAPrivateKey priKey = (RSAPrivateKey) KeyFactory.getInstance("RSA").generatePrivate(new PKCS8EncodedKeySpec(decoded));
+
+ // RSA瑙ｅ瘑锛歊SA/ECB/NoPadding
+ Cipher cipher = Cipher.getInstance("RSA");
+ cipher.init(Cipher.DECRYPT_MODE, priKey);
+
+ String outStr = new String(cipher.doFinal(inputByte));
+
+ return outStr;
+ }
+
+ /**
+ * RSA鍏挜鍔犲瘑
+ *
+ * @param str 闇�瑕佸姞瀵嗙殑瀛楃涓�
+ * @return 瀵嗘枃
+ * @throws Exception 鍔犲瘑杩囩▼涓殑寮傚父淇℃伅
+ */
+ public static String encrypt(String str) throws Exception {
+ // Base64缂栫爜鐨勫叕閽�
+ byte[] decoded = Base64.decodeBase64(getPublicKey());
+
+ RSAPublicKey pubKey = (RSAPublicKey) KeyFactory.getInstance("RSA").generatePublic(new X509EncodedKeySpec(decoded));
+
+ // RSA鍔犲瘑锛歊SA/ECB/NoPadding
+ Cipher cipher = Cipher.getInstance("RSA");
+ cipher.init(Cipher.ENCRYPT_MODE, pubKey);
+
+ String outStr = Base64.encodeBase64String(cipher.doFinal(str.getBytes(StandardCharsets.UTF_8)));
+
+ return outStr;
+ }
+}
+
diff --git a/se-common/se-common-core/src/main/java/com/se/common/core/utils/StringUtils.java b/se-common/se-common-core/src/main/java/com/se/common/core/utils/StringUtils.java
index 71c6dc1..50148dc 100644
--- a/se-common/se-common-core/src/main/java/com/se/common/core/utils/StringUtils.java
+++ b/se-common/se-common-core/src/main/java/com/se/common/core/utils/StringUtils.java
@@ -8,6 +8,9 @@
import com.se.common.core.text.StrFormatter;
import org.springframework.util.AntPathMatcher;
+import javax.servlet.http.Cookie;
+import javax.servlet.http.HttpServletRequest;
+
/**
* 瀛楃涓插伐鍏风被
*
@@ -605,4 +608,19 @@
}
return sb.toString();
}
+
+ public static String getValueFromCookie(HttpServletRequest request,String key) {
+ Cookie[] cookies = request.getCookies();
+ if (cookies == null || cookies.length == 0) {
+ return null;
+ }
+
+ for (Cookie cookie : cookies) {
+ if (cookie.getName().equals(key)){
+ return cookie.getValue();
+ }
+ }
+
+ return null;
+ }
}
diff --git a/se-common/se-common-security/src/main/java/com/se/common/security/utils/SecurityUtils.java b/se-common/se-common-security/src/main/java/com/se/common/security/utils/SecurityUtils.java
index c5d1a12..dce85f3 100644
--- a/se-common/se-common-security/src/main/java/com/se/common/security/utils/SecurityUtils.java
+++ b/se-common/se-common-security/src/main/java/com/se/common/security/utils/SecurityUtils.java
@@ -59,10 +59,23 @@
/**
* 鏍规嵁request鑾峰彇璇锋眰token
*/
- public static String getToken(HttpServletRequest request)
- {
+ public static String getToken(HttpServletRequest request) {
// 浠巋eader鑾峰彇token鏍囪瘑
String token = request.getHeader(TokenConstants.AUTHENTICATION);
+
+ // 浠巙rl鑾峰彇token鏍囪瘑
+ if (StringUtils.isEmpty(token)) {
+ token = request.getParameter(TokenConstants.ACCESS_TOKEN);
+ }
+ if (StringUtils.isEmpty(token)) {
+ token = request.getParameter(TokenConstants.TOKEN);
+ }
+
+ // 浠巆ookie鑾峰彇token鏍囪瘑
+ if (StringUtils.isEmpty(token)) {
+ token = StringUtils.getValueFromCookie(request, TokenConstants.COOKIE_TOKEN);
+ }
+
return replaceTokenPrefix(token);
}
diff --git a/se-gateway/src/main/java/com/se/gateway/config/CorsConfig.java b/se-gateway/src/main/java/com/se/gateway/config/CorsConfig.java
new file mode 100644
index 0000000..b6a358f
--- /dev/null
+++ b/se-gateway/src/main/java/com/se/gateway/config/CorsConfig.java
@@ -0,0 +1,59 @@
+package com.se.gateway.config;
+
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.http.HttpHeaders;
+import org.springframework.http.HttpMethod;
+import org.springframework.http.HttpStatus;
+import org.springframework.http.server.reactive.ServerHttpRequest;
+import org.springframework.http.server.reactive.ServerHttpResponse;
+import org.springframework.web.cors.reactive.CorsUtils;
+import org.springframework.web.server.ServerWebExchange;
+import org.springframework.web.server.WebFilter;
+import org.springframework.web.server.WebFilterChain;
+import reactor.core.publisher.Mono;
+
+/**
+ * 璺ㄥ煙閰嶇疆
+ *
+ * @author se
+ * @date 2024-08-28
+ */
+@Configuration
+public class CorsConfig
+{
+ /**
+ * 杩欓噷涓烘敮鎸佺殑璇锋眰澶达紝濡傛灉鏈夎嚜瀹氫箟鐨刪eader瀛楁璇疯嚜宸辨坊鍔�
+ */
+ // private static final String ALLOWED_HEADERS = "X-Requested-With, Content-Type, Authorization, credential, X-XSRF-TOKEN, token, Admin-Token, App-Token"
+ private static final String ALLOWED_HEADERS = "*";
+ private static final String ALLOWED_METHODS = "GET,POST,PUT,DELETE,OPTIONS,HEAD";
+ private static final String ALLOWED_ORIGIN = "*";
+ private static final String ALLOWED_EXPOSE = "*";
+ private static final String MAX_AGE = "18000L";
+
+ @Bean
+ public WebFilter corsFilter()
+ {
+ return (ServerWebExchange ctx, WebFilterChain chain) -> {
+ ServerHttpRequest request = ctx.getRequest();
+ if (CorsUtils.isCorsRequest(request))
+ {
+ ServerHttpResponse response = ctx.getResponse();
+ HttpHeaders headers = response.getHeaders();
+ headers.add("Access-Control-Allow-Headers", ALLOWED_HEADERS);
+ headers.add("Access-Control-Allow-Methods", ALLOWED_METHODS);
+ headers.add("Access-Control-Allow-Origin", ALLOWED_ORIGIN);
+ headers.add("Access-Control-Expose-Headers", ALLOWED_EXPOSE);
+ headers.add("Access-Control-Max-Age", MAX_AGE);
+ headers.add("Access-Control-Allow-Credentials", "true");
+ if (request.getMethod() == HttpMethod.OPTIONS)
+ {
+ response.setStatusCode(HttpStatus.OK);
+ return Mono.empty();
+ }
+ }
+ return chain.filter(ctx);
+ };
+ }
+}
diff --git a/se-gateway/src/main/java/com/se/gateway/handler/HealthController.java b/se-gateway/src/main/java/com/se/gateway/handler/HealthController.java
new file mode 100644
index 0000000..74a663f
--- /dev/null
+++ b/se-gateway/src/main/java/com/se/gateway/handler/HealthController.java
@@ -0,0 +1,21 @@
+package com.se.gateway.handler;
+
+import com.se.common.core.web.controller.BaseController;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+/**
+ * 鍋ュ悍鎺у埗鍣�
+ *
+ * @author WWW
+ * @date 2024-08-24
+ */
+@RestController
+@RequestMapping("/gateway")
+public class HealthController extends BaseController {
+ @GetMapping("/health")
+ public long test() {
+ return System.currentTimeMillis();
+ }
+}
diff --git a/se-gateway/src/main/java/com/se/gateway/handler/SwaggerHandler.java b/se-gateway/src/main/java/com/se/gateway/handler/SwaggerHandler.java
index edc42c1..3ba2d0f 100644
--- a/se-gateway/src/main/java/com/se/gateway/handler/SwaggerHandler.java
+++ b/se-gateway/src/main/java/com/se/gateway/handler/SwaggerHandler.java
@@ -32,6 +32,11 @@
this.swaggerResources = swaggerResources;
}
+ @GetMapping("/health")
+ public long health() {
+ return System.currentTimeMillis();
+ }
+
@GetMapping("/configuration/security")
public Mono<ResponseEntity<SecurityConfiguration>> securityConfiguration()
{
diff --git a/se-gateway/src/main/resources/bootstrap.yml b/se-gateway/src/main/resources/bootstrap.yml
index 330e125..a33bfe4 100644
--- a/se-gateway/src/main/resources/bootstrap.yml
+++ b/se-gateway/src/main/resources/bootstrap.yml
@@ -14,9 +14,11 @@
nacos:
discovery:
# 鏈嶅姟娉ㄥ唽鍦板潃
+ #server-addr: 192.168.11.203:8848
server-addr: 127.0.0.1:8848
config:
# 閰嶇疆涓績鍦板潃
+ #server-addr: 192.168.11.203:8848
server-addr: 127.0.0.1:8848
# 閰嶇疆鏂囦欢鏍煎紡
file-extension: yml
@@ -33,6 +35,7 @@
datasource:
ds1:
nacos:
+ #server-addr: 192.168.11.203:8848
server-addr: 127.0.0.1:8848
dataId: sentinel-se-gateway
groupId: DEFAULT_GROUP
diff --git a/se-modules/se-system/src/main/java/com/se/system/controller/HealthController.java b/se-modules/se-system/src/main/java/com/se/system/controller/HealthController.java
new file mode 100644
index 0000000..2a2b41b
--- /dev/null
+++ b/se-modules/se-system/src/main/java/com/se/system/controller/HealthController.java
@@ -0,0 +1,19 @@
+package com.se.system.controller;
+
+import com.se.common.core.web.controller.BaseController;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+/**
+ * 鍋ュ悍鎺у埗鍣�
+ *
+ * @author WWW
+ * @date 2024-08-24
+ */
+@RestController
+public class HealthController extends BaseController {
+ @GetMapping("/health")
+ public long test() {
+ return System.currentTimeMillis();
+ }
+}
diff --git a/se-modules/se-system/src/main/java/com/se/system/controller/SysUserController.java b/se-modules/se-system/src/main/java/com/se/system/controller/SysUserController.java
index 3b9d05d..b6d3ea3 100644
--- a/se-modules/se-system/src/main/java/com/se/system/controller/SysUserController.java
+++ b/se-modules/se-system/src/main/java/com/se/system/controller/SysUserController.java
@@ -165,16 +165,18 @@
* @return 鐢ㄦ埛淇℃伅
*/
@GetMapping("getInfo")
- public AjaxResult getInfo()
- {
+ public AjaxResult getInfo() {
SysUser user = userService.selectUserById(SecurityUtils.getUserId());
// 瑙掕壊闆嗗悎
Set<String> roles = permissionService.getRolePermission(user);
// 鏉冮檺闆嗗悎
Set<String> permissions = permissionService.getMenuPermission(user);
+ // 宀椾綅闆嗗悎
+ List<String> posts = permissionService.getPostPermission(user);
AjaxResult ajax = AjaxResult.success();
ajax.put("user", user);
ajax.put("roles", roles);
+ ajax.put("posts", posts);
ajax.put("permissions", permissions);
return ajax;
}
diff --git a/se-modules/se-system/src/main/java/com/se/system/service/ISysPermissionService.java b/se-modules/se-system/src/main/java/com/se/system/service/ISysPermissionService.java
index e2fe76f..5a0ab43 100644
--- a/se-modules/se-system/src/main/java/com/se/system/service/ISysPermissionService.java
+++ b/se-modules/se-system/src/main/java/com/se/system/service/ISysPermissionService.java
@@ -1,5 +1,6 @@
package com.se.system.service;
+import java.util.List;
import java.util.Set;
import com.se.system.api.domain.SysUser;
@@ -9,11 +10,10 @@
*
* @author admin
*/
-public interface ISysPermissionService
-{
+public interface ISysPermissionService {
/**
* 鑾峰彇瑙掕壊鏁版嵁鏉冮檺
- *
+ *
* @param userId 鐢ㄦ埛Id
* @return 瑙掕壊鏉冮檺淇℃伅
*/
@@ -21,9 +21,17 @@
/**
* 鑾峰彇鑿滃崟鏁版嵁鏉冮檺
- *
+ *
* @param userId 鐢ㄦ埛Id
* @return 鑿滃崟鏉冮檺淇℃伅
*/
public Set<String> getMenuPermission(SysUser user);
+
+ /**
+ * 鑾峰彇鑿滃崟鏁版嵁鏉冮檺
+ *
+ * @param userId 鐢ㄦ埛Id
+ * @return 鑿滃崟鏉冮檺淇℃伅
+ */
+ public List<String> getPostPermission(SysUser user);
}
diff --git a/se-modules/se-system/src/main/java/com/se/system/service/impl/SysPermissionServiceImpl.java b/se-modules/se-system/src/main/java/com/se/system/service/impl/SysPermissionServiceImpl.java
index 3950578..24387c8 100644
--- a/se-modules/se-system/src/main/java/com/se/system/service/impl/SysPermissionServiceImpl.java
+++ b/se-modules/se-system/src/main/java/com/se/system/service/impl/SysPermissionServiceImpl.java
@@ -1,8 +1,14 @@
package com.se.system.service.impl;
+import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
+import java.util.stream.Collectors;
+
+import com.se.common.core.utils.StringUtils;
+import com.se.system.domain.SysPost;
+import com.se.system.mapper.SysPostMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;
@@ -12,37 +18,37 @@
import com.se.system.service.ISysPermissionService;
import com.se.system.service.ISysRoleService;
+import javax.annotation.Resource;
+
/**
* 鐢ㄦ埛鏉冮檺澶勭悊
*
* @author admin
*/
@Service
-public class SysPermissionServiceImpl implements ISysPermissionService
-{
+public class SysPermissionServiceImpl implements ISysPermissionService {
@Autowired
private ISysRoleService roleService;
@Autowired
private ISysMenuService menuService;
+ @Resource
+ private SysPostMapper postMapper;
+
/**
* 鑾峰彇瑙掕壊鏁版嵁鏉冮檺
- *
+ *
* @param userId 鐢ㄦ埛Id
* @return 瑙掕壊鏉冮檺淇℃伅
*/
@Override
- public Set<String> getRolePermission(SysUser user)
- {
+ public Set<String> getRolePermission(SysUser user) {
Set<String> roles = new HashSet<String>();
// 绠＄悊鍛樻嫢鏈夋墍鏈夋潈闄�
- if (user.isAdmin())
- {
+ if (user.isAdmin()) {
roles.add("admin");
- }
- else
- {
+ } else {
roles.addAll(roleService.selectRolePermissionByUserId(user.getUserId()));
}
return roles;
@@ -50,37 +56,39 @@
/**
* 鑾峰彇鑿滃崟鏁版嵁鏉冮檺
- *
+ *
* @param userId 鐢ㄦ埛Id
* @return 鑿滃崟鏉冮檺淇℃伅
*/
@Override
- public Set<String> getMenuPermission(SysUser user)
- {
+ public Set<String> getMenuPermission(SysUser user) {
Set<String> perms = new HashSet<String>();
// 绠＄悊鍛樻嫢鏈夋墍鏈夋潈闄�
- if (user.isAdmin())
- {
+ if (user.isAdmin()) {
perms.add("*:*:*");
- }
- else
- {
+ } else {
List<SysRole> roles = user.getRoles();
- if (!CollectionUtils.isEmpty(roles))
- {
+ if (!CollectionUtils.isEmpty(roles)) {
// 澶氳鑹茶缃畃ermissions灞炴�э紝浠ヤ究鏁版嵁鏉冮檺鍖归厤鏉冮檺
- for (SysRole role : roles)
- {
+ for (SysRole role : roles) {
Set<String> rolePerms = menuService.selectMenuPermsByRoleId(role.getRoleId());
role.setPermissions(rolePerms);
perms.addAll(rolePerms);
}
- }
- else
- {
+ } else {
perms.addAll(menuService.selectMenuPermsByUserId(user.getUserId()));
}
}
return perms;
}
+
+ @Override
+ public List<String> getPostPermission(SysUser user) {
+ List<SysPost> list = postMapper.selectPostsByUserName(user.getUserName());
+ if (CollectionUtils.isEmpty(list)) {
+ return null;
+ }
+
+ return list.stream().map(SysPost::getPostName).collect(Collectors.toList());
+ }
}
diff --git a/se-modules/se-system/src/main/resources/bootstrap.yml b/se-modules/se-system/src/main/resources/bootstrap.yml
index d1d7e5c..60963fc 100644
--- a/se-modules/se-system/src/main/resources/bootstrap.yml
+++ b/se-modules/se-system/src/main/resources/bootstrap.yml
@@ -14,9 +14,11 @@
nacos:
discovery:
# 鏈嶅姟娉ㄥ唽鍦板潃
+ #server-addr: 192.168.11.203:8848
server-addr: 127.0.0.1:8848
config:
# 閰嶇疆涓績鍦板潃
+ #server-addr: 192.168.11.203:8848
server-addr: 127.0.0.1:8848
# 閰嶇疆鏂囦欢鏍煎紡
file-extension: yml
diff --git a/se-modules/se-system/src/main/resources/mapper/system/SysUserMapper.xml b/se-modules/se-system/src/main/resources/mapper/system/SysUserMapper.xml
index 90c0288..cf65b3e 100644
--- a/se-modules/se-system/src/main/resources/mapper/system/SysUserMapper.xml
+++ b/se-modules/se-system/src/main/resources/mapper/system/SysUserMapper.xml
@@ -9,6 +9,7 @@
<result property="deptId" column="dept_id" />
<result property="userName" column="user_name" />
<result property="nickName" column="nick_name" />
+ <result property="secretLevel" column="secret_level" />
<result property="email" column="email" />
<result property="phonenumber" column="phonenumber" />
<result property="sex" column="sex" />
@@ -47,7 +48,7 @@
</resultMap>
<sql id="selectUserVo">
- select u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark,
+ select u.user_id, u.dept_id, u.user_name, u.nick_name, u.secret_level, u.email, u.avatar, u.phonenumber, u.password, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark,
d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.status as dept_status,
r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.status as role_status
from sys_user u
@@ -57,7 +58,7 @@
</sql>
<select id="selectUserList" parameterType="SysUser" resultMap="SysUserResult">
- select u.user_id, u.dept_id, u.nick_name, u.user_name, u.email, u.avatar, u.phonenumber, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark, d.dept_name, d.leader from sys_user u
+ select u.user_id, u.dept_id, u.nick_name, u.user_name, u.secret_level, u.email, u.avatar, u.phonenumber, u.sex, u.status, u.del_flag, u.login_ip, u.login_date, u.create_by, u.create_time, u.remark, d.dept_name, d.leader from sys_user u
left join sys_dept d on u.dept_id = d.dept_id
where u.del_flag = '0'
<if test="userId != null and userId != 0">
@@ -86,7 +87,7 @@
</select>
<select id="selectAllocatedList" parameterType="SysUser" resultMap="SysUserResult">
- select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.phonenumber, u.status, u.create_time
+ select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.secret_level, u.email, u.phonenumber, u.status, u.create_time
from sys_user u
left join sys_dept d on u.dept_id = d.dept_id
left join sys_user_role ur on u.user_id = ur.user_id
@@ -103,7 +104,7 @@
</select>
<select id="selectUnallocatedList" parameterType="SysUser" resultMap="SysUserResult">
- select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.email, u.phonenumber, u.status, u.create_time
+ select distinct u.user_id, u.dept_id, u.user_name, u.nick_name, u.secret_level, u.email, u.phonenumber, u.status, u.create_time
from sys_user u
left join sys_dept d on u.dept_id = d.dept_id
left join sys_user_role ur on u.user_id = ur.user_id
@@ -148,6 +149,7 @@
<if test="deptId != null and deptId != 0">dept_id,</if>
<if test="userName != null and userName != ''">user_name,</if>
<if test="nickName != null and nickName != ''">nick_name,</if>
+ <if test="secretLevel != null and secretLevel != ''">secret_level,</if>
<if test="email != null and email != ''">email,</if>
<if test="avatar != null and avatar != ''">avatar,</if>
<if test="phonenumber != null and phonenumber != ''">phonenumber,</if>
@@ -162,6 +164,7 @@
<if test="deptId != null and deptId != ''">#{deptId},</if>
<if test="userName != null and userName != ''">#{userName},</if>
<if test="nickName != null and nickName != ''">#{nickName},</if>
+ <if test="secretLevel != null and secretLevel != ''">#{secretLevel},</if>
<if test="email != null and email != ''">#{email},</if>
<if test="avatar != null and avatar != ''">#{avatar},</if>
<if test="phonenumber != null and phonenumber != ''">#{phonenumber},</if>
@@ -180,6 +183,7 @@
<if test="deptId != null and deptId != 0">dept_id = #{deptId},</if>
<if test="userName != null and userName != ''">user_name = #{userName},</if>
<if test="nickName != null and nickName != ''">nick_name = #{nickName},</if>
+ <if test="secretLevel != null and secretLevel != ''">secret_level = #{secretLevel},</if>
<if test="email != null ">email = #{email},</if>
<if test="phonenumber != null ">phonenumber = #{phonenumber},</if>
<if test="sex != null and sex != ''">sex = #{sex},</if>
diff --git a/sql/jg.png b/sql/jg.png
deleted file mode 100644
index 713f04b..0000000
--- a/sql/jg.png
+++ /dev/null
Binary files differ
diff --git a/sql/se_cloud_20240629.sql b/sql/se_cloud_20240629.sql
deleted file mode 100644
index 4cacedf..0000000
--- a/sql/se_cloud_20240629.sql
+++ /dev/null
@@ -1,703 +0,0 @@
--- DROP DATABASE IF EXISTS `se-cloud`;
-
-CREATE DATABASE IF NOT EXISTS `se-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-
-SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
-
-USE `se-cloud`;
-
--- ----------------------------
--- 1銆侀儴闂ㄨ〃
--- ----------------------------
-drop table if exists sys_dept;
-create table sys_dept (
- dept_id bigint(20) not null auto_increment comment '閮ㄩ棬id',
- parent_id bigint(20) default 0 comment '鐖堕儴闂╥d',
- ancestors varchar(50) default '' comment '绁栫骇鍒楄〃',
- dept_name varchar(30) default '' comment '閮ㄩ棬鍚嶇О',
- order_num int(4) default 0 comment '鏄剧ず椤哄簭',
- leader varchar(20) default null comment '璐熻矗浜�',
- phone varchar(11) default null comment '鑱旂郴鐢佃瘽',
- email varchar(50) default null comment '閭',
- status char(1) default '0' comment '閮ㄩ棬鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- primary key (dept_id)
-) engine=innodb auto_increment=110 comment = '閮ㄩ棬琛�';
-
--- ----------------------------
--- 鍒濆鍖�-閮ㄩ棬琛ㄦ暟鎹�
--- ----------------------------
-insert into sys_dept values(100, 0, '0', 'SE绉戞妧', 0, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(101, 100, '0,100', '娣卞湷鎬诲叕鍙�', 1, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(102, 100, '0,100', '闀挎矙鍒嗗叕鍙�', 2, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(103, 101, '0,100,101', '鐮斿彂閮ㄩ棬', 1, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(104, 101, '0,100,101', '甯傚満閮ㄩ棬', 2, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(105, 101, '0,100,101', '娴嬭瘯閮ㄩ棬', 3, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(106, 101, '0,100,101', '璐㈠姟閮ㄩ棬', 4, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(107, 101, '0,100,101', '杩愮淮閮ㄩ棬', 5, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(108, 102, '0,100,102', '甯傚満閮ㄩ棬', 1, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-insert into sys_dept values(109, 102, '0,100,102', '璐㈠姟閮ㄩ棬', 2, '', '15888888888', 'ry@qq.com', '0', '0', 'admin', sysdate(), '', null);
-
--- ----------------------------
--- 2銆佺敤鎴蜂俊鎭〃
--- ----------------------------
-drop table if exists sys_user;
-create table sys_user (
- user_id bigint(20) not null auto_increment comment '鐢ㄦ埛ID',
- dept_id bigint(20) default null comment '閮ㄩ棬ID',
- user_name varchar(30) not null comment '鐢ㄦ埛璐﹀彿',
- nick_name varchar(30) not null comment '鐢ㄦ埛鏄电О',
- user_type varchar(2) default '00' comment '鐢ㄦ埛绫诲瀷锛�00绯荤粺鐢ㄦ埛锛�',
- email varchar(50) default '' comment '鐢ㄦ埛閭',
- phonenumber varchar(11) default '' comment '鎵嬫満鍙风爜',
- sex char(1) default '0' comment '鐢ㄦ埛鎬у埆锛�0鐢� 1濂� 2鏈煡锛�',
- avatar varchar(100) default '' comment '澶村儚鍦板潃',
- password varchar(100) default '' comment '瀵嗙爜',
- status char(1) default '0' comment '甯愬彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
- login_ip varchar(128) default '' comment '鏈�鍚庣櫥褰旾P',
- login_date datetime comment '鏈�鍚庣櫥褰曟椂闂�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (user_id)
-) engine=innodb auto_increment=3 comment = '鐢ㄦ埛淇℃伅琛�';
-
--- ----------------------------
--- 鍒濆鍖�-鐢ㄦ埛淇℃伅琛ㄦ暟鎹�
--- ----------------------------
-insert into sys_user values(1, 103, 'admin', '', '00', 'ry@163.com', '15888888888', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '绠＄悊鍛�');
-insert into sys_user values(2, 105, 'ry', '', '00', 'ry@qq.com', '15666666666', '1', '', '$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', '0', '0', '127.0.0.1', sysdate(), 'admin', sysdate(), '', null, '娴嬭瘯鍛�');
-
-
--- ----------------------------
--- 3銆佸矖浣嶄俊鎭〃
--- ----------------------------
-drop table if exists sys_post;
-create table sys_post
-(
- post_id bigint(20) not null auto_increment comment '宀椾綅ID',
- post_code varchar(64) not null comment '宀椾綅缂栫爜',
- post_name varchar(50) not null comment '宀椾綅鍚嶇О',
- post_sort int(4) not null comment '鏄剧ず椤哄簭',
- status char(1) not null comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (post_id)
-) engine=innodb auto_increment=5 comment = '宀椾綅淇℃伅琛�';
-
--- ----------------------------
--- 鍒濆鍖�-宀椾綅淇℃伅琛ㄦ暟鎹�
--- ----------------------------
-insert into sys_post values(1, 'ceo', '钁ｄ簨闀�', 1, '0', 'admin', sysdate(), '', null, '');
-insert into sys_post values(2, 'se', '椤圭洰缁忕悊', 2, '0', 'admin', sysdate(), '', null, '');
-insert into sys_post values(3, 'hr', '浜哄姏璧勬簮', 3, '0', 'admin', sysdate(), '', null, '');
-insert into sys_post values(4, 'user', '鏅�氬憳宸�', 4, '0', 'admin', sysdate(), '', null, '');
-
-
--- ----------------------------
--- 4銆佽鑹蹭俊鎭〃
--- ----------------------------
-drop table if exists sys_role;
-create table sys_role (
- role_id bigint(20) not null auto_increment comment '瑙掕壊ID',
- role_name varchar(30) not null comment '瑙掕壊鍚嶇О',
- role_key varchar(100) not null comment '瑙掕壊鏉冮檺瀛楃涓�',
- role_sort int(4) not null comment '鏄剧ず椤哄簭',
- data_scope char(1) default '1' comment '鏁版嵁鑼冨洿锛�1锛氬叏閮ㄦ暟鎹潈闄� 2锛氳嚜瀹氭暟鎹潈闄� 3锛氭湰閮ㄩ棬鏁版嵁鏉冮檺 4锛氭湰閮ㄩ棬鍙婁互涓嬫暟鎹潈闄愶級',
- menu_check_strictly tinyint(1) default 1 comment '鑿滃崟鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�',
- dept_check_strictly tinyint(1) default 1 comment '閮ㄩ棬鏍戦�夋嫨椤规槸鍚﹀叧鑱旀樉绀�',
- status char(1) not null comment '瑙掕壊鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (role_id)
-) engine=innodb auto_increment=3 comment = '瑙掕壊淇℃伅琛�';
-
--- ----------------------------
--- 鍒濆鍖�-瑙掕壊淇℃伅琛ㄦ暟鎹�
--- ----------------------------
-insert into sys_role values('1', '瓒呯骇绠＄悊鍛�', 'admin', 1, 1, 1, 1, '0', '0', 'admin', sysdate(), '', null, '瓒呯骇绠＄悊鍛�');
-insert into sys_role values('2', '鏅�氳鑹�', 'common', 2, 2, 1, 1, '0', '0', 'admin', sysdate(), '', null, '鏅�氳鑹�');
-
-
--- ----------------------------
--- 5銆佽彍鍗曟潈闄愯〃
--- ----------------------------
-drop table if exists sys_menu;
-create table sys_menu (
- menu_id bigint(20) not null auto_increment comment '鑿滃崟ID',
- menu_name varchar(50) not null comment '鑿滃崟鍚嶇О',
- parent_id bigint(20) default 0 comment '鐖惰彍鍗旾D',
- order_num int(4) default 0 comment '鏄剧ず椤哄簭',
- path varchar(200) default '' comment '璺敱鍦板潃',
- component varchar(255) default null comment '缁勪欢璺緞',
- query varchar(255) default null comment '璺敱鍙傛暟',
- route_name varchar(50) default '' comment '璺敱鍚嶇О',
- is_frame int(1) default 1 comment '鏄惁涓哄閾撅紙0鏄� 1鍚︼級',
- is_cache int(1) default 0 comment '鏄惁缂撳瓨锛�0缂撳瓨 1涓嶇紦瀛橈級',
- menu_type char(1) default '' comment '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�',
- visible char(1) default 0 comment '鑿滃崟鐘舵�侊紙0鏄剧ず 1闅愯棌锛�',
- status char(1) default 0 comment '鑿滃崟鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- perms varchar(100) default null comment '鏉冮檺鏍囪瘑',
- icon varchar(100) default '#' comment '鑿滃崟鍥炬爣',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default '' comment '澶囨敞',
- primary key (menu_id)
-) engine=innodb auto_increment=1070 comment = '鑿滃崟鏉冮檺琛�';
-
--- ----------------------------
--- 鍒濆鍖�-鑿滃崟淇℃伅琛ㄦ暟鎹�
--- ----------------------------
--- 涓�绾ц彍鍗�
-insert into sys_menu values('1', '绯荤粺绠＄悊', '0', '1', 'system', null, '', '', 1, 0, 'M', '0', '0', '', 'system', 'admin', sysdate(), '', null, '绯荤粺绠＄悊鐩綍');
-insert into sys_menu values('2', '绯荤粺鐩戞帶', '0', '2', 'monitor', null, '', '', 1, 0, 'M', '0', '0', '', 'monitor', 'admin', sysdate(), '', null, '绯荤粺鐩戞帶鐩綍');
-insert into sys_menu values('3', '绯荤粺宸ュ叿', '0', '3', 'tool', null, '', '', 1, 0, 'M', '0', '0', '', 'tool', 'admin', sysdate(), '', null, '绯荤粺宸ュ叿鐩綍');
-insert into sys_menu values('4', '瀹樼綉', '0', '4', 'http://se.vip', null, '', '', 0, 0, 'M', '0', '0', '', 'guide', 'admin', sysdate(), '', null, '瀹樼綉鍦板潃');
--- 浜岀骇鑿滃崟
-insert into sys_menu values('100', '鐢ㄦ埛绠＄悊', '1', '1', 'user', 'system/user/index', '', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 'admin', sysdate(), '', null, '鐢ㄦ埛绠＄悊鑿滃崟');
-insert into sys_menu values('101', '瑙掕壊绠＄悊', '1', '2', 'role', 'system/role/index', '', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 'admin', sysdate(), '', null, '瑙掕壊绠＄悊鑿滃崟');
-insert into sys_menu values('102', '鑿滃崟绠＄悊', '1', '3', 'menu', 'system/menu/index', '', '', 1, 0, 'C', '0', '0', 'system:menu:list', 'tree-table', 'admin', sysdate(), '', null, '鑿滃崟绠＄悊鑿滃崟');
-insert into sys_menu values('103', '閮ㄩ棬绠＄悊', '1', '4', 'dept', 'system/dept/index', '', '', 1, 0, 'C', '0', '0', 'system:dept:list', 'tree', 'admin', sysdate(), '', null, '閮ㄩ棬绠＄悊鑿滃崟');
-insert into sys_menu values('104', '宀椾綅绠＄悊', '1', '5', 'post', 'system/post/index', '', '', 1, 0, 'C', '0', '0', 'system:post:list', 'post', 'admin', sysdate(), '', null, '宀椾綅绠＄悊鑿滃崟');
-insert into sys_menu values('105', '瀛楀吀绠＄悊', '1', '6', 'dict', 'system/dict/index', '', '', 1, 0, 'C', '0', '0', 'system:dict:list', 'dict', 'admin', sysdate(), '', null, '瀛楀吀绠＄悊鑿滃崟');
-insert into sys_menu values('106', '鍙傛暟璁剧疆', '1', '7', 'config', 'system/config/index', '', '', 1, 0, 'C', '0', '0', 'system:config:list', 'edit', 'admin', sysdate(), '', null, '鍙傛暟璁剧疆鑿滃崟');
-insert into sys_menu values('107', '閫氱煡鍏憡', '1', '8', 'notice', 'system/notice/index', '', '', 1, 0, 'C', '0', '0', 'system:notice:list', 'message', 'admin', sysdate(), '', null, '閫氱煡鍏憡鑿滃崟');
-insert into sys_menu values('108', '鏃ュ織绠＄悊', '1', '9', 'log', '', '', '', 1, 0, 'M', '0', '0', '', 'log', 'admin', sysdate(), '', null, '鏃ュ織绠＄悊鑿滃崟');
-insert into sys_menu values('109', '鍦ㄧ嚎鐢ㄦ埛', '2', '1', 'online', 'monitor/online/index', '', '', 1, 0, 'C', '0', '0', 'monitor:online:list', 'online', 'admin', sysdate(), '', null, '鍦ㄧ嚎鐢ㄦ埛鑿滃崟');
-insert into sys_menu values('110', '瀹氭椂浠诲姟', '2', '2', 'job', 'monitor/job/index', '', '', 1, 0, 'C', '0', '0', 'monitor:job:list', 'job', 'admin', sysdate(), '', null, '瀹氭椂浠诲姟鑿滃崟');
-insert into sys_menu values('111', 'Sentinel鎺у埗鍙�', '2', '3', 'http://localhost:8718', '', '', '', 0, 0, 'C', '0', '0', 'monitor:sentinel:list', 'sentinel', 'admin', sysdate(), '', null, '娴侀噺鎺у埗鑿滃崟');
-insert into sys_menu values('112', 'Nacos鎺у埗鍙�', '2', '4', 'http://localhost:8848/nacos', '', '', '', 0, 0, 'C', '0', '0', 'monitor:nacos:list', 'nacos', 'admin', sysdate(), '', null, '鏈嶅姟娌荤悊鑿滃崟');
-insert into sys_menu values('113', 'Admin鎺у埗鍙�', '2', '5', 'http://localhost:9100/login', '', '', '', 0, 0, 'C', '0', '0', 'monitor:server:list', 'server', 'admin', sysdate(), '', null, '鏈嶅姟鐩戞帶鑿滃崟');
-insert into sys_menu values('114', '琛ㄥ崟鏋勫缓', '3', '1', 'build', 'tool/build/index', '', '', 1, 0, 'C', '0', '0', 'tool:build:list', 'build', 'admin', sysdate(), '', null, '琛ㄥ崟鏋勫缓鑿滃崟');
-insert into sys_menu values('115', '浠ｇ爜鐢熸垚', '3', '2', 'gen', 'tool/gen/index', '', '', 1, 0, 'C', '0', '0', 'tool:gen:list', 'code', 'admin', sysdate(), '', null, '浠ｇ爜鐢熸垚鑿滃崟');
-insert into sys_menu values('116', '绯荤粺鎺ュ彛', '3', '3', 'http://localhost:8080/swagger-ui/index.html', '', '', '', 0, 0, 'C', '0', '0', 'tool:swagger:list', 'swagger', 'admin', sysdate(), '', null, '绯荤粺鎺ュ彛鑿滃崟');
--- 涓夌骇鑿滃崟
-insert into sys_menu values('500', '鎿嶄綔鏃ュ織', '108', '1', 'operlog', 'system/operlog/index', '', '', 1, 0, 'C', '0', '0', 'system:operlog:list', 'form', 'admin', sysdate(), '', null, '鎿嶄綔鏃ュ織鑿滃崟');
-insert into sys_menu values('501', '鐧诲綍鏃ュ織', '108', '2', 'logininfor', 'system/logininfor/index', '', '', 1, 0, 'C', '0', '0', 'system:logininfor:list', 'logininfor', 'admin', sysdate(), '', null, '鐧诲綍鏃ュ織鑿滃崟');
--- 鐢ㄦ埛绠＄悊鎸夐挳
-insert into sys_menu values('1000', '鐢ㄦ埛鏌ヨ', '100', '1', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1001', '鐢ㄦ埛鏂板', '100', '2', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1002', '鐢ㄦ埛淇敼', '100', '3', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1003', '鐢ㄦ埛鍒犻櫎', '100', '4', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1004', '鐢ㄦ埛瀵煎嚭', '100', '5', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:export', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1005', '鐢ㄦ埛瀵煎叆', '100', '6', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:import', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1006', '閲嶇疆瀵嗙爜', '100', '7', '', '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'admin', sysdate(), '', null, '');
--- 瑙掕壊绠＄悊鎸夐挳
-insert into sys_menu values('1007', '瑙掕壊鏌ヨ', '101', '1', '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1008', '瑙掕壊鏂板', '101', '2', '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1009', '瑙掕壊淇敼', '101', '3', '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1010', '瑙掕壊鍒犻櫎', '101', '4', '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1011', '瑙掕壊瀵煎嚭', '101', '5', '', '', '', '', 1, 0, 'F', '0', '0', 'system:role:export', '#', 'admin', sysdate(), '', null, '');
--- 鑿滃崟绠＄悊鎸夐挳
-insert into sys_menu values('1012', '鑿滃崟鏌ヨ', '102', '1', '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1013', '鑿滃崟鏂板', '102', '2', '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1014', '鑿滃崟淇敼', '102', '3', '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1015', '鑿滃崟鍒犻櫎', '102', '4', '', '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', sysdate(), '', null, '');
--- 閮ㄩ棬绠＄悊鎸夐挳
-insert into sys_menu values('1016', '閮ㄩ棬鏌ヨ', '103', '1', '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1017', '閮ㄩ棬鏂板', '103', '2', '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1018', '閮ㄩ棬淇敼', '103', '3', '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1019', '閮ㄩ棬鍒犻櫎', '103', '4', '', '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'admin', sysdate(), '', null, '');
--- 宀椾綅绠＄悊鎸夐挳
-insert into sys_menu values('1020', '宀椾綅鏌ヨ', '104', '1', '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1021', '宀椾綅鏂板', '104', '2', '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1022', '宀椾綅淇敼', '104', '3', '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1023', '宀椾綅鍒犻櫎', '104', '4', '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1024', '宀椾綅瀵煎嚭', '104', '5', '', '', '', '', 1, 0, 'F', '0', '0', 'system:post:export', '#', 'admin', sysdate(), '', null, '');
--- 瀛楀吀绠＄悊鎸夐挳
-insert into sys_menu values('1025', '瀛楀吀鏌ヨ', '105', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1026', '瀛楀吀鏂板', '105', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1027', '瀛楀吀淇敼', '105', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1028', '瀛楀吀鍒犻櫎', '105', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1029', '瀛楀吀瀵煎嚭', '105', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'admin', sysdate(), '', null, '');
--- 鍙傛暟璁剧疆鎸夐挳
-insert into sys_menu values('1030', '鍙傛暟鏌ヨ', '106', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1031', '鍙傛暟鏂板', '106', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1032', '鍙傛暟淇敼', '106', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1033', '鍙傛暟鍒犻櫎', '106', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1034', '鍙傛暟瀵煎嚭', '106', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:config:export', '#', 'admin', sysdate(), '', null, '');
--- 閫氱煡鍏憡鎸夐挳
-insert into sys_menu values('1035', '鍏憡鏌ヨ', '107', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1036', '鍏憡鏂板', '107', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1037', '鍏憡淇敼', '107', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1038', '鍏憡鍒犻櫎', '107', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove', '#', 'admin', sysdate(), '', null, '');
--- 鎿嶄綔鏃ュ織鎸夐挳
-insert into sys_menu values('1039', '鎿嶄綔鏌ヨ', '500', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:operlog:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1040', '鎿嶄綔鍒犻櫎', '500', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:operlog:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1041', '鏃ュ織瀵煎嚭', '500', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:operlog:export', '#', 'admin', sysdate(), '', null, '');
--- 鐧诲綍鏃ュ織鎸夐挳
-insert into sys_menu values('1042', '鐧诲綍鏌ヨ', '501', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1043', '鐧诲綍鍒犻櫎', '501', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1044', '鏃ュ織瀵煎嚭', '501', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:export', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1045', '璐︽埛瑙ｉ攣', '501', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'system:logininfor:unlock', '#', 'admin', sysdate(), '', null, '');
--- 鍦ㄧ嚎鐢ㄦ埛鎸夐挳
-insert into sys_menu values('1046', '鍦ㄧ嚎鏌ヨ', '109', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1047', '鎵归噺寮洪��', '109', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1048', '鍗曟潯寮洪��', '109', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
--- 瀹氭椂浠诲姟鎸夐挳
-insert into sys_menu values('1049', '浠诲姟鏌ヨ', '110', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1050', '浠诲姟鏂板', '110', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:add', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1051', '浠诲姟淇敼', '110', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1052', '浠诲姟鍒犻櫎', '110', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1053', '鐘舵�佷慨鏀�', '110', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:changeStatus', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1054', '浠诲姟瀵煎嚭', '110', '6', '#', '', '', '', 1, 0, 'F', '0', '0', 'monitor:job:export', '#', 'admin', sysdate(), '', null, '');
--- 浠ｇ爜鐢熸垚鎸夐挳
-insert into sys_menu values('1055', '鐢熸垚鏌ヨ', '115', '1', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1056', '鐢熸垚淇敼', '115', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1057', '鐢熸垚鍒犻櫎', '115', '3', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1058', '瀵煎叆浠ｇ爜', '115', '2', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1059', '棰勮浠ｇ爜', '115', '4', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview', '#', 'admin', sysdate(), '', null, '');
-insert into sys_menu values('1060', '鐢熸垚浠ｇ爜', '115', '5', '#', '', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code', '#', 'admin', sysdate(), '', null, '');
-
-
--- ----------------------------
--- 6銆佺敤鎴峰拰瑙掕壊鍏宠仈琛� 鐢ㄦ埛N-1瑙掕壊
--- ----------------------------
-drop table if exists sys_user_role;
-create table sys_user_role (
- user_id bigint(20) not null comment '鐢ㄦ埛ID',
- role_id bigint(20) not null comment '瑙掕壊ID',
- primary key(user_id, role_id)
-) engine=innodb comment = '鐢ㄦ埛鍜岃鑹插叧鑱旇〃';
-
--- ----------------------------
--- 鍒濆鍖�-鐢ㄦ埛鍜岃鑹插叧鑱旇〃鏁版嵁
--- ----------------------------
-insert into sys_user_role values ('1', '1');
-insert into sys_user_role values ('2', '2');
-
-
--- ----------------------------
--- 7銆佽鑹插拰鑿滃崟鍏宠仈琛� 瑙掕壊1-N鑿滃崟
--- ----------------------------
-drop table if exists sys_role_menu;
-create table sys_role_menu (
- role_id bigint(20) not null comment '瑙掕壊ID',
- menu_id bigint(20) not null comment '鑿滃崟ID',
- primary key(role_id, menu_id)
-) engine=innodb comment = '瑙掕壊鍜岃彍鍗曞叧鑱旇〃';
-
--- ----------------------------
--- 鍒濆鍖�-瑙掕壊鍜岃彍鍗曞叧鑱旇〃鏁版嵁
--- ----------------------------
-insert into sys_role_menu values ('2', '1');
-insert into sys_role_menu values ('2', '2');
-insert into sys_role_menu values ('2', '3');
-insert into sys_role_menu values ('2', '4');
-insert into sys_role_menu values ('2', '100');
-insert into sys_role_menu values ('2', '101');
-insert into sys_role_menu values ('2', '102');
-insert into sys_role_menu values ('2', '103');
-insert into sys_role_menu values ('2', '104');
-insert into sys_role_menu values ('2', '105');
-insert into sys_role_menu values ('2', '106');
-insert into sys_role_menu values ('2', '107');
-insert into sys_role_menu values ('2', '108');
-insert into sys_role_menu values ('2', '109');
-insert into sys_role_menu values ('2', '110');
-insert into sys_role_menu values ('2', '111');
-insert into sys_role_menu values ('2', '112');
-insert into sys_role_menu values ('2', '113');
-insert into sys_role_menu values ('2', '114');
-insert into sys_role_menu values ('2', '115');
-insert into sys_role_menu values ('2', '116');
-insert into sys_role_menu values ('2', '500');
-insert into sys_role_menu values ('2', '501');
-insert into sys_role_menu values ('2', '1000');
-insert into sys_role_menu values ('2', '1001');
-insert into sys_role_menu values ('2', '1002');
-insert into sys_role_menu values ('2', '1003');
-insert into sys_role_menu values ('2', '1004');
-insert into sys_role_menu values ('2', '1005');
-insert into sys_role_menu values ('2', '1006');
-insert into sys_role_menu values ('2', '1007');
-insert into sys_role_menu values ('2', '1008');
-insert into sys_role_menu values ('2', '1009');
-insert into sys_role_menu values ('2', '1010');
-insert into sys_role_menu values ('2', '1011');
-insert into sys_role_menu values ('2', '1012');
-insert into sys_role_menu values ('2', '1013');
-insert into sys_role_menu values ('2', '1014');
-insert into sys_role_menu values ('2', '1015');
-insert into sys_role_menu values ('2', '1016');
-insert into sys_role_menu values ('2', '1017');
-insert into sys_role_menu values ('2', '1018');
-insert into sys_role_menu values ('2', '1019');
-insert into sys_role_menu values ('2', '1020');
-insert into sys_role_menu values ('2', '1021');
-insert into sys_role_menu values ('2', '1022');
-insert into sys_role_menu values ('2', '1023');
-insert into sys_role_menu values ('2', '1024');
-insert into sys_role_menu values ('2', '1025');
-insert into sys_role_menu values ('2', '1026');
-insert into sys_role_menu values ('2', '1027');
-insert into sys_role_menu values ('2', '1028');
-insert into sys_role_menu values ('2', '1029');
-insert into sys_role_menu values ('2', '1030');
-insert into sys_role_menu values ('2', '1031');
-insert into sys_role_menu values ('2', '1032');
-insert into sys_role_menu values ('2', '1033');
-insert into sys_role_menu values ('2', '1034');
-insert into sys_role_menu values ('2', '1035');
-insert into sys_role_menu values ('2', '1036');
-insert into sys_role_menu values ('2', '1037');
-insert into sys_role_menu values ('2', '1038');
-insert into sys_role_menu values ('2', '1039');
-insert into sys_role_menu values ('2', '1040');
-insert into sys_role_menu values ('2', '1041');
-insert into sys_role_menu values ('2', '1042');
-insert into sys_role_menu values ('2', '1043');
-insert into sys_role_menu values ('2', '1044');
-insert into sys_role_menu values ('2', '1045');
-insert into sys_role_menu values ('2', '1046');
-insert into sys_role_menu values ('2', '1047');
-insert into sys_role_menu values ('2', '1048');
-insert into sys_role_menu values ('2', '1049');
-insert into sys_role_menu values ('2', '1050');
-insert into sys_role_menu values ('2', '1051');
-insert into sys_role_menu values ('2', '1052');
-insert into sys_role_menu values ('2', '1053');
-insert into sys_role_menu values ('2', '1054');
-insert into sys_role_menu values ('2', '1055');
-insert into sys_role_menu values ('2', '1056');
-insert into sys_role_menu values ('2', '1057');
-insert into sys_role_menu values ('2', '1058');
-insert into sys_role_menu values ('2', '1059');
-insert into sys_role_menu values ('2', '1060');
-
--- ----------------------------
--- 8銆佽鑹插拰閮ㄩ棬鍏宠仈琛� 瑙掕壊1-N閮ㄩ棬
--- ----------------------------
-drop table if exists sys_role_dept;
-create table sys_role_dept (
- role_id bigint(20) not null comment '瑙掕壊ID',
- dept_id bigint(20) not null comment '閮ㄩ棬ID',
- primary key(role_id, dept_id)
-) engine=innodb comment = '瑙掕壊鍜岄儴闂ㄥ叧鑱旇〃';
-
--- ----------------------------
--- 鍒濆鍖�-瑙掕壊鍜岄儴闂ㄥ叧鑱旇〃鏁版嵁
--- ----------------------------
-insert into sys_role_dept values ('2', '100');
-insert into sys_role_dept values ('2', '101');
-insert into sys_role_dept values ('2', '105');
-
-
--- ----------------------------
--- 9銆佺敤鎴蜂笌宀椾綅鍏宠仈琛� 鐢ㄦ埛1-N宀椾綅
--- ----------------------------
-drop table if exists sys_user_post;
-create table sys_user_post
-(
- user_id bigint(20) not null comment '鐢ㄦ埛ID',
- post_id bigint(20) not null comment '宀椾綅ID',
- primary key (user_id, post_id)
-) engine=innodb comment = '鐢ㄦ埛涓庡矖浣嶅叧鑱旇〃';
-
--- ----------------------------
--- 鍒濆鍖�-鐢ㄦ埛涓庡矖浣嶅叧鑱旇〃鏁版嵁
--- ----------------------------
-insert into sys_user_post values ('1', '1');
-insert into sys_user_post values ('2', '2');
-
-
--- ----------------------------
--- 10銆佹搷浣滄棩蹇楄褰�
--- ----------------------------
-drop table if exists sys_oper_log;
-create table sys_oper_log (
- oper_id bigint(20) not null auto_increment comment '鏃ュ織涓婚敭',
- title varchar(50) default '' comment '妯″潡鏍囬',
- business_type int(2) default 0 comment '涓氬姟绫诲瀷锛�0鍏跺畠 1鏂板 2淇敼 3鍒犻櫎锛�',
- method varchar(200) default '' comment '鏂规硶鍚嶇О',
- request_method varchar(10) default '' comment '璇锋眰鏂瑰紡',
- operator_type int(1) default 0 comment '鎿嶄綔绫诲埆锛�0鍏跺畠 1鍚庡彴鐢ㄦ埛 2鎵嬫満绔敤鎴凤級',
- oper_name varchar(50) default '' comment '鎿嶄綔浜哄憳',
- dept_name varchar(50) default '' comment '閮ㄩ棬鍚嶇О',
- oper_url varchar(255) default '' comment '璇锋眰URL',
- oper_ip varchar(128) default '' comment '涓绘満鍦板潃',
- oper_location varchar(255) default '' comment '鎿嶄綔鍦扮偣',
- oper_param varchar(2000) default '' comment '璇锋眰鍙傛暟',
- json_result varchar(2000) default '' comment '杩斿洖鍙傛暟',
- status int(1) default 0 comment '鎿嶄綔鐘舵�侊紙0姝ｅ父 1寮傚父锛�',
- error_msg varchar(2000) default '' comment '閿欒娑堟伅',
- oper_time datetime comment '鎿嶄綔鏃堕棿',
- cost_time bigint(20) default 0 comment '娑堣�楁椂闂�',
- primary key (oper_id),
- key idx_sys_oper_log_bt (business_type),
- key idx_sys_oper_log_s (status),
- key idx_sys_oper_log_ot (oper_time)
-) engine=innodb auto_increment=1 comment = '鎿嶄綔鏃ュ織璁板綍';
-
-
--- ----------------------------
--- 11銆佸瓧鍏哥被鍨嬭〃
--- ----------------------------
-drop table if exists sys_dict_type;
-create table sys_dict_type
-(
- dict_id bigint(20) not null auto_increment comment '瀛楀吀涓婚敭',
- dict_name varchar(100) default '' comment '瀛楀吀鍚嶇О',
- dict_type varchar(100) default '' comment '瀛楀吀绫诲瀷',
- status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (dict_id),
- unique (dict_type)
-) engine=innodb auto_increment=11 comment = '瀛楀吀绫诲瀷琛�';
-
-insert into sys_dict_type values(1, '鐢ㄦ埛鎬у埆', 'sys_user_sex', '0', 'admin', sysdate(), '', null, '鐢ㄦ埛鎬у埆鍒楄〃');
-insert into sys_dict_type values(2, '鑿滃崟鐘舵��', 'sys_show_hide', '0', 'admin', sysdate(), '', null, '鑿滃崟鐘舵�佸垪琛�');
-insert into sys_dict_type values(3, '绯荤粺寮�鍏�', 'sys_normal_disable', '0', 'admin', sysdate(), '', null, '绯荤粺寮�鍏冲垪琛�');
-insert into sys_dict_type values(4, '浠诲姟鐘舵��', 'sys_job_status', '0', 'admin', sysdate(), '', null, '浠诲姟鐘舵�佸垪琛�');
-insert into sys_dict_type values(5, '浠诲姟鍒嗙粍', 'sys_job_group', '0', 'admin', sysdate(), '', null, '浠诲姟鍒嗙粍鍒楄〃');
-insert into sys_dict_type values(6, '绯荤粺鏄惁', 'sys_yes_no', '0', 'admin', sysdate(), '', null, '绯荤粺鏄惁鍒楄〃');
-insert into sys_dict_type values(7, '閫氱煡绫诲瀷', 'sys_notice_type', '0', 'admin', sysdate(), '', null, '閫氱煡绫诲瀷鍒楄〃');
-insert into sys_dict_type values(8, '閫氱煡鐘舵��', 'sys_notice_status', '0', 'admin', sysdate(), '', null, '閫氱煡鐘舵�佸垪琛�');
-insert into sys_dict_type values(9, '鎿嶄綔绫诲瀷', 'sys_oper_type', '0', 'admin', sysdate(), '', null, '鎿嶄綔绫诲瀷鍒楄〃');
-insert into sys_dict_type values(10, '绯荤粺鐘舵��', 'sys_common_status', '0', 'admin', sysdate(), '', null, '鐧诲綍鐘舵�佸垪琛�');
-
-
--- ----------------------------
--- 12銆佸瓧鍏告暟鎹〃
--- ----------------------------
-drop table if exists sys_dict_data;
-create table sys_dict_data
-(
- dict_code bigint(20) not null auto_increment comment '瀛楀吀缂栫爜',
- dict_sort int(4) default 0 comment '瀛楀吀鎺掑簭',
- dict_label varchar(100) default '' comment '瀛楀吀鏍囩',
- dict_value varchar(100) default '' comment '瀛楀吀閿��',
- dict_type varchar(100) default '' comment '瀛楀吀绫诲瀷',
- css_class varchar(100) default null comment '鏍峰紡灞炴�э紙鍏朵粬鏍峰紡鎵╁睍锛�',
- list_class varchar(100) default null comment '琛ㄦ牸鍥炴樉鏍峰紡',
- is_default char(1) default 'N' comment '鏄惁榛樿锛圷鏄� N鍚︼級',
- status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (dict_code)
-) engine=innodb auto_increment=30 comment = '瀛楀吀鏁版嵁琛�';
-
-insert into sys_dict_data values(1, 1, '鐢�', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', sysdate(), '', null, '鎬у埆鐢�');
-insert into sys_dict_data values(2, 2, '濂�', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', sysdate(), '', null, '鎬у埆濂�');
-insert into sys_dict_data values(3, 3, '鏈煡', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', sysdate(), '', null, '鎬у埆鏈煡');
-insert into sys_dict_data values(4, 1, '鏄剧ず', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, '鏄剧ず鑿滃崟');
-insert into sys_dict_data values(5, 2, '闅愯棌', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '闅愯棌鑿滃崟');
-insert into sys_dict_data values(6, 1, '姝ｅ父', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, '姝ｅ父鐘舵��');
-insert into sys_dict_data values(7, 2, '鍋滅敤', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍋滅敤鐘舵��');
-insert into sys_dict_data values(8, 1, '姝ｅ父', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, '姝ｅ父鐘舵��');
-insert into sys_dict_data values(9, 2, '鏆傚仠', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍋滅敤鐘舵��');
-insert into sys_dict_data values(10, 1, '榛樿', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', sysdate(), '', null, '榛樿鍒嗙粍');
-insert into sys_dict_data values(11, 2, '绯荤粺', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', sysdate(), '', null, '绯荤粺鍒嗙粍');
-insert into sys_dict_data values(12, 1, '鏄�', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, '绯荤粺榛樿鏄�');
-insert into sys_dict_data values(13, 2, '鍚�', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '绯荤粺榛樿鍚�');
-insert into sys_dict_data values(14, 1, '閫氱煡', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', sysdate(), '', null, '閫氱煡');
-insert into sys_dict_data values(15, 2, '鍏憡', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', sysdate(), '', null, '鍏憡');
-insert into sys_dict_data values(16, 1, '姝ｅ父', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, '姝ｅ父鐘舵��');
-insert into sys_dict_data values(17, 2, '鍏抽棴', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍏抽棴鐘舵��');
-insert into sys_dict_data values(18, 99, '鍏朵粬', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, '鍏朵粬鎿嶄綔');
-insert into sys_dict_data values(19, 1, '鏂板', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, '鏂板鎿嶄綔');
-insert into sys_dict_data values(20, 2, '淇敼', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, '淇敼鎿嶄綔');
-insert into sys_dict_data values(21, 3, '鍒犻櫎', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍒犻櫎鎿嶄綔');
-insert into sys_dict_data values(22, 4, '鎺堟潈', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', sysdate(), '', null, '鎺堟潈鎿嶄綔');
-insert into sys_dict_data values(23, 5, '瀵煎嚭', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, '瀵煎嚭鎿嶄綔');
-insert into sys_dict_data values(24, 6, '瀵煎叆', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, '瀵煎叆鎿嶄綔');
-insert into sys_dict_data values(25, 7, '寮洪��', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '寮洪��鎿嶄綔');
-insert into sys_dict_data values(26, 8, '鐢熸垚浠ｇ爜', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', sysdate(), '', null, '鐢熸垚鎿嶄綔');
-insert into sys_dict_data values(27, 9, '娓呯┖鏁版嵁', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '娓呯┖鎿嶄綔');
-insert into sys_dict_data values(28, 1, '鎴愬姛', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', sysdate(), '', null, '姝ｅ父鐘舵��');
-insert into sys_dict_data values(29, 2, '澶辫触', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍋滅敤鐘舵��');
-
-
--- ----------------------------
--- 13銆佸弬鏁伴厤缃〃
--- ----------------------------
-drop table if exists sys_config;
-create table sys_config (
- config_id int(5) not null auto_increment comment '鍙傛暟涓婚敭',
- config_name varchar(100) default '' comment '鍙傛暟鍚嶇О',
- config_key varchar(100) default '' comment '鍙傛暟閿悕',
- config_value varchar(500) default '' comment '鍙傛暟閿��',
- config_type char(1) default 'N' comment '绯荤粺鍐呯疆锛圷鏄� N鍚︼級',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (config_id)
-) engine=innodb auto_increment=6 comment = '鍙傛暟閰嶇疆琛�';
-
-insert into sys_config values(1, '涓绘鏋堕〉-榛樿鐨偆鏍峰紡鍚嶇О', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', sysdate(), '', null, '钃濊壊 skin-blue銆佺豢鑹� skin-green銆佺传鑹� skin-purple銆佺孩鑹� skin-red銆侀粍鑹� skin-yellow' );
-insert into sys_config values(2, '鐢ㄦ埛绠＄悊-璐﹀彿鍒濆瀵嗙爜', 'sys.user.initPassword', '123456', 'Y', 'admin', sysdate(), '', null, '鍒濆鍖栧瘑鐮� 123456' );
-insert into sys_config values(3, '涓绘鏋堕〉-渚ц竟鏍忎富棰�', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', sysdate(), '', null, '娣辫壊涓婚theme-dark锛屾祬鑹蹭富棰榯heme-light' );
-insert into sys_config values(4, '璐﹀彿鑷姪-鏄惁寮�鍚敤鎴锋敞鍐屽姛鑳�', 'sys.account.registerUser', 'false', 'Y', 'admin', sysdate(), '', null, '鏄惁寮�鍚敞鍐岀敤鎴峰姛鑳斤紙true寮�鍚紝false鍏抽棴锛�');
-insert into sys_config values(5, '鐢ㄦ埛鐧诲綍-榛戝悕鍗曞垪琛�', 'sys.login.blackIPList', '', 'Y', 'admin', sysdate(), '', null, '璁剧疆鐧诲綍IP榛戝悕鍗曢檺鍒讹紝澶氫釜鍖归厤椤逛互;鍒嗛殧锛屾敮鎸佸尮閰嶏紙*閫氶厤銆佺綉娈碉級');
-
-
--- ----------------------------
--- 14銆佺郴缁熻闂褰�
--- ----------------------------
-drop table if exists sys_logininfor;
-create table sys_logininfor (
- info_id bigint(20) not null auto_increment comment '璁块棶ID',
- user_name varchar(50) default '' comment '鐢ㄦ埛璐﹀彿',
- ipaddr varchar(128) default '' comment '鐧诲綍IP鍦板潃',
- status char(1) default '0' comment '鐧诲綍鐘舵�侊紙0鎴愬姛 1澶辫触锛�',
- msg varchar(255) default '' comment '鎻愮ず淇℃伅',
- access_time datetime comment '璁块棶鏃堕棿',
- primary key (info_id),
- key idx_sys_logininfor_s (status),
- key idx_sys_logininfor_lt (access_time)
-) engine=innodb auto_increment=1 comment = '绯荤粺璁块棶璁板綍';
-
-
--- ----------------------------
--- 15銆佸畾鏃朵换鍔¤皟搴﹁〃
--- ----------------------------
-drop table if exists sys_job;
-create table sys_job (
- job_id bigint(20) not null auto_increment comment '浠诲姟ID',
- job_name varchar(64) default '' comment '浠诲姟鍚嶇О',
- job_group varchar(64) default 'DEFAULT' comment '浠诲姟缁勫悕',
- invoke_target varchar(500) not null comment '璋冪敤鐩爣瀛楃涓�',
- cron_expression varchar(255) default '' comment 'cron鎵ц琛ㄨ揪寮�',
- misfire_policy varchar(20) default '3' comment '璁″垝鎵ц閿欒绛栫暐锛�1绔嬪嵆鎵ц 2鎵ц涓�娆� 3鏀惧純鎵ц锛�',
- concurrent char(1) default '1' comment '鏄惁骞跺彂鎵ц锛�0鍏佽 1绂佹锛�',
- status char(1) default '0' comment '鐘舵�侊紙0姝ｅ父 1鏆傚仠锛�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default '' comment '澶囨敞淇℃伅',
- primary key (job_id, job_name, job_group)
-) engine=innodb auto_increment=4 comment = '瀹氭椂浠诲姟璋冨害琛�';
-
-insert into sys_job values(1, '绯荤粺榛樿锛堟棤鍙傦級', 'DEFAULT', 'ryTask.ryNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, '');
-insert into sys_job values(2, '绯荤粺榛樿锛堟湁鍙傦級', 'DEFAULT', 'ryTask.ryParams(\'ry\')', '0/15 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, '');
-insert into sys_job values(3, '绯荤粺榛樿锛堝鍙傦級', 'DEFAULT', 'ryTask.ryMultipleParams(\'ry\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', sysdate(), '', null, '');
-
-
--- ----------------------------
--- 16銆佸畾鏃朵换鍔¤皟搴︽棩蹇楄〃
--- ----------------------------
-drop table if exists sys_job_log;
-create table sys_job_log (
- job_log_id bigint(20) not null auto_increment comment '浠诲姟鏃ュ織ID',
- job_name varchar(64) not null comment '浠诲姟鍚嶇О',
- job_group varchar(64) not null comment '浠诲姟缁勫悕',
- invoke_target varchar(500) not null comment '璋冪敤鐩爣瀛楃涓�',
- job_message varchar(500) comment '鏃ュ織淇℃伅',
- status char(1) default '0' comment '鎵ц鐘舵�侊紙0姝ｅ父 1澶辫触锛�',
- exception_info varchar(2000) default '' comment '寮傚父淇℃伅',
- create_time datetime comment '鍒涘缓鏃堕棿',
- primary key (job_log_id)
-) engine=innodb auto_increment=1 comment = '瀹氭椂浠诲姟璋冨害鏃ュ織琛�';
-
-
--- ----------------------------
--- 17銆侀�氱煡鍏憡琛�
--- ----------------------------
-drop table if exists sys_notice;
-create table sys_notice (
- notice_id int(4) not null auto_increment comment '鍏憡ID',
- notice_title varchar(50) not null comment '鍏憡鏍囬',
- notice_type char(1) not null comment '鍏憡绫诲瀷锛�1閫氱煡 2鍏憡锛�',
- notice_content longblob default null comment '鍏憡鍐呭',
- status char(1) default '0' comment '鍏憡鐘舵�侊紙0姝ｅ父 1鍏抽棴锛�',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(255) default null comment '澶囨敞',
- primary key (notice_id)
-) engine=innodb auto_increment=3 comment = '閫氱煡鍏憡琛�';
-
--- ----------------------------
--- 鍒濆鍖�-鍏憡淇℃伅琛ㄦ暟鎹�
--- ----------------------------
-insert into sys_notice values('1', '娓╅Θ鎻愰啋锛�2018-07-01 鏂扮増鏈彂甯冨暒', '2', '鏂扮増鏈唴瀹�', '0', 'admin', sysdate(), '', null, '绠＄悊鍛�');
-insert into sys_notice values('2', '缁存姢閫氱煡锛�2018-07-01 绯荤粺鍑屾櫒缁存姢', '1', '缁存姢鍐呭', '0', 'admin', sysdate(), '', null, '绠＄悊鍛�');
-
-
--- ----------------------------
--- 18銆佷唬鐮佺敓鎴愪笟鍔¤〃
--- ----------------------------
-drop table if exists gen_table;
-create table gen_table (
- table_id bigint(20) not null auto_increment comment '缂栧彿',
- table_name varchar(200) default '' comment '琛ㄥ悕绉�',
- table_comment varchar(500) default '' comment '琛ㄦ弿杩�',
- sub_table_name varchar(64) default null comment '鍏宠仈瀛愯〃鐨勮〃鍚�',
- sub_table_fk_name varchar(64) default null comment '瀛愯〃鍏宠仈鐨勫閿悕',
- class_name varchar(100) default '' comment '瀹炰綋绫诲悕绉�',
- tpl_category varchar(200) default 'crud' comment '浣跨敤鐨勬ā鏉匡紙crud鍗曡〃鎿嶄綔 tree鏍戣〃鎿嶄綔锛�',
- tpl_web_type varchar(30) default '' comment '鍓嶇妯℃澘绫诲瀷锛坋lement-ui妯＄増 element-plus妯＄増锛�',
- package_name varchar(100) comment '鐢熸垚鍖呰矾寰�',
- module_name varchar(30) comment '鐢熸垚妯″潡鍚�',
- business_name varchar(30) comment '鐢熸垚涓氬姟鍚�',
- function_name varchar(50) comment '鐢熸垚鍔熻兘鍚�',
- function_author varchar(50) comment '鐢熸垚鍔熻兘浣滆��',
- gen_type char(1) default '0' comment '鐢熸垚浠ｇ爜鏂瑰紡锛�0zip鍘嬬缉鍖� 1鑷畾涔夎矾寰勶級',
- gen_path varchar(200) default '/' comment '鐢熸垚璺緞锛堜笉濉粯璁ら」鐩矾寰勶級',
- options varchar(1000) comment '鍏跺畠鐢熸垚閫夐」',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- remark varchar(500) default null comment '澶囨敞',
- primary key (table_id)
-) engine=innodb auto_increment=1 comment = '浠ｇ爜鐢熸垚涓氬姟琛�';
-
-
--- ----------------------------
--- 19銆佷唬鐮佺敓鎴愪笟鍔¤〃瀛楁
--- ----------------------------
-drop table if exists gen_table_column;
-create table gen_table_column (
- column_id bigint(20) not null auto_increment comment '缂栧彿',
- table_id bigint(20) comment '褰掑睘琛ㄧ紪鍙�',
- column_name varchar(200) comment '鍒楀悕绉�',
- column_comment varchar(500) comment '鍒楁弿杩�',
- column_type varchar(100) comment '鍒楃被鍨�',
- java_type varchar(500) comment 'JAVA绫诲瀷',
- java_field varchar(200) comment 'JAVA瀛楁鍚�',
- is_pk char(1) comment '鏄惁涓婚敭锛�1鏄級',
- is_increment char(1) comment '鏄惁鑷锛�1鏄級',
- is_required char(1) comment '鏄惁蹇呭～锛�1鏄級',
- is_insert char(1) comment '鏄惁涓烘彃鍏ュ瓧娈碉紙1鏄級',
- is_edit char(1) comment '鏄惁缂栬緫瀛楁锛�1鏄級',
- is_list char(1) comment '鏄惁鍒楄〃瀛楁锛�1鏄級',
- is_query char(1) comment '鏄惁鏌ヨ瀛楁锛�1鏄級',
- query_type varchar(200) default 'EQ' comment '鏌ヨ鏂瑰紡锛堢瓑浜庛�佷笉绛変簬銆佸ぇ浜庛�佸皬浜庛�佽寖鍥达級',
- html_type varchar(200) comment '鏄剧ず绫诲瀷锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佹棩鏈熸帶浠讹級',
- dict_type varchar(200) default '' comment '瀛楀吀绫诲瀷',
- sort int comment '鎺掑簭',
- create_by varchar(64) default '' comment '鍒涘缓鑰�',
- create_time datetime comment '鍒涘缓鏃堕棿',
- update_by varchar(64) default '' comment '鏇存柊鑰�',
- update_time datetime comment '鏇存柊鏃堕棿',
- primary key (column_id)
-) engine=innodb auto_increment=1 comment = '浠ｇ爜鐢熸垚涓氬姟琛ㄥ瓧娈�';
diff --git a/sql/se_config_20231204.sql b/sql/se_config_20231204.sql
deleted file mode 100644
index 8d6c024..0000000
--- a/sql/se_config_20231204.sql
+++ /dev/null
@@ -1,219 +0,0 @@
-DROP DATABASE IF EXISTS `se-config`;
-
-CREATE DATABASE `se-config` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-
-SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
-
-USE `se-config`;
-
-/******************************************/
-/* 琛ㄥ悕绉� = config_info */
-/******************************************/
-CREATE TABLE `config_info` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `data_id` varchar(255) NOT NULL COMMENT 'data_id',
- `group_id` varchar(255) DEFAULT NULL,
- `content` longtext NOT NULL COMMENT 'content',
- `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
- `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `src_user` text COMMENT 'source user',
- `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
- `app_name` varchar(128) DEFAULT NULL,
- `tenant_id` varchar(128) DEFAULT '' COMMENT '绉熸埛瀛楁',
- `c_desc` varchar(256) DEFAULT NULL,
- `c_use` varchar(64) DEFAULT NULL,
- `effect` varchar(64) DEFAULT NULL,
- `type` varchar(64) DEFAULT NULL,
- `c_schema` text,
- `encrypted_data_key` text COMMENT '绉橀挜',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_configinfo_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info';
-
-insert into config_info(id, data_id, group_id, content, md5, gmt_create, gmt_modified, src_user, src_ip, app_name, tenant_id, c_desc, c_use, effect, type, c_schema, encrypted_data_key) values
-(1,'application-dev.yml','DEFAULT_GROUP','spring:\n autoconfigure:\n exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure\n mvc:\n pathmatch:\n matching-strategy: ant_path_matcher\n\n# feign 閰嶇疆\nfeign:\n sentinel:\n enabled: true\n okhttp:\n enabled: true\n httpclient:\n enabled: false\n client:\n config:\n default:\n connectTimeout: 10000\n readTimeout: 10000\n compression:\n request:\n enabled: true\n min-request-size: 8192\n response:\n enabled: true\n\n# 鏆撮湶鐩戞帶绔偣\nmanagement:\n endpoints:\n web:\n exposure:\n include: \'*\'\n','58dde4e3760499d3bac2d77a3a1e9018','2020-05-20 12:00:00','2023-12-04 08:08:23','nacos','0:0:0:0:0:0:0:1','','','閫氱敤閰嶇疆','null','null','yaml','',''),
-(2,'se-gateway-dev.yml','DEFAULT_GROUP','spring:\n redis:\n host: localhost\n port: 6379\n password:\n cloud:\n gateway:\n discovery:\n locator:\n lowerCaseServiceId: true\n enabled: true\n routes:\n # 璁よ瘉涓績\n - id: se-auth\n uri: lb://se-auth\n predicates:\n - Path=/auth/**\n filters:\n # 楠岃瘉鐮佸鐞哱n - CacheRequestFilter\n - ValidateCodeFilter\n - StripPrefix=1\n # 浠ｇ爜鐢熸垚\n - id: se-gen\n uri: lb://se-gen\n predicates:\n - Path=/code/**\n filters:\n - StripPrefix=1\n # 瀹氭椂浠诲姟\n - id: se-job\n uri: lb://se-job\n predicates:\n - Path=/schedule/**\n filters:\n - StripPrefix=1\n # 绯荤粺妯″潡\n - id: se-system\n uri: lb://se-system\n predicates:\n - Path=/system/**\n filters:\n - StripPrefix=1\n # 鏂囦欢鏈嶅姟\n - id: se-file\n uri: lb://se-file\n predicates:\n - Path=/file/**\n filters:\n - StripPrefix=1\n\n# 瀹夊叏閰嶇疆\nsecurity:\n # 楠岃瘉鐮乗n captcha:\n enabled: true\n type: math\n # 闃叉XSS鏀诲嚮\n xss:\n enabled: true\n excludeUrls:\n - /system/notice\n # 涓嶆牎楠岀櫧鍚嶅崟\n ignore:\n whites:\n - /auth/logout\n - /auth/login\n - /auth/register\n - /*/v2/api-docs\n - /csrf\n','57cec5abd0e0a6b77d853750344a9dc0','2020-05-14 14:17:55','2022-09-29 02:48:32','nacos','0:0:0:0:0:0:0:1','','','缃戝叧妯″潡','null','null','yaml','',''),
-(3,'se-auth-dev.yml','DEFAULT_GROUP','spring:\n redis:\n host: localhost\n port: 6379\n password:\n','8bd9dada9a94822feeab40de55efced6','2020-11-20 00:00:00','2022-09-29 02:48:42','nacos','0:0:0:0:0:0:0:1','','','璁よ瘉涓績','null','null','yaml','',''),
-(4,'se-monitor-dev.yml','DEFAULT_GROUP','# spring\nspring:\n security:\n user:\n name: se\n password: 123456\n boot:\n admin:\n ui:\n title: 鏈嶅姟鐘舵�佺洃鎺n','6f122fd2bfb8d45f858e7d6529a9cd44','2020-11-20 00:00:00','2022-09-29 02:48:54','nacos','0:0:0:0:0:0:0:1','','','鐩戞帶涓績','null','null','yaml','',''),
-(5,'se-system-dev.yml','DEFAULT_GROUP','# spring閰嶇疆\nspring:\n redis:\n host: localhost\n port: 6379\n password:\n datasource:\n druid:\n stat-view-servlet:\n enabled: true\n loginUsername: admin\n loginPassword: 123456\n dynamic:\n druid:\n initial-size: 5\n min-idle: 5\n maxActive: 20\n maxWait: 60000\n connectTimeout: 30000\n socketTimeout: 60000\n timeBetweenEvictionRunsMillis: 60000\n minEvictableIdleTimeMillis: 300000\n validationQuery: SELECT 1 FROM DUAL\n testWhileIdle: true\n testOnBorrow: false\n testOnReturn: false\n poolPreparedStatements: true\n maxPoolPreparedStatementPerConnectionSize: 20\n filters: stat,slf4j\n connectionProperties: druid.stat.mergeSql\\=true;druid.stat.slowSqlMillis\\=5000\n datasource:\n # 涓诲簱鏁版嵁婧怽n master:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/se-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: password\n # 浠庡簱鏁版嵁婧怽n # slave:\n # username: \n # password: \n # url: \n # driver-class-name: \n\n# mybatis閰嶇疆\nmybatis:\n # 鎼滅储鎸囧畾鍖呭埆鍚峔n typeAliasesPackage: com.se.system\n # 閰嶇疆mapper鐨勬壂鎻忥紝鎵惧埌鎵�鏈夌殑mapper.xml鏄犲皠鏂囦欢\n mapperLocations: classpath:mapper/**/*.xml\n\n# swagger閰嶇疆\nswagger:\n title: 绯荤粺妯″潡鎺ュ彛鏂囨。\n license: Powered By se','00678c89684ec0b825cb9b71e032db64','2020-11-20 00:00:00','2023-12-04 07:51:28','nacos','0:0:0:0:0:0:0:1','','','绯荤粺妯″潡','null','null','yaml','',''),
-(6,'se-gen-dev.yml','DEFAULT_GROUP','# spring閰嶇疆\nspring:\n redis:\n host: localhost\n port: 6379\n password:\n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/se-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: password\n\n# mybatis閰嶇疆\nmybatis:\n # 鎼滅储鎸囧畾鍖呭埆鍚峔n typeAliasesPackage: com.se.gen.domain\n # 閰嶇疆mapper鐨勬壂鎻忥紝鎵惧埌鎵�鏈夌殑mapper.xml鏄犲皠鏂囦欢\n mapperLocations: classpath:mapper/**/*.xml\n\n# swagger閰嶇疆\nswagger:\n title: 浠ｇ爜鐢熸垚鎺ュ彛鏂囨。\n # 浠ｇ爜鐢熸垚\ngen:\n # 浣滆�匼n author: se\n # 榛樿鐢熸垚鍖呰矾寰� system 闇�鏀规垚鑷繁鐨勬ā鍧楀悕绉� 濡� system monitor tool\n packageName: com.se.system\n # 鑷姩鍘婚櫎琛ㄥ墠缂�锛岄粯璁ゆ槸false\n autoRemovePre: false\n # 琛ㄥ墠缂�锛堢敓鎴愮被鍚嶄笉浼氬寘鍚〃鍓嶇紑锛屽涓敤閫楀彿鍒嗛殧锛塡n tablePrefix: sys_\n','eb592420b3fceae1402881887b8a6a0d','2020-11-20 00:00:00','2022-09-29 02:49:42','nacos','0:0:0:0:0:0:0:1','','','浠ｇ爜鐢熸垚','null','null','yaml','',''),
-(7,'se-job-dev.yml','DEFAULT_GROUP','# spring閰嶇疆\nspring:\n redis:\n host: localhost\n port: 6379\n password: \n datasource:\n driver-class-name: com.mysql.cj.jdbc.Driver\n url: jdbc:mysql://localhost:3306/se-cloud?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8\n username: root\n password: password\n\n# mybatis閰嶇疆\nmybatis:\n # 鎼滅储鎸囧畾鍖呭埆鍚峔n typeAliasesPackage: com.se.job.domain\n # 閰嶇疆mapper鐨勬壂鎻忥紝鎵惧埌鎵�鏈夌殑mapper.xml鏄犲皠鏂囦欢\n mapperLocations: classpath:mapper/**/*.xml\n\n# swagger閰嶇疆\nswagger:\n title: 瀹氭椂浠诲姟鎺ュ彛鏂囨。\n ','edcf0e3fe13fea07b4ec08b1088f30b3','2020-11-20 00:00:00','2022-09-29 02:50:50','nacos','0:0:0:0:0:0:0:1','','','瀹氭椂浠诲姟','null','null','yaml','',''),
-(8,'se-file-dev.yml','DEFAULT_GROUP','# 鏈湴鏂囦欢涓婁紶 \r\nfile:\r\n domain: http://127.0.0.1:9300\r\n path: D:/se/uploadPath\r\n prefix: /statics\r\n\r\n# FastDFS閰嶇疆\r\nfdfs:\r\n domain: http://8.129.231.12\r\n soTimeout: 3000\r\n connectTimeout: 2000\r\n trackerList: 8.129.231.12:22122\r\n\r\n# Minio閰嶇疆\r\nminio:\r\n url: http://8.129.231.12:9000\r\n accessKey: minioadmin\r\n secretKey: minioadmin\r\n bucketName: test','5382b93f3d8059d6068c0501fdd41195','2020-11-20 00:00:00','2020-12-21 21:01:59',NULL,'0:0:0:0:0:0:0:1','','','鏂囦欢鏈嶅姟','null','null','yaml',NULL,''),
-(9,'sentinel-se-gateway','DEFAULT_GROUP','[\r\n {\r\n \"resource\": \"se-auth\",\r\n \"count\": 500,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n },\r\n {\r\n \"resource\": \"se-system\",\r\n \"count\": 1000,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n },\r\n {\r\n \"resource\": \"se-gen\",\r\n \"count\": 200,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n },\r\n {\r\n \"resource\": \"se-job\",\r\n \"count\": 300,\r\n \"grade\": 1,\r\n \"limitApp\": \"default\",\r\n \"strategy\": 0,\r\n \"controlBehavior\": 0\r\n }\r\n]','9f3a3069261598f74220bc47958ec252','2020-11-20 00:00:00','2020-11-20 00:00:00',NULL,'0:0:0:0:0:0:0:1','','','闄愭祦绛栫暐','null','null','json',NULL,'');
-
-
-/******************************************/
-/* 琛ㄥ悕绉� = config_info_aggr */
-/******************************************/
-CREATE TABLE `config_info_aggr` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `data_id` varchar(255) NOT NULL COMMENT 'data_id',
- `group_id` varchar(255) NOT NULL COMMENT 'group_id',
- `datum_id` varchar(255) NOT NULL COMMENT 'datum_id',
- `content` longtext NOT NULL COMMENT '鍐呭',
- `gmt_modified` datetime NOT NULL COMMENT '淇敼鏃堕棿',
- `app_name` varchar(128) DEFAULT NULL,
- `tenant_id` varchar(128) DEFAULT '' COMMENT '绉熸埛瀛楁',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_configinfoaggr_datagrouptenantdatum` (`data_id`,`group_id`,`tenant_id`,`datum_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='澧炲姞绉熸埛瀛楁';
-
-
-/******************************************/
-/* 琛ㄥ悕绉� = config_info_beta */
-/******************************************/
-CREATE TABLE `config_info_beta` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `data_id` varchar(255) NOT NULL COMMENT 'data_id',
- `group_id` varchar(128) NOT NULL COMMENT 'group_id',
- `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
- `content` longtext NOT NULL COMMENT 'content',
- `beta_ips` varchar(1024) DEFAULT NULL COMMENT 'betaIps',
- `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
- `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `src_user` text COMMENT 'source user',
- `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
- `tenant_id` varchar(128) DEFAULT '' COMMENT '绉熸埛瀛楁',
- `encrypted_data_key` text COMMENT '绉橀挜',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_configinfobeta_datagrouptenant` (`data_id`,`group_id`,`tenant_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_beta';
-
-/******************************************/
-/* 琛ㄥ悕绉� = config_info_tag */
-/******************************************/
-CREATE TABLE `config_info_tag` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `data_id` varchar(255) NOT NULL COMMENT 'data_id',
- `group_id` varchar(128) NOT NULL COMMENT 'group_id',
- `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
- `tag_id` varchar(128) NOT NULL COMMENT 'tag_id',
- `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
- `content` longtext NOT NULL COMMENT 'content',
- `md5` varchar(32) DEFAULT NULL COMMENT 'md5',
- `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `src_user` text COMMENT 'source user',
- `src_ip` varchar(50) DEFAULT NULL COMMENT 'source ip',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_configinfotag_datagrouptenanttag` (`data_id`,`group_id`,`tenant_id`,`tag_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_info_tag';
-
-/******************************************/
-/* 琛ㄥ悕绉� = config_tags_relation */
-/******************************************/
-CREATE TABLE `config_tags_relation` (
- `id` bigint(20) NOT NULL COMMENT 'id',
- `tag_name` varchar(128) NOT NULL COMMENT 'tag_name',
- `tag_type` varchar(64) DEFAULT NULL COMMENT 'tag_type',
- `data_id` varchar(255) NOT NULL COMMENT 'data_id',
- `group_id` varchar(128) NOT NULL COMMENT 'group_id',
- `tenant_id` varchar(128) DEFAULT '' COMMENT 'tenant_id',
- `nid` bigint(20) NOT NULL AUTO_INCREMENT,
- PRIMARY KEY (`nid`),
- UNIQUE KEY `uk_configtagrelation_configidtag` (`id`,`tag_name`,`tag_type`),
- KEY `idx_tenant_id` (`tenant_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='config_tag_relation';
-
-/******************************************/
-/* 琛ㄥ悕绉� = group_capacity */
-/******************************************/
-CREATE TABLE `group_capacity` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
- `group_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Group ID锛岀┖瀛楃琛ㄧず鏁翠釜闆嗙兢',
- `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '閰嶉锛�0琛ㄧず浣跨敤榛樿鍊�',
- `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浣跨敤閲�',
- `max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鍗曚釜閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�',
- `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鑱氬悎瀛愰厤缃渶澶т釜鏁帮紝锛�0琛ㄧず浣跨敤榛樿鍊�',
- `max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鍗曚釜鑱氬悎鏁版嵁鐨勫瓙閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�',
- `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鏈�澶у彉鏇村巻鍙叉暟閲�',
- `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_group_id` (`group_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='闆嗙兢銆佸悇Group瀹归噺淇℃伅琛�';
-
-/******************************************/
-/* 琛ㄥ悕绉� = his_config_info */
-/******************************************/
-CREATE TABLE `his_config_info` (
- `id` bigint(64) unsigned NOT NULL,
- `nid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `data_id` varchar(255) NOT NULL,
- `group_id` varchar(128) NOT NULL,
- `app_name` varchar(128) DEFAULT NULL COMMENT 'app_name',
- `content` longtext NOT NULL,
- `md5` varchar(32) DEFAULT NULL,
- `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
- `src_user` text,
- `src_ip` varchar(50) DEFAULT NULL,
- `op_type` char(10) DEFAULT NULL,
- `tenant_id` varchar(128) DEFAULT '' COMMENT '绉熸埛瀛楁',
- `encrypted_data_key` text COMMENT '绉橀挜',
- PRIMARY KEY (`nid`),
- KEY `idx_gmt_create` (`gmt_create`),
- KEY `idx_gmt_modified` (`gmt_modified`),
- KEY `idx_did` (`data_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='澶氱鎴锋敼閫�';
-
-
-/******************************************/
-/* 鏁版嵁搴撳叏鍚� = nacos_config */
-/* 琛ㄥ悕绉� = tenant_capacity */
-/******************************************/
-CREATE TABLE `tenant_capacity` (
- `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID',
- `tenant_id` varchar(128) NOT NULL DEFAULT '' COMMENT 'Tenant ID',
- `quota` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '閰嶉锛�0琛ㄧず浣跨敤榛樿鍊�',
- `usage` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浣跨敤閲�',
- `max_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鍗曚釜閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�',
- `max_aggr_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鑱氬悎瀛愰厤缃渶澶т釜鏁�',
- `max_aggr_size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鍗曚釜鑱氬悎鏁版嵁鐨勫瓙閰嶇疆澶у皬涓婇檺锛屽崟浣嶄负瀛楄妭锛�0琛ㄧず浣跨敤榛樿鍊�',
- `max_history_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '鏈�澶у彉鏇村巻鍙叉暟閲�',
- `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_tenant_id` (`tenant_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='绉熸埛瀹归噺淇℃伅琛�';
-
-
-CREATE TABLE `tenant_info` (
- `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
- `kp` varchar(128) NOT NULL COMMENT 'kp',
- `tenant_id` varchar(128) default '' COMMENT 'tenant_id',
- `tenant_name` varchar(128) default '' COMMENT 'tenant_name',
- `tenant_desc` varchar(256) DEFAULT NULL COMMENT 'tenant_desc',
- `create_source` varchar(32) DEFAULT NULL COMMENT 'create_source',
- `gmt_create` bigint(20) NOT NULL COMMENT '鍒涘缓鏃堕棿',
- `gmt_modified` bigint(20) NOT NULL COMMENT '淇敼鏃堕棿',
- PRIMARY KEY (`id`),
- UNIQUE KEY `uk_tenant_info_kptenantid` (`kp`,`tenant_id`),
- KEY `idx_tenant_id` (`tenant_id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='tenant_info';
-
-CREATE TABLE `users` (
- `username` varchar(50) NOT NULL PRIMARY KEY,
- `password` varchar(500) NOT NULL,
- `enabled` boolean NOT NULL
-);
-
-CREATE TABLE `roles` (
- `username` varchar(50) NOT NULL,
- `role` varchar(50) NOT NULL,
- UNIQUE INDEX `idx_user_role` (`username` ASC, `role` ASC) USING BTREE
-);
-
-CREATE TABLE `permissions` (
- `role` varchar(50) NOT NULL,
- `resource` varchar(255) NOT NULL,
- `action` varchar(8) NOT NULL,
- UNIQUE INDEX `uk_role_permission` (`role`,`resource`,`action`) USING BTREE
-);
-
-INSERT INTO users (username, password, enabled) VALUES ('nacos', '$2a$10$EuWPZHzz32dJN7jexM34MOeYirDdFAZm2kuWj7VEOJhhZkDrxfvUu', TRUE);
-
-INSERT INTO roles (username, role) VALUES ('nacos', 'ROLE_ADMIN');
diff --git a/sql/se_quartz.sql b/sql/se_quartz.sql
deleted file mode 100644
index 6b6e705..0000000
--- a/sql/se_quartz.sql
+++ /dev/null
@@ -1,183 +0,0 @@
--- DROP DATABASE IF EXISTS `se-cloud`;
-
-CREATE DATABASE IF NOT EXISTS `se-cloud` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-
-SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
-
-USE `se-cloud`;
-
-DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
-DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
-DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
-DROP TABLE IF EXISTS QRTZ_LOCKS;
-DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
-DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;
-DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
-DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
-DROP TABLE IF EXISTS QRTZ_TRIGGERS;
-DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
-DROP TABLE IF EXISTS QRTZ_CALENDARS;
-
--- ----------------------------
--- 1銆佸瓨鍌ㄦ瘡涓�涓凡閰嶇疆鐨� jobDetail 鐨勮缁嗕俊鎭�
--- ----------------------------
-create table QRTZ_JOB_DETAILS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- job_name varchar(200) not null comment '浠诲姟鍚嶇О',
- job_group varchar(200) not null comment '浠诲姟缁勫悕',
- description varchar(250) null comment '鐩稿叧浠嬬粛',
- job_class_name varchar(250) not null comment '鎵ц浠诲姟绫诲悕绉�',
- is_durable varchar(1) not null comment '鏄惁鎸佷箙鍖�',
- is_nonconcurrent varchar(1) not null comment '鏄惁骞跺彂',
- is_update_data varchar(1) not null comment '鏄惁鏇存柊鏁版嵁',
- requests_recovery varchar(1) not null comment '鏄惁鎺ュ彈鎭㈠鎵ц',
- job_data blob null comment '瀛樻斁鎸佷箙鍖杍ob瀵硅薄',
- primary key (sched_name, job_name, job_group)
-) engine=innodb comment = '浠诲姟璇︾粏淇℃伅琛�';
-
--- ----------------------------
--- 2銆� 瀛樺偍宸查厤缃殑 Trigger 鐨勪俊鎭�
--- ----------------------------
-create table QRTZ_TRIGGERS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- trigger_name varchar(200) not null comment '瑙﹀彂鍣ㄧ殑鍚嶅瓧',
- trigger_group varchar(200) not null comment '瑙﹀彂鍣ㄦ墍灞炵粍鐨勫悕瀛�',
- job_name varchar(200) not null comment 'qrtz_job_details琛╦ob_name鐨勫閿�',
- job_group varchar(200) not null comment 'qrtz_job_details琛╦ob_group鐨勫閿�',
- description varchar(250) null comment '鐩稿叧浠嬬粛',
- next_fire_time bigint(13) null comment '涓婁竴娆¤Е鍙戞椂闂达紙姣锛�',
- prev_fire_time bigint(13) null comment '涓嬩竴娆¤Е鍙戞椂闂达紙榛樿涓�-1琛ㄧず涓嶈Е鍙戯級',
- priority integer null comment '浼樺厛绾�',
- trigger_state varchar(16) not null comment '瑙﹀彂鍣ㄧ姸鎬�',
- trigger_type varchar(8) not null comment '瑙﹀彂鍣ㄧ殑绫诲瀷',
- start_time bigint(13) not null comment '寮�濮嬫椂闂�',
- end_time bigint(13) null comment '缁撴潫鏃堕棿',
- calendar_name varchar(200) null comment '鏃ョ▼琛ㄥ悕绉�',
- misfire_instr smallint(2) null comment '琛ュ伩鎵ц鐨勭瓥鐣�',
- job_data blob null comment '瀛樻斁鎸佷箙鍖杍ob瀵硅薄',
- primary key (sched_name, trigger_name, trigger_group),
- foreign key (sched_name, job_name, job_group) references QRTZ_JOB_DETAILS(sched_name, job_name, job_group)
-) engine=innodb comment = '瑙﹀彂鍣ㄨ缁嗕俊鎭〃';
-
--- ----------------------------
--- 3銆� 瀛樺偍绠�鍗曠殑 Trigger锛屽寘鎷噸澶嶆鏁帮紝闂撮殧锛屼互鍙婂凡瑙﹀彂鐨勬鏁�
--- ----------------------------
-create table QRTZ_SIMPLE_TRIGGERS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�',
- trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�',
- repeat_count bigint(7) not null comment '閲嶅鐨勬鏁扮粺璁�',
- repeat_interval bigint(12) not null comment '閲嶅鐨勯棿闅旀椂闂�',
- times_triggered bigint(10) not null comment '宸茬粡瑙﹀彂鐨勬鏁�',
- primary key (sched_name, trigger_name, trigger_group),
- foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group)
-) engine=innodb comment = '绠�鍗曡Е鍙戝櫒鐨勪俊鎭〃';
-
--- ----------------------------
--- 4銆� 瀛樺偍 Cron Trigger锛屽寘鎷� Cron 琛ㄨ揪寮忓拰鏃跺尯淇℃伅
--- ----------------------------
-create table QRTZ_CRON_TRIGGERS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�',
- trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�',
- cron_expression varchar(200) not null comment 'cron琛ㄨ揪寮�',
- time_zone_id varchar(80) comment '鏃跺尯',
- primary key (sched_name, trigger_name, trigger_group),
- foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group)
-) engine=innodb comment = 'Cron绫诲瀷鐨勮Е鍙戝櫒琛�';
-
--- ----------------------------
--- 5銆� Trigger 浣滀负 Blob 绫诲瀷瀛樺偍(鐢ㄤ簬 Quartz 鐢ㄦ埛鐢� JDBC 鍒涘缓浠栦滑鑷繁瀹氬埗鐨� Trigger 绫诲瀷锛孞obStore 骞朵笉鐭ラ亾濡備綍瀛樺偍瀹炰緥鐨勬椂鍊�)
--- ----------------------------
-create table QRTZ_BLOB_TRIGGERS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�',
- trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�',
- blob_data blob null comment '瀛樻斁鎸佷箙鍖朤rigger瀵硅薄',
- primary key (sched_name, trigger_name, trigger_group),
- foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group)
-) engine=innodb comment = 'Blob绫诲瀷鐨勮Е鍙戝櫒琛�';
-
--- ----------------------------
--- 6銆� 浠� Blob 绫诲瀷瀛樺偍瀛樻斁鏃ュ巻淇℃伅锛� quartz鍙厤缃竴涓棩鍘嗘潵鎸囧畾涓�涓椂闂磋寖鍥�
--- ----------------------------
-create table QRTZ_CALENDARS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- calendar_name varchar(200) not null comment '鏃ュ巻鍚嶇О',
- calendar blob not null comment '瀛樻斁鎸佷箙鍖朿alendar瀵硅薄',
- primary key (sched_name, calendar_name)
-) engine=innodb comment = '鏃ュ巻淇℃伅琛�';
-
--- ----------------------------
--- 7銆� 瀛樺偍宸叉殏鍋滅殑 Trigger 缁勭殑淇℃伅
--- ----------------------------
-create table QRTZ_PAUSED_TRIGGER_GRPS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�',
- primary key (sched_name, trigger_group)
-) engine=innodb comment = '鏆傚仠鐨勮Е鍙戝櫒琛�';
-
--- ----------------------------
--- 8銆� 瀛樺偍涓庡凡瑙﹀彂鐨� Trigger 鐩稿叧鐨勭姸鎬佷俊鎭紝浠ュ強鐩歌仈 Job 鐨勬墽琛屼俊鎭�
--- ----------------------------
-create table QRTZ_FIRED_TRIGGERS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- entry_id varchar(95) not null comment '璋冨害鍣ㄥ疄渚媔d',
- trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�',
- trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�',
- instance_name varchar(200) not null comment '璋冨害鍣ㄥ疄渚嬪悕',
- fired_time bigint(13) not null comment '瑙﹀彂鐨勬椂闂�',
- sched_time bigint(13) not null comment '瀹氭椂鍣ㄥ埗瀹氱殑鏃堕棿',
- priority integer not null comment '浼樺厛绾�',
- state varchar(16) not null comment '鐘舵��',
- job_name varchar(200) null comment '浠诲姟鍚嶇О',
- job_group varchar(200) null comment '浠诲姟缁勫悕',
- is_nonconcurrent varchar(1) null comment '鏄惁骞跺彂',
- requests_recovery varchar(1) null comment '鏄惁鎺ュ彈鎭㈠鎵ц',
- primary key (sched_name, entry_id)
-) engine=innodb comment = '宸茶Е鍙戠殑瑙﹀彂鍣ㄨ〃';
-
--- ----------------------------
--- 9銆� 瀛樺偍灏戦噺鐨勬湁鍏� Scheduler 鐨勭姸鎬佷俊鎭紝鍋囧鏄敤浜庨泦缇や腑锛屽彲浠ョ湅鍒板叾浠栫殑 Scheduler 瀹炰緥
--- ----------------------------
-create table QRTZ_SCHEDULER_STATE (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- instance_name varchar(200) not null comment '瀹炰緥鍚嶇О',
- last_checkin_time bigint(13) not null comment '涓婃妫�鏌ユ椂闂�',
- checkin_interval bigint(13) not null comment '妫�鏌ラ棿闅旀椂闂�',
- primary key (sched_name, instance_name)
-) engine=innodb comment = '璋冨害鍣ㄧ姸鎬佽〃';
-
--- ----------------------------
--- 10銆� 瀛樺偍绋嬪簭鐨勬偛瑙傞攣鐨勪俊鎭�(鍋囧浣跨敤浜嗘偛瑙傞攣)
--- ----------------------------
-create table QRTZ_LOCKS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- lock_name varchar(40) not null comment '鎮茶閿佸悕绉�',
- primary key (sched_name, lock_name)
-) engine=innodb comment = '瀛樺偍鐨勬偛瑙傞攣淇℃伅琛�';
-
--- ----------------------------
--- 11銆� Quartz闆嗙兢瀹炵幇鍚屾鏈哄埗鐨勮閿佽〃
--- ----------------------------
-create table QRTZ_SIMPROP_TRIGGERS (
- sched_name varchar(120) not null comment '璋冨害鍚嶇О',
- trigger_name varchar(200) not null comment 'qrtz_triggers琛╰rigger_name鐨勫閿�',
- trigger_group varchar(200) not null comment 'qrtz_triggers琛╰rigger_group鐨勫閿�',
- str_prop_1 varchar(512) null comment 'String绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�',
- str_prop_2 varchar(512) null comment 'String绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟',
- str_prop_3 varchar(512) null comment 'String绫诲瀷鐨則rigger鐨勭涓変釜鍙傛暟',
- int_prop_1 int null comment 'int绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�',
- int_prop_2 int null comment 'int绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟',
- long_prop_1 bigint null comment 'long绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�',
- long_prop_2 bigint null comment 'long绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟',
- dec_prop_1 numeric(13,4) null comment 'decimal绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�',
- dec_prop_2 numeric(13,4) null comment 'decimal绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟',
- bool_prop_1 varchar(1) null comment 'Boolean绫诲瀷鐨則rigger鐨勭涓�涓弬鏁�',
- bool_prop_2 varchar(1) null comment 'Boolean绫诲瀷鐨則rigger鐨勭浜屼釜鍙傛暟',
- primary key (sched_name, trigger_name, trigger_group),
- foreign key (sched_name, trigger_name, trigger_group) references QRTZ_TRIGGERS(sched_name, trigger_name, trigger_group)
-) engine=innodb comment = '鍚屾鏈哄埗鐨勮閿佽〃';
-
-commit;
\ No newline at end of file
diff --git a/sql/se_seata_20210128.sql b/sql/se_seata_20210128.sql
deleted file mode 100644
index a6b74a9..0000000
--- a/sql/se_seata_20210128.sql
+++ /dev/null
@@ -1,80 +0,0 @@
-DROP DATABASE IF EXISTS `se-seata`;
-
-CREATE DATABASE `se-seata` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
-
-SET NAMES utf8mb4;
-SET FOREIGN_KEY_CHECKS = 0;
-
-USE `se-seata`;
-
--- -------------------------------- The script used when storeMode is 'db' --------------------------------
--- the table to store GlobalSession data
-CREATE TABLE IF NOT EXISTS `global_table`
-(
- `xid` VARCHAR(128) NOT NULL,
- `transaction_id` BIGINT,
- `status` TINYINT NOT NULL,
- `application_id` VARCHAR(32),
- `transaction_service_group` VARCHAR(32),
- `transaction_name` VARCHAR(128),
- `timeout` INT,
- `begin_time` BIGINT,
- `application_data` VARCHAR(2000),
- `gmt_create` DATETIME,
- `gmt_modified` DATETIME,
- PRIMARY KEY (`xid`),
- KEY `idx_gmt_modified_status` (`gmt_modified`, `status`),
- KEY `idx_transaction_id` (`transaction_id`)
-) ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4;
-
--- the table to store BranchSession data
-CREATE TABLE IF NOT EXISTS `branch_table`
-(
- `branch_id` BIGINT NOT NULL,
- `xid` VARCHAR(128) NOT NULL,
- `transaction_id` BIGINT,
- `resource_group_id` VARCHAR(32),
- `resource_id` VARCHAR(256),
- `branch_type` VARCHAR(8),
- `status` TINYINT,
- `client_id` VARCHAR(64),
- `application_data` VARCHAR(2000),
- `gmt_create` DATETIME(6),
- `gmt_modified` DATETIME(6),
- PRIMARY KEY (`branch_id`),
- KEY `idx_xid` (`xid`)
-) ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4;
-
--- the table to store lock data
-CREATE TABLE IF NOT EXISTS `lock_table`
-(
- `row_key` VARCHAR(128) NOT NULL,
- `xid` VARCHAR(96),
- `transaction_id` BIGINT,
- `branch_id` BIGINT NOT NULL,
- `resource_id` VARCHAR(256),
- `table_name` VARCHAR(32),
- `pk` VARCHAR(36),
- `gmt_create` DATETIME,
- `gmt_modified` DATETIME,
- PRIMARY KEY (`row_key`),
- KEY `idx_branch_id` (`branch_id`)
-) ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4;
-
--- for AT mode you must to init this sql for you business database. the seata server not need it.
-CREATE TABLE IF NOT EXISTS `undo_log`
-(
- `branch_id` BIGINT(20) NOT NULL COMMENT 'branch transaction id',
- `xid` VARCHAR(100) NOT NULL COMMENT 'global transaction id',
- `context` VARCHAR(128) NOT NULL COMMENT 'undo_log context,such as serialization',
- `rollback_info` LONGBLOB NOT NULL COMMENT 'rollback info',
- `log_status` INT(11) NOT NULL COMMENT '0:normal status,1:defense status',
- `log_created` DATETIME(6) NOT NULL COMMENT 'create datetime',
- `log_modified` DATETIME(6) NOT NULL COMMENT 'modify datetime',
- UNIQUE KEY `ux_undo_log` (`xid`, `branch_id`)
-) ENGINE = InnoDB
- AUTO_INCREMENT = 1
- DEFAULT CHARSET = utf8mb4 COMMENT ='AT transaction mode undo table';
\ No newline at end of file
--
Gitblit v1.9.3