编程人 cdmana.com

spring security几种模式请求方式详细总结

 

授权码模式

 

1、获取令牌

 

GET 请求
http://localhost:3000/oauth/authorize?client_id=client&response_type=code&redirect_uri=https://www.baidu.com&state=fuce&scope=app

数据库表(oauth_client_details)
INSERT INTO `springbootv2`.`oauth_client_details`(`client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `autoapprove`) VALUES ('client', NULL, '$2a$10$fRoGVj/GImYu26ZLUYJd6O3tWfnZL2rhaMjCbTAkJ8uJLBxAhoaIe', 'app', 'authorization_code', 'https://www.baidu.com', NULL, NULL, NULL, NULL, NULL);

 

参数

具体值

备注

client_id

client

数据库字段client_id

response_type

code

访问类型

redirect_uri

https://www.baidu.com

数据库字段回调地址

state

xxo

为了防止CSRF攻击,在申请授权码这一步时,可以在参数中增加一个state状态参数,这个参数是由客户端生成的随机字符串,授权服务会原封不动的返回这个参数和参数值,用户进行授权客户端的请求时也会携带此字符串用于比较。

scope

app

数据库字段scope

 

 

 

 

2、获取token

 

POST请求
http://localhost:3000/oauth/token

请求参数

参数

具体值

备注

grant_type

authorization_code

授权类型

code

A2Y7NQ

授权码code

client_id

client

数据库字段-client_id

client_secret

secret

数据库字段—客户端secret

redirect_uri

https://www.baidu.com

数据库字段 回调地址

 

 

 

 

 

密码模式

 

POST请求
http://localhost:3000/oauth/token

数据库表(oauth_client_details)

INSERT INTO `springbootv2`.`oauth_client_details`(`client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `autoapprove`) VALUES ('client1', NULL, '$2a$10$fRoGVj/GImYu26ZLUYJd6O3tWfnZL2rhaMjCbTAkJ8uJLBxAhoaIe', 'app', 'password', 'https://www.baidu.com', NULL, NULL, NULL, NULL, NULL);

请求参数

参数

具体值

备注

grant_type

password

授权类型

username

admin

用户账户

password

admin

用户密码

client_id

client1

数据库字段-client_id

client_secret

secret

数据库字段—客户端secret

scope

app

数据库字段

 

 

 

 

 

客户端模式

 

 

POST请求
http://localhost:3000/oauth/token

数据库表(oauth_client_details)

INSERT INTO `springbootv2`.`oauth_client_details`(`client_id`, `resource_ids`, `client_secret`, `scope`, `authorized_grant_types`, `web_server_redirect_uri`, `authorities`, `access_token_validity`, `refresh_token_validity`, `additional_information`, `autoapprove`) VALUES ('client2', NULL, '$2a$10$fRoGVj/GImYu26ZLUYJd6O3tWfnZL2rhaMjCbTAkJ8uJLBxAhoaIe', 'api_base', 'client_credentials', 'https://www.baidu.com', NULL, NULL, NULL, NULL, NULL);

请求参数

参数

具体值

备注

grant_type

client_credentials

授权类型

client_id

client2

数据库字段-client_id

client_secret

secret

数据库字段—客户端secret

scope

api_base

数据库字段

 

 

简化模式

 

浏览器请求GET模式,不要用postman
http://localhost:3000/oauth/authorize?client_id=client3&response_type=token&redirect_uri=https://www.baidu.com&state=fuce&scope=api_base

刷新模式(刷新token)

 

POST请求
http://localhost:3000/oauth/token

请求参数

参数

具体值

备注

grant_type

refresh_token

授权类型

client_id

client1

数据库字段-client_id

client_secret

secret

数据库字段—客户端secret

refresh_token

633b1feb-3cb9-4917-bba1-7da22b584dab

上次请求得refresh_token

 

 

 

数据库讲解

 

1、oauth_client_details

在项目中,主要操作oauth_client_details表的类是JdbcClientDetailsService.java, 更多的细节请参考该类.也可以根据实际的需要,去扩展或修改该类的实现.

client_id 主键,必须唯一,不能为空.
用于唯一标识每一个客户端(client); 在注册时必须填写(也可由服务端自动生成).
对于不同的grant_type,该字段都是必须的. 在实际应用中的另一个名称叫appKey,与client_id是同一个概念.
resource_ids

客户端所能访问的资源id集合,多个资源时用逗号(,)分隔,如: "unity-resource,mobile-resource".

可以根据上图知道,我们有Resource Server资源服务器。,资源服务器可以有多个,我们可以为每一个Resource Server(一个微服务实例)设置一个resourceid。

Authorization Server给client第三方客户端授权的时候,可以设置这个client可以访问哪一些Resource Server资源服务,如果没设置,就是对所有的Resource Server都有访问权限。

client_secret 用于指定客户端(client)的访问密匙; 在注册时必须填写(也可由服务端自动生成).
对于不同的grant_type,该字段都是必须的. 在实际应用中的另一个名称叫appSecret,与client_secret是同一个概念.
scope

指定客户端申请的权限范围,可选值包括read,write,trust;若有多个权限范围用逗号(,)分隔,如: "read,write".

@EnableGlobalMethodSecurity(prePostEnabled = true)启用方法级权限控制

然后在方法上注解标识@PreAuthorize("#oauth2.hasScope('read')")

authorized_grant_types 指定客户端支持的grant_type,可选值包括authorization_code,password,refresh_token,implicit,client_credentials, 若支持多个grant_type用逗号(,)分隔,如: "authorization_code,password".
在实际应用中,当注册时,该字段是一般由服务器端指定的,而不是由申请者去选择的,最常用的grant_type组合有: "authorization_code,refresh_token"(针对通过浏览器访问的客户端); "password,refresh_token"(针对移动设备的客户端).
implicitclient_credentials在实际中很少使用,可以根据自己的需要,在OAuth2.0 提供的地方进行扩展自定义的授权
web_server_redirect_uri 客户端的重定向URI,可为空, 当grant_type为authorization_codeimplicit时, 在Oauth的流程中会使用并检查与注册时填写的redirect_uri是否一致. 下面分别说明:
  • 当grant_type=authorization_code时, 第一步 从 spring-oauth-server获取 'code'时客户端发起请求时必须有redirect_uri参数, 该参数的值必须与 web_server_redirect_uri的值一致. 第二步 用 'code' 换取 'access_token' 时客户也必须传递相同的redirect_uri.
    在实际应用中, web_server_redirect_uri在注册时是必须填写的, 一般用来处理服务器返回的code, 验证state是否合法与通过code去换取access_token值.
    spring-oauth-client项目中, 可具体参考AuthorizationCodeController.java中的authorizationCodeCallback方法.
  • 当grant_type=implicit时通过redirect_uri的hash值来传递access_token值.如:
    • http://localhost:7777/spring-oauth-client/implicit#access_token=dc891f4a-ac88-4ba6-8224-a2497e013865&token_type=bearer&expires_in=43199
  • 然后客户端通过JS等从hash值中取到access_token值.
