docs/sql/oauth2.sql · 分布式应用开发/open-cloud

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

1 Star 0 Fork 772

分布式应用开发/open-cloud

forked from soler/open-cloud

代码 Issues 0 Pull Requests 0 Wiki 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (1)

标签 (1)

管理

master

v3.0.0

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 1

标签 1

open-cloud

docs

sql

oauth2.sql

oauth2.sql 5.17 KB

/*
Navicat MySQL Data Transfer

Source Server : localhost
Source Server Version : 50528
Source Host : localhost:3306
Source Database : open-platform

Target Server Type : MYSQL
Target Server Version : 50528
File Encoding : 65001

Date: 2019年07月11日 18:33:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for oauth_access_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_token`;
CREATE TABLE `oauth_access_token` (
 `token_id` varchar(256) DEFAULT NULL,
 `token` blob,
 `authentication_id` varchar(128) NOT NULL,
 `user_name` varchar(256) DEFAULT NULL,
 `client_id` varchar(256) DEFAULT NULL,
 `authentication` blob,
 `refresh_token` varchar(256) DEFAULT NULL,
 PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2访问令牌';

-- ----------------------------
-- Records of oauth_access_token
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_approvals
-- ----------------------------
DROP TABLE IF EXISTS `oauth_approvals`;
CREATE TABLE `oauth_approvals` (
 `userId` varchar(256) DEFAULT NULL,
 `clientId` varchar(256) DEFAULT NULL,
 `scope` varchar(256) DEFAULT NULL,
 `status` varchar(10) DEFAULT NULL,
 `expiresAt` datetime DEFAULT NULL,
 `lastModifiedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2已授权客户端';

-- ----------------------------
-- Records of oauth_approvals
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
 `client_id` varchar(128) NOT NULL,
 `client_secret` varchar(256) NOT NULL,
 `resource_ids` varchar(256) DEFAULT NULL,
 `scope` varchar(1024) DEFAULT NULL,
 `authorized_grant_types` varchar(256) DEFAULT NULL,
 `web_server_redirect_uri` varchar(256) DEFAULT NULL,
 `authorities` varchar(2048) DEFAULT NULL,
 `access_token_validity` int(11) DEFAULT NULL,
 `refresh_token_validity` int(11) DEFAULT NULL,
 `additional_information` varchar(4096) DEFAULT NULL,
 `autoapprove` varchar(256) DEFAULT NULL,
 PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2客户端信息';

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
INSERT INTO `oauth_client_details` VALUES ('7gBZcbsC7kLIWCdELIl8nxcs', '2ドルa10ドル4ドルdi0sSQdr9yk4uTKWtZqzedsxI8sWXoR67x.G.Qmy4K2L7ZaFQt6W', '', 'userProfile', 'authorization_code,client_credentials,password', 'http://localhost:8888/login,http://localhost:8888/webjars/springfox-swagger-ui/o2c.html,http://www.baidu.com', '', '43200', '2592000', '{\"website\":\"http://www.baidu.com\",\"apiKey\":\"7gBZcbsC7kLIWCdELIl8nxcs\",\"secretKey\":\"0osTIhce7uPvDKHz6aa67bhCukaKoYl4\",\"appName\":\"平台用户认证服务器\",\"updateTime\":1562841065000,\"isPersist\":1,\"appOs\":\"\",\"appIcon\":\"\",\"developerId\":0,\"createTime\":1542016125000,\"appType\":\"server\",\"appDesc\":\"资源服务器\",\"appId\":\"1552274783265\",\"appNameEn\":\"open-cloud-uaa-admin-server\",\"status\":1}', '');
INSERT INTO `oauth_client_details` VALUES ('rOOM15Zbc3UFWgW2h71gRFvi', '2ドルa10ドル$NSb94sKA5i9kS/F0mUBehuBs9Gtvlv8wdxQOYMg3WxMRt0nyP2Xn.', '', 'userProfile', 'authorization_code,client_credentials,password', 'http://localhost:2222/login', '', '43200', '2592000', '{\"website\":\"http://www.baidu.com\",\"apiKey\":\"rOOM15Zbc3UFWgW2h71gRFvi\",\"secretKey\":\"2Iw2B0UCMYd1cZjt8Fpr4KJUx75wQCwW\",\"appName\":\"SSO单点登录DEMO\",\"updateTime\":1568611165000,\"isPersist\":1,\"appOs\":\"\",\"appIcon\":\"\",\"developerId\":0,\"createTime\":1542016125000,\"appType\":\"pc\",\"appDesc\":\"sso\",\"appId\":\"1552294656514\",\"appNameEn\":\"sso-demo\",\"status\":1}', '');

-- ----------------------------
-- Table structure for oauth_client_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_token`;
CREATE TABLE `oauth_client_token` (
 `token_id` varchar(256) DEFAULT NULL,
 `token` blob,
 `authentication_id` varchar(128) NOT NULL,
 `user_name` varchar(256) DEFAULT NULL,
 `client_id` varchar(256) DEFAULT NULL,
 PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2客户端令牌';

-- ----------------------------
-- Records of oauth_client_token
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_code
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE `oauth_code` (
 `code` varchar(256) DEFAULT NULL,
 `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2授权码';

-- ----------------------------
-- Records of oauth_code
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_refresh_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE `oauth_refresh_token` (
 `token_id` varchar(256) DEFAULT NULL,
 `token` blob,
 `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2刷新令牌';

-- ----------------------------
-- Records of oauth_refresh_token
-- ----------------------------
SET FOREIGN_KEY_CHECKS=1;

一键复制编辑原始数据按行查看历史

soler 提交于 2019年09月16日 13:52 +08:00 . 增加sso 演示客户端 ,修改sso认证地址

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122

/*
Navicat MySQL Data Transfer

Source Server : localhost
Source Server Version : 50528
Source Host : localhost:3306
Source Database : open-platform

Target Server Type : MYSQL
Target Server Version : 50528
File Encoding : 65001

Date: 2019年07月11日 18:33:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for oauth_access_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_token`;
CREATE TABLE `oauth_access_token` (
 `token_id` varchar(256) DEFAULT NULL,
 `token` blob,
 `authentication_id` varchar(128) NOT NULL,
 `user_name` varchar(256) DEFAULT NULL,
 `client_id` varchar(256) DEFAULT NULL,
 `authentication` blob,
 `refresh_token` varchar(256) DEFAULT NULL,
 PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2访问令牌';

-- ----------------------------
-- Records of oauth_access_token
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_approvals
-- ----------------------------
DROP TABLE IF EXISTS `oauth_approvals`;
CREATE TABLE `oauth_approvals` (
 `userId` varchar(256) DEFAULT NULL,
 `clientId` varchar(256) DEFAULT NULL,
 `scope` varchar(256) DEFAULT NULL,
 `status` varchar(10) DEFAULT NULL,
 `expiresAt` datetime DEFAULT NULL,
 `lastModifiedAt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2已授权客户端';

-- ----------------------------
-- Records of oauth_approvals
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details` (
 `client_id` varchar(128) NOT NULL,
 `client_secret` varchar(256) NOT NULL,
 `resource_ids` varchar(256) DEFAULT NULL,
 `scope` varchar(1024) DEFAULT NULL,
 `authorized_grant_types` varchar(256) DEFAULT NULL,
 `web_server_redirect_uri` varchar(256) DEFAULT NULL,
 `authorities` varchar(2048) DEFAULT NULL,
 `access_token_validity` int(11) DEFAULT NULL,
 `refresh_token_validity` int(11) DEFAULT NULL,
 `additional_information` varchar(4096) DEFAULT NULL,
 `autoapprove` varchar(256) DEFAULT NULL,
 PRIMARY KEY (`client_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2客户端信息';

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
INSERT INTO `oauth_client_details` VALUES ('7gBZcbsC7kLIWCdELIl8nxcs', '2ドルa10ドル4ドルdi0sSQdr9yk4uTKWtZqzedsxI8sWXoR67x.G.Qmy4K2L7ZaFQt6W', '', 'userProfile', 'authorization_code,client_credentials,password', 'http://localhost:8888/login,http://localhost:8888/webjars/springfox-swagger-ui/o2c.html,http://www.baidu.com', '', '43200', '2592000', '{\"website\":\"http://www.baidu.com\",\"apiKey\":\"7gBZcbsC7kLIWCdELIl8nxcs\",\"secretKey\":\"0osTIhce7uPvDKHz6aa67bhCukaKoYl4\",\"appName\":\"平台用户认证服务器\",\"updateTime\":1562841065000,\"isPersist\":1,\"appOs\":\"\",\"appIcon\":\"\",\"developerId\":0,\"createTime\":1542016125000,\"appType\":\"server\",\"appDesc\":\"资源服务器\",\"appId\":\"1552274783265\",\"appNameEn\":\"open-cloud-uaa-admin-server\",\"status\":1}', '');
INSERT INTO `oauth_client_details` VALUES ('rOOM15Zbc3UFWgW2h71gRFvi', '2ドルa10ドル$NSb94sKA5i9kS/F0mUBehuBs9Gtvlv8wdxQOYMg3WxMRt0nyP2Xn.', '', 'userProfile', 'authorization_code,client_credentials,password', 'http://localhost:2222/login', '', '43200', '2592000', '{\"website\":\"http://www.baidu.com\",\"apiKey\":\"rOOM15Zbc3UFWgW2h71gRFvi\",\"secretKey\":\"2Iw2B0UCMYd1cZjt8Fpr4KJUx75wQCwW\",\"appName\":\"SSO单点登录DEMO\",\"updateTime\":1568611165000,\"isPersist\":1,\"appOs\":\"\",\"appIcon\":\"\",\"developerId\":0,\"createTime\":1542016125000,\"appType\":\"pc\",\"appDesc\":\"sso\",\"appId\":\"1552294656514\",\"appNameEn\":\"sso-demo\",\"status\":1}', '');

-- ----------------------------
-- Table structure for oauth_client_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_token`;
CREATE TABLE `oauth_client_token` (
 `token_id` varchar(256) DEFAULT NULL,
 `token` blob,
 `authentication_id` varchar(128) NOT NULL,
 `user_name` varchar(256) DEFAULT NULL,
 `client_id` varchar(256) DEFAULT NULL,
 PRIMARY KEY (`authentication_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2客户端令牌';

-- ----------------------------
-- Records of oauth_client_token
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_code
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE `oauth_code` (
 `code` varchar(256) DEFAULT NULL,
 `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2授权码';

-- ----------------------------
-- Records of oauth_code
-- ----------------------------

-- ----------------------------
-- Table structure for oauth_refresh_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE `oauth_refresh_token` (
 `token_id` varchar(256) DEFAULT NULL,
 `token` blob,
 `authentication` blob
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2刷新令牌';

-- ----------------------------
-- Records of oauth_refresh_token
-- ----------------------------
SET FOREIGN_KEY_CHECKS=1;