From 50fbfe2cb4271e46f28eb53ea44e93671c7aef49 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期二, 20 六月 2023 12:11:12 +0800
Subject: [PATCH] !370 扩展第三方登录授权功能 * add 查看授权列表 * 优化第三方授权登录 * 第三方授权登录,加上配置 * 优化，第三方授权登录 * 新增加第三方登录授权功能
---
script/sql/ry_vue_5.X.sql | 79 ++++++++++++++++++---------------------
1 files changed, 36 insertions(+), 43 deletions(-)
diff --git a/script/sql/ry_vue_5.X.sql b/script/sql/ry_vue_5.X.sql
index 8c10bb2..e772d3b 100644
--- a/script/sql/ry_vue_5.X.sql
+++ b/script/sql/ry_vue_5.X.sql
@@ -1,43 +1,40 @@
-
-- ----------------------------
-- 绗笁鏂瑰钩鍙版巿鏉冭〃
-- ----------------------------
-CREATE TABLE `social_user`
+DROP TABLE IF EXISTS social_user;
+CREATE TABLE social_user
(
- `id` bigint unsigned NOT NULL COMMENT '涓婚敭',
- `user_id` bigint NOT NULL COMMENT '鐢ㄦ埛ID',
- `tenant_id` varchar(20) DEFAULT NULL COMMENT '绉熸埛id',
- `auth_id` varchar(255) NOT NULL COMMENT '鎺堟潈+鎺堟潈openid',
- `source` varchar(255) NOT NULL COMMENT '鐢ㄦ埛鏉ユ簮',
- `open_id` varchar(255) DEFAULT NULL COMMENT '鍘熺敓open id',
- `user_name` varchar(30) NOT NULL COMMENT '鐧诲綍璐﹀彿',
- `nick_name` varchar(30) DEFAULT '' COMMENT '鐢ㄦ埛鏄电О',
- `email` varchar(255) DEFAULT '' COMMENT '鐢ㄦ埛閭',
- `avatar` varchar(500) DEFAULT '' COMMENT '澶村儚鍦板潃',
- `access_token` varchar(255) NOT NULL COMMENT '鐢ㄦ埛鐨勬巿鏉冧护鐗�',
- `expire_in` int DEFAULT NULL COMMENT '鐢ㄦ埛鐨勬巿鏉冧护鐗岀殑鏈夋晥鏈燂紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `refresh_token` varchar(255) DEFAULT NULL COMMENT '鍒锋柊浠ょ墝锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
- `access_code` varchar(255) DEFAULT NULL COMMENT '骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `union_id` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛鐨� unionid',
- `scope` varchar(255) DEFAULT NULL COMMENT '鎺堜簣鐨勬潈闄愶紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `token_type` varchar(255) DEFAULT NULL COMMENT '涓埆骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `id_token` varchar(255) DEFAULT NULL COMMENT 'id token锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
- `mac_algorithm` varchar(255) DEFAULT NULL COMMENT '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `mac_key` varchar(255) DEFAULT NULL COMMENT '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `code` varchar(255) DEFAULT NULL COMMENT '鐢ㄦ埛鐨勬巿鏉僣ode锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
- `oauth_token` varchar(255) DEFAULT NULL COMMENT 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `oauth_token_secret` varchar(255) DEFAULT NULL COMMENT 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
- `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓閮ㄩ棬',
- `create_by` bigint NOT NULL COMMENT '鍒涘缓浜�',
- `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- `update_by` bigint NOT NULL COMMENT '鏇存柊浜�',
- `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
- `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '0' COMMENT '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
- PRIMARY KEY (`id`) USING BTREE
-) ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4
- COLLATE = utf8mb4_general_ci
- ROW_FORMAT = DYNAMIC COMMENT ='绀句細鍖栧叧绯昏〃';
+ id BIGINT UNSIGNED NOT NULL COMMENT '涓婚敭',
+ user_id BIGINT NOT NULL COMMENT '鐢ㄦ埛ID',
+ tenant_id VARCHAR(20) DEFAULT NULL COMMENT '绉熸埛id',
+ auth_id VARCHAR(255) NOT NULL COMMENT '鎺堟潈+鎺堟潈openid',
+ source VARCHAR(255) NOT NULL COMMENT '鐢ㄦ埛鏉ユ簮',
+ open_id VARCHAR(255) DEFAULT NULL COMMENT '鍘熺敓open id',
+ user_name VARCHAR(30) NOT NULL COMMENT '鐧诲綍璐﹀彿',
+ nick_name VARCHAR(30) DEFAULT '' COMMENT '鐢ㄦ埛鏄电О',
+ email VARCHAR(255) DEFAULT '' COMMENT '鐢ㄦ埛閭',
+ avatar VARCHAR(500) DEFAULT '' COMMENT '澶村儚鍦板潃',
+ access_token VARCHAR(255) NOT NULL COMMENT '鐢ㄦ埛鐨勬巿鏉冧护鐗�',
+ expire_in INT DEFAULT NULL COMMENT '鐢ㄦ埛鐨勬巿鏉冧护鐗岀殑鏈夋晥鏈燂紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ refresh_token VARCHAR(255) DEFAULT NULL COMMENT '鍒锋柊浠ょ墝锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
+ access_code VARCHAR(255) DEFAULT NULL COMMENT '骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ union_id VARCHAR(255) DEFAULT NULL COMMENT '鐢ㄦ埛鐨� unionid',
+ scope VARCHAR(255) DEFAULT NULL COMMENT '鎺堜簣鐨勬潈闄愶紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ token_type VARCHAR(255) DEFAULT NULL COMMENT '涓埆骞冲彴鐨勬巿鏉冧俊鎭紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ id_token VARCHAR(255) DEFAULT NULL COMMENT 'id token锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
+ mac_algorithm VARCHAR(255) DEFAULT NULL COMMENT '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ mac_key VARCHAR(255) DEFAULT NULL COMMENT '灏忕背骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ code VARCHAR(255) DEFAULT NULL COMMENT '鐢ㄦ埛鐨勬巿鏉僣ode锛岄儴鍒嗗钩鍙板彲鑳芥病鏈�',
+ oauth_token VARCHAR(255) DEFAULT NULL COMMENT 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ oauth_token_secret VARCHAR(255) DEFAULT NULL COMMENT 'Twitter骞冲彴鐢ㄦ埛鐨勯檮甯﹀睘鎬э紝閮ㄥ垎骞冲彴鍙兘娌℃湁',
+ create_dept bigint(20) comment '鍒涘缓閮ㄩ棬',
+ create_by bigint(20) comment '鍒涘缓鑰�',
+ create_time datetime comment '鍒涘缓鏃堕棿',
+ update_by bigint(20) comment '鏇存柊鑰�',
+ update_time datetime comment '鏇存柊鏃堕棿',
+ del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�',
+ PRIMARY KEY (id)
+) ENGINE = InnoDB COMMENT ='绀句細鍖栧叧绯昏〃';
-- ----------------------------
-- 绉熸埛琛�
@@ -373,13 +370,9 @@
values ('117', 'Admin鐩戞帶', '2', '5', 'Admin', 'monitor/admin/index', '', 1, 0, 'C', '0', '0', 'monitor:admin:list',
'dashboard', 103, 1, sysdate(), null, null, 'Admin鐩戞帶鑿滃崟');
-- oss鑿滃崟
-insert into sys_menu
-values ('118', '鏂囦欢绠＄悊', '1', '10', 'oss', 'system/oss/index', '', 1, 0, 'C', '0', '0', 'system:oss:list', 'upload',
- 103, 1, sysdate(), null, null, '鏂囦欢绠＄悊鑿滃崟');
--- xxl-job-admin鎺у埗鍙�
-insert into sys_menu
-values ('120', '浠诲姟璋冨害涓績', '2', '5', 'XxlJob', 'monitor/xxljob/index', '', 1, 0, 'C', '0', '0',
- 'monitor:xxljob:list', 'job', 103, 1, sysdate(), null, null, 'Xxl-Job鎺у埗鍙拌彍鍗�');
+insert into sys_menu values('118', '鏂囦欢绠＄悊', '1', '10', 'oss', 'system/oss/index', '', 1, 0, 'C', '0', '0', 'system:oss:list', 'upload', 103, 1, sysdate(), null, null, '鏂囦欢绠＄悊鑿滃崟');
+-- powerjob server鎺у埗鍙�
+insert into sys_menu values('120', '浠诲姟璋冨害涓績', '2', '5', 'powerjob', 'monitor/powerjob/index', '', 1, 0, 'C', '0', '0', 'monitor:powerjob:list', 'job', 103, 1, sysdate(), null, null, 'PowerJob鎺у埗鍙拌彍鍗�');
-- 涓夌骇鑿滃崟
insert into sys_menu
--
Gitblit v1.9.3