authorities

 @PreAuthorize("hasAuthority('admin')")可以在方法上标志 用户或者说client 需要说明样的权限

指定客户端所拥有的Spring Security的权限值,可选, 若有多个权限值,用逗号(,)分隔, 如: "ROLE_UNITY,ROLE_USER".

对于是否要设置该字段的值,要根据不同的grant_type来判断, 若客户端在Oauth流程中需要用户的用户名(username)与密码(password)的(authorization_code,password),

则该字段可以不需要设置值,因为服务端将根据用户在服务端所拥有的权限来判断是否有权限访问对应的API.

但如果客户端在Oauth流程中不需要用户信息的(implicit,client_credentials),

则该字段必须要设置对应的权限值, 因为服务端将根据该字段值的权限来判断是否有权限访问对应的API.

(请在spring-oauth-client项目中来测试不同grant_type时authorities的变化)

access_token_validity 设定客户端的access_token的有效时间值(单位:秒),可选, 若不设定值则使用默认的有效时间值(60 * 60 * 12, 12小时).
在服务端获取的access_token JSON数据中的expires_in字段的值即为当前access_token的有效时间值.
在项目中, 可具体参考DefaultTokenServices.java中属性accessTokenValiditySeconds.
在实际应用中, 该值一般是由服务端处理的, 不需要客户端自定义.
refresh_token_validity 设定客户端的refresh_token的有效时间值(单位:秒),可选, 若不设定值则使用默认的有效时间值(60 * 60 * 24 * 30, 30天).
若客户端的grant_type不包括refresh_token,则不用关心该字段 在项目中, 可具体参考DefaultTokenServices.java中属性refreshTokenValiditySeconds.
在实际应用中, 该值一般是由服务端处理的, 不需要客户端自定义.
additional_information 这是一个预留的字段,在Oauth的流程中没有实际的使用,可选,但若设置值,必须是JSON格式的数据,如:
{"country":"CN","country_code":"086"}
按照spring-security-oauth项目中对该字段的描述
Additional information for this client, not need by the vanilla OAuth protocol but might be useful, for example,for storing descriptive information.
(详见ClientDetails.javagetAdditionalInformation()方法的注释) 在实际应用中, 可以用该字段来存储关于客户端的一些其他信息,如客户端的国家,地区,注册时的IP地址等等.
create_time 数据的创建时间,精确到秒,由数据库在插入数据时取当前系统时间自动生成(扩展字段)
autoapprove 设置用户是否自动Approval操作, 默认值为 'false', 可选值包括 'true','false', 'read','write'.
该字段只适用于grant_type="authorization_code"的情况,当用户登录成功后,若该值为'true'或支持的scope值,则会跳过用户Approve的页面, 直接授权.

 

2、oauth_client_token

该表用于在客户端系统中存储从服务端获取的token数据, 在spring-oauth-server项目中未使用到. 对

oauth_client_token表的主要操作在JdbcClientTokenServices.java类中, 更多的细节请参考该类.

字段名 字段说明
create_time 数据的创建时间,精确到秒,由数据库在插入数据时取当前系统时间自动生成(扩展字段)
token_id 从服务器端获取到的access_token的值.
token 这是一个二进制的字段, 存储的数据是OAuth2AccessToken.java对象序列化后的二进
制数据.
authentication_id 该字段具有唯一性, 是根据当前的username(如果有),client_id与scope通过MD5加密
生成的. 具体实现请参考DefaultClientKeyGenerator.java类.
user_name 登录时的用户名
client_id  

 

 

 

 

3、oauth_access_token

字段名 字段说明
create_time 数据的创建时间,精确到秒,由数据库在插入数据时取当前系统时间自动生成(扩展字段)
token_id 该字段的值是将access_token的值通过MD5加密后存储的.
token 存储将OAuth2AccessToken.java对象序列化后的二进制数据, 是真实的AccessToken
的数据值.
authentication_id 该字段具有唯一性, 其值是根据当前的username(如果有),client_id与scope通过MD5
加密生成的. 具体实现请参考DefaultAuthenticationKeyGenerator.java类.
user_name 登录时的用户名, 若客户端没有用户名(如grant_type=“client_credentials”),则该值等
于client_id
client_id  
authentication 存储将OAuth2Authentication.java对象序列化后的二进制数据.
refresh_token 该字段的值是将refresh_token的值通过MD5加密后存储的. 在项目中,主要操作
oauth_access_token表的对象是JdbcTokenStore.java. 更多的细节请参考该类

 

4、oauth_refresh_token

在项目中,主要操作oauth_refresh_token表的对象是JdbcTokenStore.java. (与操作oauth_access_token表的对象

一样);更多的细节请参考该类. 如果客户端的grant_type不支持refresh_token,则不会使用该表.

字段名 字段说明
create_time 数据的创建时间,精确到秒,由数据库在插入数据时取当前系统时间自动生成(扩展字段)
token_id 该字段的值是将refresh_token的值通过MD5加密后存储的.
token 存储将OAuth2RefreshToken.java对象序列化后的二进制数据.
authentication 存储将OAuth2Authentication.java对象序列化后的二进制数据.

 

 

5、oauth_code

在项目中,主要操作oauth_code表的对象是JdbcAuthorizationCodeServices.java. 更多的细节请参考该类。 只有当

grant_type为"authorization_code"时,该表中才会有数据产生; 其他的grant_type没有使用该表。

 

字段名 字段说明
create_time 数据的创建时间,精确到秒,由数据库在插入数据时取当前系统时间自动生成(扩展字段)
code 存储服务端系统生成的code的值(未加密).
authentication 存储将AuthorizationRequestHolder.java对象序列化后的二进制数据.

 

 

 

 

其他

Oauth支持的5类 grant_type 字段及说明

参数

说明

 

authorization_code

授权码模式(即先登录获取code,再获取token)

grant_type=authorization_code

password

密码模式(将用户名,密码传过去,直接获取token)

grant_type=password

client_credentials

客户端模式(无用户,用户向客户端注册,然后客户端以自己的名义向’服务端’获取资源)

grant_type=client_credentials

implicit

简化模式(在redirect_uri 的Hash传递token; Auth客户端运行在浏览器中,如JS,Flash)

grant_type=implicit

refresh_token

刷新access_token

grant_type=refresh_token

 

 

 

 

 

附件

postman.json文件

v2-cloud.postman_collection.json

 

 

数据库

mysql的



SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for clientdetails
-- ----------------------------
DROP TABLE IF EXISTS `clientdetails`;
CREATE TABLE `clientdetails`  (
  `appId` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `resourceIds` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `appSecret` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `scope` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `grantTypes` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `redirectUrl` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `authorities` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `access_token_validity` int(11) NULL DEFAULT NULL,
  `refresh_token_validity` int(11) NULL DEFAULT NULL,
  `additionalInformation` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `autoApproveScopes` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`appId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oauth_access_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_token`;
CREATE TABLE `oauth_access_token`  (
  `token_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加密的access_token的值',
  `token` blob NULL COMMENT 'OAuth2AccessToken.java对象序列化后的二进制数据',
  `authentication_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '加密过的username,client_id,scope',
  `user_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录的用户名',
  `client_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端ID',
  `authentication` blob NULL COMMENT 'OAuth2Authentication.java对象序列化后的二进制数据',
  `refresh_token` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加密的refresh_token的值',
  PRIMARY KEY (`authentication_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '访问令牌' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oauth_access_token
-- ----------------------------
INSERT INTO `oauth_access_token` VALUES ('7ba6ed25489f7aebe215ef605d8d89dd', 0xACED0005737200436F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F4175746832416363657373546F6B656E0CB29E361B24FACE0200064C00156164646974696F6E616C496E666F726D6174696F6E74000F4C6A6176612F7574696C2F4D61703B4C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B4C000C72656672657368546F6B656E74003F4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F636F6D6D6F6E2F4F417574683252656672657368546F6B656E3B4C000573636F706574000F4C6A6176612F7574696C2F5365743B4C0009746F6B656E547970657400124C6A6176612F6C616E672F537472696E673B4C000576616C756571007E000578707372001E6A6176612E7574696C2E436F6C6C656374696F6E7324456D7074794D6170593614855ADCE7D002000078707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001762C37FD737870737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C0001637400164C6A6176612F7574696C2F436F6C6C656374696F6E3B7870737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F400000000000017400086170695F626173657874000662656172657274002435356536316662392D353766362D343230632D613231612D393733313039326662643038, '713af40adeea69c75190ed4458345239', NULL, 'client2', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000007704000000007871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B72656469726563745572697400124C6A6176612F6C616E672F537472696E673B4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E0011787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000F4C001172657175657374506172616D657465727371007E000E4C000573636F706571007E00117870740007636C69656E7432737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E000E7870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000067708000000080000000374000A6772616E745F74797065740012636C69656E745F63726564656E7469616C73740009636C69656E745F6964740007636C69656E743274000573636F70657400086170695F6261736578737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000171007E001E78017371007E0022770C000000103F40000000000000787371007E00173F40000000000000770800000010000000007870707371007E0022770C000000103F40000000000000787371007E0022770C000000103F400000000000007870, NULL);
INSERT INTO `oauth_access_token` VALUES ('1b1beaec969e031e0bf6cba81fc767fc', 0xACED0005737200436F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F4175746832416363657373546F6B656E0CB29E361B24FACE0200064C00156164646974696F6E616C496E666F726D6174696F6E74000F4C6A6176612F7574696C2F4D61703B4C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B4C000C72656672657368546F6B656E74003F4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F636F6D6D6F6E2F4F417574683252656672657368546F6B656E3B4C000573636F706574000F4C6A6176612F7574696C2F5365743B4C0009746F6B656E547970657400124C6A6176612F6C616E672F537472696E673B4C000576616C756571007E000578707372001E6A6176612E7574696C2E436F6C6C656374696F6E7324456D7074794D6170593614855ADCE7D002000078707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001762E6068A3787372004C6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744578706972696E674F417574683252656672657368546F6B656E2FDF47639DD0C9B70200014C000A65787069726174696F6E71007E0002787200446F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F417574683252656672657368546F6B656E73E10E0A6354D45E0200014C000576616C756571007E0005787074002436333362316665622D336362392D343931372D626261312D3764613232623538346461627371007E0009770800000176C8C62C6878737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C0001637400164C6A6176612F7574696C2F436F6C6C656374696F6E3B7870737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F400000000000017400036170707874000662656172657274002464666234316639342D613639392D343662332D613434382D623438336430633466303035, '8502edc3f4c61f1000b1932e6a3756f1', 'admin', 'client', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000061770400000061737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000002120200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B7870740001237371007E000D7400022D2D7371007E000D74000F67656E3A737973417265613A6164647371007E000D74001067656E3A737973417265613A656469747371007E000D74001067656E3A737973417265613A6C6973747371007E000D74001267656E3A737973417265613A72656D6F76657371007E000D74001067656E3A737973417265613A766965777371007E000D74000F67656E3A737973436974793A6164647371007E000D74001067656E3A737973436974793A656469747371007E000D74001067656E3A737973436974793A6C6973747371007E000D74001267656E3A737973436974793A72656D6F76657371007E000D74001067656E3A737973436974793A766965777371007E000D74001567656E3A7379734465706172746D656E743A6164647371007E000D74001667656E3A7379734465706172746D656E743A656469747371007E000D74001667656E3A7379734465706172746D656E743A6C6973747371007E000D74001867656E3A7379734465706172746D656E743A72656D6F76657371007E000D74001667656E3A7379734465706172746D656E743A766965777371007E000D74001367656E3A737973496E74657255726C3A6164647371007E000D74001467656E3A737973496E74657255726C3A656469747371007E000D74001467656E3A737973496E74657255726C3A6C6973747371007E000D74001667656E3A737973496E74657255726C3A72656D6F76657371007E000D74001467656E3A737973496E74657255726C3A766965777371007E000D74001167656E3A7379734E6F746963653A6164647371007E000D74001267656E3A7379734E6F746963653A656469747371007E000D74001267656E3A7379734E6F746963653A6C6973747371007E000D74001467656E3A7379734E6F746963653A72656D6F76657371007E000D74001267656E3A7379734E6F746963653A766965777371007E000D74001367656E3A737973506F736974696F6E3A6164647371007E000D74001467656E3A737973506F736974696F6E3A656469747371007E000D74001467656E3A737973506F736974696F6E3A6C6973747371007E000D74001667656E3A737973506F736974696F6E3A72656D6F76657371007E000D74001467656E3A737973506F736974696F6E3A766965777371007E000D74001367656E3A73797350726F76696E63653A6164647371007E000D74001467656E3A73797350726F76696E63653A656469747371007E000D74001467656E3A73797350726F76696E63653A6C6973747371007E000D74001667656E3A73797350726F76696E63653A72656D6F76657371007E000D74001467656E3A73797350726F76696E63653A766965777371007E000D74001467656E3A73797351756172747A4A6F623A6164647371007E000D74001567656E3A73797351756172747A4A6F623A656469747371007E000D74001567656E3A73797351756172747A4A6F623A6C6973747371007E000D74001767656E3A73797351756172747A4A6F623A72656D6F76657371007E000D74001567656E3A73797351756172747A4A6F623A766965777371007E000D74001867656E3A73797351756172747A4A6F624C6F673A6C6973747371007E000D74001A67656E3A73797351756172747A4A6F624C6F673A72656D6F76657371007E000D74001867656E3A73797351756172747A4A6F624C6F673A766965777371007E000D74001167656E3A7379735374726565743A6164647371007E000D74001267656E3A7379735374726565743A656469747371007E000D74001267656E3A7379735374726565743A6C6973747371007E000D74001467656E3A7379735374726565743A72656D6F76657371007E000D74001267656E3A7379735374726565743A766965777371007E000D74001673797374656D3A6175746F636F64653A676C6F62616C7371007E000D74001373797374656D3A6175746F636F64653A6F6E657371007E000D74001373797374656D3A64696374446174613A6164647371007E000D74001473797374656D3A64696374446174613A656469747371007E000D74001473797374656D3A64696374446174613A6C6973747371007E000D74001673797374656D3A64696374446174613A72656D6F76657371007E000D74001473797374656D3A64696374446174613A766965777371007E000D74001373797374656D3A64696374547970653A6164647371007E000D74001473797374656D3A64696374547970653A656469747371007E000D74001473797374656D3A64696374547970653A6C6973747371007E000D74001673797374656D3A64696374547970653A72656D6F76657371007E000D74001473797374656D3A64696374547970653A766965777371007E000D74001073797374656D3A656D61696C3A6164647371007E000D74001173797374656D3A656D61696C3A656469747371007E000D74001173797374656D3A656D61696C3A6C6973747371007E000D74001373797374656D3A656D61696C3A72656D6F76657371007E000D74001173797374656D3A656D61696C3A766965777371007E000D74000F73797374656D3A66696C653A6164647371007E000D74001073797374656D3A66696C653A656469747371007E000D74001073797374656D3A66696C653A6C6973747371007E000D74001273797374656D3A66696C653A72656D6F76657371007E000D74001073797374656D3A66696C653A766965777371007E000D74001073797374656D3A68746D623A766965777371007E000D74000F73797374656D3A6C6F673A6C6973747371007E000D74001173797374656D3A6C6F673A72656D6F76657371007E000D74000F73797374656D3A6C6F673A766965777371007E000D74001573797374656D3A7065726D697373696F6E3A6164647371007E000D74001673797374656D3A7065726D697373696F6E3A656469747371007E000D74001673797374656D3A7065726D697373696F6E3A6C6973747371007E000D74001873797374656D3A7065726D697373696F6E3A72656D6F76657371007E000D74001673797374656D3A7065726D697373696F6E3A766965777371007E000D74001673797374656D3A71694E6975436C6F75643A6C6973747371007E000D74001673797374656D3A71694E6975436C6F75643A766965777371007E000D74000F73797374656D3A726F6C653A6164647371007E000D74001073797374656D3A726F6C653A656469747371007E000D74001073797374656D3A726F6C653A6C6973747371007E000D74001273797374656D3A726F6C653A72656D6F76657371007E000D74001073797374656D3A726F6C653A766965777371007E000D74001373797374656D3A736572766963653A766965777371007E000D74001073797374656D3A746F6F6C3A766965777371007E000D74000F73797374656D3A757365723A6164647371007E000D74001073797374656D3A757365723A656469747371007E000D74001373797374656D3A757365723A656469745077647371007E000D74001073797374656D3A757365723A6C6973747371007E000D74001273797374656D3A757365723A72656D6F76657371007E000D74001073797374656D3A757365723A766965777371007E000D740009757365723A6C6973747871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E00D4787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E00D24C000573636F706571007E00D47870740006636C69656E74737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E00D27870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000008740004636F646574000634364D79704B74000A6772616E745F74797065740012617574686F72697A6174696F6E5F636F646574000573636F706574000361707074000D726573706F6E73655F74797065740004636F646574000C72656469726563745F75726974001568747470733A2F2F7777772E62616964752E636F6D74000573746174657400046675636574000D636C69656E745F736563726574740006736563726574740009636C69656E745F6964740006636C69656E7478737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000171007E00E178017371007E00EF770C000000103F40000000000000787371007E00DA3F40000000000000770800000010000000007874001568747470733A2F2F7777772E62616964752E636F6D707371007E00EF770C000000103F40000000000000787371007E00EF770C000000103F4000000000000171007E00E3787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000002120200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000006177040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF7871007E00F9737200486F72672E737072696E676672616D65776F726B2E73656375726974792E7765622E61757468656E7469636174696F6E2E57656241757468656E7469636174696F6E44657461696C7300000000000002120200024C000D72656D6F74654164647265737371007E000E4C000973657373696F6E496471007E000E787074000F303A303A303A303A303A303A303A31740020333846444537464339303835323846363530414541374333414239463434303470737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000002120200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E00D44C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E00EC737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F720000000000000212020000787077040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF787074000561646D696E, '73defdb7d7ccb37f58bebddf5075e471');
INSERT INTO `oauth_access_token` VALUES ('922dd1a744d1a19896d44aeb4920e651', 0xACED0005737200436F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F4175746832416363657373546F6B656E0CB29E361B24FACE0200064C00156164646974696F6E616C496E666F726D6174696F6E74000F4C6A6176612F7574696C2F4D61703B4C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B4C000C72656672657368546F6B656E74003F4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F636F6D6D6F6E2F4F417574683252656672657368546F6B656E3B4C000573636F706574000F4C6A6176612F7574696C2F5365743B4C0009746F6B656E547970657400124C6A6176612F6C616E672F537472696E673B4C000576616C756571007E000578707372001E6A6176612E7574696C2E436F6C6C656374696F6E7324456D7074794D6170593614855ADCE7D002000078707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001762C2FA9237870737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C0001637400164C6A6176612F7574696C2F436F6C6C656374696F6E3B7870737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000023F400000000000017400036170707874000662656172657274002438623335643165312D366237322D343131652D383339332D656639613436343262306339, 'a3463e5ba065ea3c94b12a4ae00bedfb', 'admin', 'client1', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000061770400000061737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000002120200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B7870740001237371007E000D7400022D2D7371007E000D74000F67656E3A737973417265613A6164647371007E000D74001067656E3A737973417265613A656469747371007E000D74001067656E3A737973417265613A6C6973747371007E000D74001267656E3A737973417265613A72656D6F76657371007E000D74001067656E3A737973417265613A766965777371007E000D74000F67656E3A737973436974793A6164647371007E000D74001067656E3A737973436974793A656469747371007E000D74001067656E3A737973436974793A6C6973747371007E000D74001267656E3A737973436974793A72656D6F76657371007E000D74001067656E3A737973436974793A766965777371007E000D74001567656E3A7379734465706172746D656E743A6164647371007E000D74001667656E3A7379734465706172746D656E743A656469747371007E000D74001667656E3A7379734465706172746D656E743A6C6973747371007E000D74001867656E3A7379734465706172746D656E743A72656D6F76657371007E000D74001667656E3A7379734465706172746D656E743A766965777371007E000D74001367656E3A737973496E74657255726C3A6164647371007E000D74001467656E3A737973496E74657255726C3A656469747371007E000D74001467656E3A737973496E74657255726C3A6C6973747371007E000D74001667656E3A737973496E74657255726C3A72656D6F76657371007E000D74001467656E3A737973496E74657255726C3A766965777371007E000D74001167656E3A7379734E6F746963653A6164647371007E000D74001267656E3A7379734E6F746963653A656469747371007E000D74001267656E3A7379734E6F746963653A6C6973747371007E000D74001467656E3A7379734E6F746963653A72656D6F76657371007E000D74001267656E3A7379734E6F746963653A766965777371007E000D74001367656E3A737973506F736974696F6E3A6164647371007E000D74001467656E3A737973506F736974696F6E3A656469747371007E000D74001467656E3A737973506F736974696F6E3A6C6973747371007E000D74001667656E3A737973506F736974696F6E3A72656D6F76657371007E000D74001467656E3A737973506F736974696F6E3A766965777371007E000D74001367656E3A73797350726F76696E63653A6164647371007E000D74001467656E3A73797350726F76696E63653A656469747371007E000D74001467656E3A73797350726F76696E63653A6C6973747371007E000D74001667656E3A73797350726F76696E63653A72656D6F76657371007E000D74001467656E3A73797350726F76696E63653A766965777371007E000D74001467656E3A73797351756172747A4A6F623A6164647371007E000D74001567656E3A73797351756172747A4A6F623A656469747371007E000D74001567656E3A73797351756172747A4A6F623A6C6973747371007E000D74001767656E3A73797351756172747A4A6F623A72656D6F76657371007E000D74001567656E3A73797351756172747A4A6F623A766965777371007E000D74001867656E3A73797351756172747A4A6F624C6F673A6C6973747371007E000D74001A67656E3A73797351756172747A4A6F624C6F673A72656D6F76657371007E000D74001867656E3A73797351756172747A4A6F624C6F673A766965777371007E000D74001167656E3A7379735374726565743A6164647371007E000D74001267656E3A7379735374726565743A656469747371007E000D74001267656E3A7379735374726565743A6C6973747371007E000D74001467656E3A7379735374726565743A72656D6F76657371007E000D74001267656E3A7379735374726565743A766965777371007E000D74001673797374656D3A6175746F636F64653A676C6F62616C7371007E000D74001373797374656D3A6175746F636F64653A6F6E657371007E000D74001373797374656D3A64696374446174613A6164647371007E000D74001473797374656D3A64696374446174613A656469747371007E000D74001473797374656D3A64696374446174613A6C6973747371007E000D74001673797374656D3A64696374446174613A72656D6F76657371007E000D74001473797374656D3A64696374446174613A766965777371007E000D74001373797374656D3A64696374547970653A6164647371007E000D74001473797374656D3A64696374547970653A656469747371007E000D74001473797374656D3A64696374547970653A6C6973747371007E000D74001673797374656D3A64696374547970653A72656D6F76657371007E000D74001473797374656D3A64696374547970653A766965777371007E000D74001073797374656D3A656D61696C3A6164647371007E000D74001173797374656D3A656D61696C3A656469747371007E000D74001173797374656D3A656D61696C3A6C6973747371007E000D74001373797374656D3A656D61696C3A72656D6F76657371007E000D74001173797374656D3A656D61696C3A766965777371007E000D74000F73797374656D3A66696C653A6164647371007E000D74001073797374656D3A66696C653A656469747371007E000D74001073797374656D3A66696C653A6C6973747371007E000D74001273797374656D3A66696C653A72656D6F76657371007E000D74001073797374656D3A66696C653A766965777371007E000D74001073797374656D3A68746D623A766965777371007E000D74000F73797374656D3A6C6F673A6C6973747371007E000D74001173797374656D3A6C6F673A72656D6F76657371007E000D74000F73797374656D3A6C6F673A766965777371007E000D74001573797374656D3A7065726D697373696F6E3A6164647371007E000D74001673797374656D3A7065726D697373696F6E3A656469747371007E000D74001673797374656D3A7065726D697373696F6E3A6C6973747371007E000D74001873797374656D3A7065726D697373696F6E3A72656D6F76657371007E000D74001673797374656D3A7065726D697373696F6E3A766965777371007E000D74001673797374656D3A71694E6975436C6F75643A6C6973747371007E000D74001673797374656D3A71694E6975436C6F75643A766965777371007E000D74000F73797374656D3A726F6C653A6164647371007E000D74001073797374656D3A726F6C653A656469747371007E000D74001073797374656D3A726F6C653A6C6973747371007E000D74001273797374656D3A726F6C653A72656D6F76657371007E000D74001073797374656D3A726F6C653A766965777371007E000D74001373797374656D3A736572766963653A766965777371007E000D74001073797374656D3A746F6F6C3A766965777371007E000D74000F73797374656D3A757365723A6164647371007E000D74001073797374656D3A757365723A656469747371007E000D74001373797374656D3A757365723A656469745077647371007E000D74001073797374656D3A757365723A6C6973747371007E000D74001273797374656D3A757365723A72656D6F76657371007E000D74001073797374656D3A757365723A766965777371007E000D740009757365723A6C6973747871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E00D4787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E00D24C000573636F706571007E00D47870740007636C69656E7431737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E00D27870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000067708000000080000000474000A6772616E745F7479706574000870617373776F7264740009636C69656E745F6964740007636C69656E743174000573636F7065740003617070740008757365726E616D6574000561646D696E78737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000171007E00E178017371007E00E7770C000000103F40000000000000787371007E00DA3F40000000000000770800000010000000007870707371007E00E7770C000000103F40000000000000787371007E00E7770C000000103F40000000000000787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000002120200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000006177040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF7871007E00F0737200176A6176612E7574696C2E4C696E6B6564486173684D617034C04E5C106CC0FB0200015A000B6163636573734F726465727871007E00DA3F4000000000000C7708000000100000000571007E00DC71007E00DD71007E00E071007E00E174000D636C69656E745F73656372657474000673656372657471007E00DE71007E00DF71007E00E271007E00E3780070737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000002120200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E00D44C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E00E4737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F720000000000000212020000787077040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF787074000561646D696E, NULL);
INSERT INTO `oauth_access_token` VALUES ('ae60b37a4c3774b33b7a811b49ae6be8', 0xACED0005737200436F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F4175746832416363657373546F6B656E0CB29E361B24FACE0200064C00156164646974696F6E616C496E666F726D6174696F6E74000F4C6A6176612F7574696C2F4D61703B4C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B4C000C72656672657368546F6B656E74003F4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F636F6D6D6F6E2F4F417574683252656672657368546F6B656E3B4C000573636F706574000F4C6A6176612F7574696C2F5365743B4C0009746F6B656E547970657400124C6A6176612F6C616E672F537472696E673B4C000576616C756571007E000578707372001E6A6176612E7574696C2E436F6C6C656374696F6E7324456D7074794D6170593614855ADCE7D002000078707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001762C3EB28C7870737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C0001637400164C6A6176612F7574696C2F436F6C6C656374696F6E3B7870737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000023F400000000000017400086170695F626173657874000662656172657274002438333765626265622D376363342D343036332D383831612D643233333763316133376566, 'a51b44559a99754939a882d7c7055f41', 'admin', 'client3', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000061770400000061737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000002120200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B7870740001237371007E000D7400022D2D7371007E000D74000F67656E3A737973417265613A6164647371007E000D74001067656E3A737973417265613A656469747371007E000D74001067656E3A737973417265613A6C6973747371007E000D74001267656E3A737973417265613A72656D6F76657371007E000D74001067656E3A737973417265613A766965777371007E000D74000F67656E3A737973436974793A6164647371007E000D74001067656E3A737973436974793A656469747371007E000D74001067656E3A737973436974793A6C6973747371007E000D74001267656E3A737973436974793A72656D6F76657371007E000D74001067656E3A737973436974793A766965777371007E000D74001567656E3A7379734465706172746D656E743A6164647371007E000D74001667656E3A7379734465706172746D656E743A656469747371007E000D74001667656E3A7379734465706172746D656E743A6C6973747371007E000D74001867656E3A7379734465706172746D656E743A72656D6F76657371007E000D74001667656E3A7379734465706172746D656E743A766965777371007E000D74001367656E3A737973496E74657255726C3A6164647371007E000D74001467656E3A737973496E74657255726C3A656469747371007E000D74001467656E3A737973496E74657255726C3A6C6973747371007E000D74001667656E3A737973496E74657255726C3A72656D6F76657371007E000D74001467656E3A737973496E74657255726C3A766965777371007E000D74001167656E3A7379734E6F746963653A6164647371007E000D74001267656E3A7379734E6F746963653A656469747371007E000D74001267656E3A7379734E6F746963653A6C6973747371007E000D74001467656E3A7379734E6F746963653A72656D6F76657371007E000D74001267656E3A7379734E6F746963653A766965777371007E000D74001367656E3A737973506F736974696F6E3A6164647371007E000D74001467656E3A737973506F736974696F6E3A656469747371007E000D74001467656E3A737973506F736974696F6E3A6C6973747371007E000D74001667656E3A737973506F736974696F6E3A72656D6F76657371007E000D74001467656E3A737973506F736974696F6E3A766965777371007E000D74001367656E3A73797350726F76696E63653A6164647371007E000D74001467656E3A73797350726F76696E63653A656469747371007E000D74001467656E3A73797350726F76696E63653A6C6973747371007E000D74001667656E3A73797350726F76696E63653A72656D6F76657371007E000D74001467656E3A73797350726F76696E63653A766965777371007E000D74001467656E3A73797351756172747A4A6F623A6164647371007E000D74001567656E3A73797351756172747A4A6F623A656469747371007E000D74001567656E3A73797351756172747A4A6F623A6C6973747371007E000D74001767656E3A73797351756172747A4A6F623A72656D6F76657371007E000D74001567656E3A73797351756172747A4A6F623A766965777371007E000D74001867656E3A73797351756172747A4A6F624C6F673A6C6973747371007E000D74001A67656E3A73797351756172747A4A6F624C6F673A72656D6F76657371007E000D74001867656E3A73797351756172747A4A6F624C6F673A766965777371007E000D74001167656E3A7379735374726565743A6164647371007E000D74001267656E3A7379735374726565743A656469747371007E000D74001267656E3A7379735374726565743A6C6973747371007E000D74001467656E3A7379735374726565743A72656D6F76657371007E000D74001267656E3A7379735374726565743A766965777371007E000D74001673797374656D3A6175746F636F64653A676C6F62616C7371007E000D74001373797374656D3A6175746F636F64653A6F6E657371007E000D74001373797374656D3A64696374446174613A6164647371007E000D74001473797374656D3A64696374446174613A656469747371007E000D74001473797374656D3A64696374446174613A6C6973747371007E000D74001673797374656D3A64696374446174613A72656D6F76657371007E000D74001473797374656D3A64696374446174613A766965777371007E000D74001373797374656D3A64696374547970653A6164647371007E000D74001473797374656D3A64696374547970653A656469747371007E000D74001473797374656D3A64696374547970653A6C6973747371007E000D74001673797374656D3A64696374547970653A72656D6F76657371007E000D74001473797374656D3A64696374547970653A766965777371007E000D74001073797374656D3A656D61696C3A6164647371007E000D74001173797374656D3A656D61696C3A656469747371007E000D74001173797374656D3A656D61696C3A6C6973747371007E000D74001373797374656D3A656D61696C3A72656D6F76657371007E000D74001173797374656D3A656D61696C3A766965777371007E000D74000F73797374656D3A66696C653A6164647371007E000D74001073797374656D3A66696C653A656469747371007E000D74001073797374656D3A66696C653A6C6973747371007E000D74001273797374656D3A66696C653A72656D6F76657371007E000D74001073797374656D3A66696C653A766965777371007E000D74001073797374656D3A68746D623A766965777371007E000D74000F73797374656D3A6C6F673A6C6973747371007E000D74001173797374656D3A6C6F673A72656D6F76657371007E000D74000F73797374656D3A6C6F673A766965777371007E000D74001573797374656D3A7065726D697373696F6E3A6164647371007E000D74001673797374656D3A7065726D697373696F6E3A656469747371007E000D74001673797374656D3A7065726D697373696F6E3A6C6973747371007E000D74001873797374656D3A7065726D697373696F6E3A72656D6F76657371007E000D74001673797374656D3A7065726D697373696F6E3A766965777371007E000D74001673797374656D3A71694E6975436C6F75643A6C6973747371007E000D74001673797374656D3A71694E6975436C6F75643A766965777371007E000D74000F73797374656D3A726F6C653A6164647371007E000D74001073797374656D3A726F6C653A656469747371007E000D74001073797374656D3A726F6C653A6C6973747371007E000D74001273797374656D3A726F6C653A72656D6F76657371007E000D74001073797374656D3A726F6C653A766965777371007E000D74001373797374656D3A736572766963653A766965777371007E000D74001073797374656D3A746F6F6C3A766965777371007E000D74000F73797374656D3A757365723A6164647371007E000D74001073797374656D3A757365723A656469747371007E000D74001373797374656D3A757365723A656469745077647371007E000D74001073797374656D3A757365723A6C6973747371007E000D74001273797374656D3A757365723A72656D6F76657371007E000D74001073797374656D3A757365723A766965777371007E000D740009757365723A6C6973747871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E00D4787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E00D24C000573636F706571007E00D47870740007636C69656E7433737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E00D27870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000067708000000080000000574000D726573706F6E73655F74797065740005746F6B656E74000C72656469726563745F75726974001568747470733A2F2F7777772E66756E746C2E636F6D740005737461746574000466756365740009636C69656E745F696471007E00D774000573636F70657400086170695F6261736578737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F400000000000017400086170695F6261736578017371007E00E8770C000000103F40000000000000787371007E00DA3F40000000000000770800000010000000007874001568747470733A2F2F7777772E66756E746C2E636F6D707371007E00E8770C000000103F40000000000000787371007E00E8770C000000103F4000000000000171007E00DD787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000002120200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000006177040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF7871007E00F3737200486F72672E737072696E676672616D65776F726B2E73656375726974792E7765622E61757468656E7469636174696F6E2E57656241757468656E7469636174696F6E44657461696C7300000000000002120200024C000D72656D6F74654164647265737371007E000E4C000973657373696F6E496471007E000E787074000F303A303A303A303A303A303A303A31740020463436324431443631464644323846334643334141303630363444433138363470737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000002120200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E00D44C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E00E5737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F720000000000000212020000787077040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF787074000561646D696E, NULL);

-- ----------------------------
-- Table structure for oauth_approvals
-- ----------------------------
DROP TABLE IF EXISTS `oauth_approvals`;
CREATE TABLE `oauth_approvals`  (
  `userId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录的用户名',
  `clientId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端ID',
  `scope` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '申请的权限范围',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态(Approve或Deny)',
  `expiresAt` timestamp(0) NULL DEFAULT NULL COMMENT '过期时间',
  `lastModifiedAt` timestamp(0) NULL DEFAULT NULL COMMENT '最终修改时间'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '授权记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_details`;
CREATE TABLE `oauth_client_details`  (
  `client_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户端ID',
  `resource_ids` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源ID集合,多个资源时用逗号(,)分隔',
  `client_secret` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端密匙',
  `scope` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端申请的权限范围',
  `authorized_grant_types` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端支持的grant_type',
  `web_server_redirect_uri` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '重定向URI',
  `authorities` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端所拥有的Spring Security的权限值,多个用逗号(,)分隔',
  `access_token_validity` int(11) NULL DEFAULT NULL COMMENT '访问令牌有效时间值(单位:秒)默认(60 * 60 * 12,12小时)',
  `refresh_token_validity` int(11) NULL DEFAULT NULL COMMENT '更新令牌有效时间值(单位:秒)默认(60 *60 * 24 * 30, 30天)',
  `additional_information` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '预留字段',
  `autoapprove` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户是否自动Approval操作',
  PRIMARY KEY (`client_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户端信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oauth_client_details
-- ----------------------------
INSERT INTO `oauth_client_details` VALUES ('client', NULL, '$2a$10$fRoGVj/GImYu26ZLUYJd6O3tWfnZL2rhaMjCbTAkJ8uJLBxAhoaIe', 'app', 'authorization_code,refresh_token', 'https://www.baidu.com', NULL, 60, NULL, NULL, NULL);
INSERT INTO `oauth_client_details` VALUES ('client1', NULL, '$2a$10$fRoGVj/GImYu26ZLUYJd6O3tWfnZL2rhaMjCbTAkJ8uJLBxAhoaIe', 'app', 'password,refresh_token', 'https://www.baidu.com', NULL, 60, NULL, NULL, NULL);
INSERT INTO `oauth_client_details` VALUES ('client2', NULL, '$2a$10$fRoGVj/GImYu26ZLUYJd6O3tWfnZL2rhaMjCbTAkJ8uJLBxAhoaIe', 'api_base', 'client_credentials,refresh_token', 'https://www.baidu.com', NULL, 60, NULL, NULL, NULL);
INSERT INTO `oauth_client_details` VALUES ('client3', NULL, '$2a$10$fRoGVj/GImYu26ZLUYJd6O3tWfnZL2rhaMjCbTAkJ8uJLBxAhoaIe', 'api_base', 'implicit,refresh_token', 'https://www.baidu.com', NULL, 60, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for oauth_client_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_client_token`;
CREATE TABLE `oauth_client_token`  (
  `token_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加密的access_token值',
  `token` blob NULL COMMENT 'OAuth2AccessToken.java对象序列化后的二进制数据',
  `authentication_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '加密过的username,client_id,scope',
  `user_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录的用户名',
  `client_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端ID',
  PRIMARY KEY (`authentication_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户端用来记录token信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oauth_code
-- ----------------------------
DROP TABLE IF EXISTS `oauth_code`;
CREATE TABLE `oauth_code`  (
  `code` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权码(未加密)',
  `authentication` blob NULL COMMENT 'AuthorizationRequestHolder.java对象序列化后的二进制数据'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '授权码' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for oauth_refresh_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_refresh_token`;
CREATE TABLE `oauth_refresh_token`  (
  `token_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加密过的refresh_token的值',
  `token` blob NULL COMMENT 'OAuth2RefreshToken.java对象序列化后的二进制数据',
  `authentication` blob NULL COMMENT 'OAuth2Authentication.java对象序列化后的二进制数据'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '更新令牌' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oauth_refresh_token
-- ----------------------------
INSERT INTO `oauth_refresh_token` VALUES ('73defdb7d7ccb37f58bebddf5075e471', 0xACED00057372004C6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744578706972696E674F417574683252656672657368546F6B656E2FDF47639DD0C9B70200014C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B787200446F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F417574683252656672657368546F6B656E73E10E0A6354D45E0200014C000576616C75657400124C6A6176612F6C616E672F537472696E673B787074002436333362316665622D336362392D343931372D626261312D3764613232623538346461627372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000176C8C62C6878, 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000061770400000061737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000002120200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B7870740001237371007E000D7400022D2D7371007E000D74000F67656E3A737973417265613A6164647371007E000D74001067656E3A737973417265613A656469747371007E000D74001067656E3A737973417265613A6C6973747371007E000D74001267656E3A737973417265613A72656D6F76657371007E000D74001067656E3A737973417265613A766965777371007E000D74000F67656E3A737973436974793A6164647371007E000D74001067656E3A737973436974793A656469747371007E000D74001067656E3A737973436974793A6C6973747371007E000D74001267656E3A737973436974793A72656D6F76657371007E000D74001067656E3A737973436974793A766965777371007E000D74001567656E3A7379734465706172746D656E743A6164647371007E000D74001667656E3A7379734465706172746D656E743A656469747371007E000D74001667656E3A7379734465706172746D656E743A6C6973747371007E000D74001867656E3A7379734465706172746D656E743A72656D6F76657371007E000D74001667656E3A7379734465706172746D656E743A766965777371007E000D74001367656E3A737973496E74657255726C3A6164647371007E000D74001467656E3A737973496E74657255726C3A656469747371007E000D74001467656E3A737973496E74657255726C3A6C6973747371007E000D74001667656E3A737973496E74657255726C3A72656D6F76657371007E000D74001467656E3A737973496E74657255726C3A766965777371007E000D74001167656E3A7379734E6F746963653A6164647371007E000D74001267656E3A7379734E6F746963653A656469747371007E000D74001267656E3A7379734E6F746963653A6C6973747371007E000D74001467656E3A7379734E6F746963653A72656D6F76657371007E000D74001267656E3A7379734E6F746963653A766965777371007E000D74001367656E3A737973506F736974696F6E3A6164647371007E000D74001467656E3A737973506F736974696F6E3A656469747371007E000D74001467656E3A737973506F736974696F6E3A6C6973747371007E000D74001667656E3A737973506F736974696F6E3A72656D6F76657371007E000D74001467656E3A737973506F736974696F6E3A766965777371007E000D74001367656E3A73797350726F76696E63653A6164647371007E000D74001467656E3A73797350726F76696E63653A656469747371007E000D74001467656E3A73797350726F76696E63653A6C6973747371007E000D74001667656E3A73797350726F76696E63653A72656D6F76657371007E000D74001467656E3A73797350726F76696E63653A766965777371007E000D74001467656E3A73797351756172747A4A6F623A6164647371007E000D74001567656E3A73797351756172747A4A6F623A656469747371007E000D74001567656E3A73797351756172747A4A6F623A6C6973747371007E000D74001767656E3A73797351756172747A4A6F623A72656D6F76657371007E000D74001567656E3A73797351756172747A4A6F623A766965777371007E000D74001867656E3A73797351756172747A4A6F624C6F673A6C6973747371007E000D74001A67656E3A73797351756172747A4A6F624C6F673A72656D6F76657371007E000D74001867656E3A73797351756172747A4A6F624C6F673A766965777371007E000D74001167656E3A7379735374726565743A6164647371007E000D74001267656E3A7379735374726565743A656469747371007E000D74001267656E3A7379735374726565743A6C6973747371007E000D74001467656E3A7379735374726565743A72656D6F76657371007E000D74001267656E3A7379735374726565743A766965777371007E000D74001673797374656D3A6175746F636F64653A676C6F62616C7371007E000D74001373797374656D3A6175746F636F64653A6F6E657371007E000D74001373797374656D3A64696374446174613A6164647371007E000D74001473797374656D3A64696374446174613A656469747371007E000D74001473797374656D3A64696374446174613A6C6973747371007E000D74001673797374656D3A64696374446174613A72656D6F76657371007E000D74001473797374656D3A64696374446174613A766965777371007E000D74001373797374656D3A64696374547970653A6164647371007E000D74001473797374656D3A64696374547970653A656469747371007E000D74001473797374656D3A64696374547970653A6C6973747371007E000D74001673797374656D3A64696374547970653A72656D6F76657371007E000D74001473797374656D3A64696374547970653A766965777371007E000D74001073797374656D3A656D61696C3A6164647371007E000D74001173797374656D3A656D61696C3A656469747371007E000D74001173797374656D3A656D61696C3A6C6973747371007E000D74001373797374656D3A656D61696C3A72656D6F76657371007E000D74001173797374656D3A656D61696C3A766965777371007E000D74000F73797374656D3A66696C653A6164647371007E000D74001073797374656D3A66696C653A656469747371007E000D74001073797374656D3A66696C653A6C6973747371007E000D74001273797374656D3A66696C653A72656D6F76657371007E000D74001073797374656D3A66696C653A766965777371007E000D74001073797374656D3A68746D623A766965777371007E000D74000F73797374656D3A6C6F673A6C6973747371007E000D74001173797374656D3A6C6F673A72656D6F76657371007E000D74000F73797374656D3A6C6F673A766965777371007E000D74001573797374656D3A7065726D697373696F6E3A6164647371007E000D74001673797374656D3A7065726D697373696F6E3A656469747371007E000D74001673797374656D3A7065726D697373696F6E3A6C6973747371007E000D74001873797374656D3A7065726D697373696F6E3A72656D6F76657371007E000D74001673797374656D3A7065726D697373696F6E3A766965777371007E000D74001673797374656D3A71694E6975436C6F75643A6C6973747371007E000D74001673797374656D3A71694E6975436C6F75643A766965777371007E000D74000F73797374656D3A726F6C653A6164647371007E000D74001073797374656D3A726F6C653A656469747371007E000D74001073797374656D3A726F6C653A6C6973747371007E000D74001273797374656D3A726F6C653A72656D6F76657371007E000D74001073797374656D3A726F6C653A766965777371007E000D74001373797374656D3A736572766963653A766965777371007E000D74001073797374656D3A746F6F6C3A766965777371007E000D74000F73797374656D3A757365723A6164647371007E000D74001073797374656D3A757365723A656469747371007E000D74001373797374656D3A757365723A656469745077647371007E000D74001073797374656D3A757365723A6C6973747371007E000D74001273797374656D3A757365723A72656D6F76657371007E000D74001073797374656D3A757365723A766965777371007E000D740009757365723A6C6973747871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E00D4787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E00D24C000573636F706571007E00D47870740006636C69656E74737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E00D27870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C77080000001000000008740004636F646574000634364D79704B74000A6772616E745F74797065740012617574686F72697A6174696F6E5F636F646574000573636F706574000361707074000D726573706F6E73655F74797065740004636F646574000C72656469726563745F75726974001568747470733A2F2F7777772E62616964752E636F6D74000573746174657400046675636574000D636C69656E745F736563726574740006736563726574740009636C69656E745F6964740006636C69656E7478737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000171007E00E178017371007E00EF770C000000103F40000000000000787371007E00DA3F40000000000000770800000010000000007874001568747470733A2F2F7777772E62616964752E636F6D707371007E00EF770C000000103F40000000000000787371007E00EF770C000000103F4000000000000171007E00E3787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000002120200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000006177040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF7871007E00F9737200486F72672E737072696E676672616D65776F726B2E73656375726974792E7765622E61757468656E7469636174696F6E2E57656241757468656E7469636174696F6E44657461696C7300000000000002120200024C000D72656D6F74654164647265737371007E000E4C000973657373696F6E496471007E000E787074000F303A303A303A303A303A303A303A31740020333846444537464339303835323846363530414541374333414239463434303470737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000002120200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E00D44C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E00EC737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F720000000000000212020000787077040000006171007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E002371007E002571007E002771007E002971007E002B71007E002D71007E002F71007E003171007E003371007E003571007E003771007E003971007E003B71007E003D71007E003F71007E004171007E004371007E004571007E004771007E004971007E004B71007E004D71007E004F71007E005171007E005371007E005571007E005771007E005971007E005B71007E005D71007E005F71007E006171007E006371007E006571007E006771007E006971007E006B71007E006D71007E006F71007E007171007E007371007E007571007E007771007E007971007E007B71007E007D71007E007F71007E008171007E008371007E008571007E008771007E008971007E008B71007E008D71007E008F71007E009171007E009371007E009571007E009771007E009971007E009B71007E009D71007E009F71007E00A171007E00A371007E00A571007E00A771007E00A971007E00AB71007E00AD71007E00AF71007E00B171007E00B371007E00B571007E00B771007E00B971007E00BB71007E00BD71007E00BF71007E00C171007E00C371007E00C571007E00C771007E00C971007E00CB71007E00CD71007E00CF787074000561646D696E);

 

 

 

 

 

 

 

 

Tags oauth
Scroll to Top