编程人 cdmana.com

Detailed summary of several spring security mode request methods

 

Authorization code mode

 

1、 Get token

 

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

 Database table (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);

 

Parameters

Specific value

remarks

client_id

client

Database fields client_id

response_type

code

Access type

redirect_uri

https://www.baidu.com

Database field callback address

state

xxo

In order to prevent CSRF attack , When applying for the authorization code , You can add a... To the parameter state State parameters , This parameter is a random string generated by the client , The authorization service will return this parameter and its value intact , The user will also carry this string for comparison when requesting authorization from the client .

scope

app

Database fields scope

 

 

 

 

2、 obtain token

 

POST request 
http://localhost:3000/oauth/token

Request parameters

Parameters

Specific value

remarks

grant_type

authorization_code

Type of Authorization

code

A2Y7NQ

Authorization code code

client_id

client

Database fields -client_id

client_secret

secret

Database fields — client secret

redirect_uri

https://www.baidu.com

Database fields token url

 

 

 

 

 

Password mode

 

POST request 
http://localhost:3000/oauth/token

 Database table (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);

Request parameters

Parameters

Specific value

remarks

grant_type

password

Type of Authorization

username

admin

The user account

password

admin

User password

client_id

client1

Database fields -client_id

client_secret

secret

Database fields — client secret

scope

app

Database fields

 

 

 

 

 

Client mode

 

 

POST request 
http://localhost:3000/oauth/token

 Database table (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);

Request parameters

Parameters

Specific value

remarks

grant_type

client_credentials

Type of Authorization

client_id

client2

Database fields -client_id

client_secret

secret

Database fields — client secret

scope

api_base

Database fields

 

 

Simplified mode

 

 Browser request GET Pattern , Do not use postman
http://localhost:3000/oauth/authorize?client_id=client3&response_type=token&redirect_uri=https://www.baidu.com&state=fuce&scope=api_base

Refresh mode ( Refresh token)

 

POST request 
http://localhost:3000/oauth/token

Request parameters

Parameters

Specific value

remarks

grant_type

refresh_token

Type of Authorization

client_id

client1

Database fields -client_id

client_secret

secret

Database fields — client secret

refresh_token

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

Last time I asked refresh_token

 

 

 

The database explains

 

1、oauth_client_details

In the project , Main operation oauth_client_details The class of the watch is JdbcClientDetailsService.java, Please refer to this class for more details . Or according to actual needs , To extend or modify the implementation of this class .

client_id Primary key , Must be unique , Can't be empty .
Used to uniquely identify each client (client); You must fill in ( It can also be automatically generated by the server ).
For different grant_type, This field is required . Another name in practical application is appKey, And client_id It's the same concept .
resource_ids

Resources that clients can access id aggregate , Use commas... For multiple resources (,) Separate , Such as : "unity-resource,mobile-resource".

You can see from the picture above , We have Resource Server Resource server ., Resource servers can have multiple , We can do it for each one Resource Server( A microservice instance ) Set up a resourceid.

Authorization Server to client When a third-party client is authorized , You can set this client Which ones can be accessed Resource Server Resource service , If not , It's all about Resource Server All have access rights .

client_secret Used to specify the client (client) Access key for ; You must fill in ( It can also be automatically generated by the server ).
For different grant_type, This field is required . Another name in practical application is appSecret, And client_secret It's the same concept .
scope

Specify the permission range requested by the client , Optional values include read,write,trust; If there are multiple permission ranges, use comma (,) Separate , Such as : "read,write".

@EnableGlobalMethodSecurity(prePostEnabled = true) Enable method level permission control

Then annotate the method to identify @PreAuthorize("#oauth2.hasScope('read')")

authorized_grant_types Specify the... Supported by the client grant_type, Optional values include authorization_code,password,refresh_token,implicit,client_credentials, If multiple grant_type Comma (,) Separate , Such as : "authorization_code,password".
in application , When registering , This field is generally specified by the server , Instead of being chosen by the applicant , Most commonly used grant_type The combination has : "authorization_code,refresh_token"( For clients accessed through a browser ); "password,refresh_token"( Clients for mobile devices ).
implicit And client_credentials Rarely used in practice , According to your own needs , stay OAuth2.0 Provides a place for extended custom Authorization
web_server_redirect_uri Client redirection URI, May be empty , When grant_type by authorization_code or implicit when , stay Oauth Will be used in the process of checking and registering with the redirect_uri Is it consistent . Here are the instructions :
  • When grant_type=authorization_code when , First step from spring-oauth-server obtain 'code' When the client initiates the request, there must be redirect_uri Parameters , The value of this parameter must be the same as web_server_redirect_uri The value is consistent. . The second step use 'code' Exchange for 'access_token' When the customer has to deliver the same redirect_uri.
    in application , web_server_redirect_uri It is required to fill in when registering , It is usually used to process the returned code, verification state Whether it is legal or not code To exchange access_token value .
    stay spring-oauth-client In the project , Please refer to AuthorizationCodeController.java Medium authorizationCodeCallback Method .
  • When grant_type=implicit Through redirect_uri Of hash Value to deliver access_token value . Such as :
    • http://localhost:7777/spring-oauth-client/implicit#access_token=dc891f4a-ac88-4ba6-8224-a2497e013865&token_type=bearer&expires_in=43199
  • Then the client passes through JS Wait for hash Take... From the value access_token value .
authorities

 @PreAuthorize("hasAuthority('admin')") Can be marked on the method Users or client What kind of permissions need to be specified

Specify what the client owns Spring Security Permission value of , Optional , If there are multiple permission values , Comma (,) Separate , Such as : "ROLE_UNITY,ROLE_USER".

For whether to set the value of this field , According to different grant_type To judge , If the client is in Oauth The user name of the user... Is required in the process (username) With the code (password) Of (authorization_code,password),

Then the value of this field can be set without , Because the server will judge whether it has access to the corresponding... According to the user's permission in the server API.

But if the client is Oauth There is no need for user information in the process (implicit,client_credentials),

Then the corresponding permission value must be set for this field , Because the server will judge whether it has permission to access the corresponding API.

( Please be there. spring-oauth-client In the project to test different grant_type when authorities The change of )

access_token_validity Set the client's access_token Effective time value of ( Company : second ), Optional , If no value is set, the default effective time value is used (60 * 60 * 12, 12 Hours ).
Obtained on the server side access_token JSON In the data expires_in The value of the field is the current access_token Effective time value of .
In the project , Please refer to DefaultTokenServices.java Middle attribute accessTokenValiditySeconds.
in application , This value is generally handled by the server , No client customization is required .
refresh_token_validity Set the client's refresh_token Effective time value of ( Company : second ), Optional , If no value is set, the default effective time value is used (60 * 60 * 24 * 30, 30 God ).
If the client's grant_type barring refresh_token, Don't care about the field In the project , Please refer to DefaultTokenServices.java Middle attribute refreshTokenValiditySeconds.
in application , This value is generally handled by the server , No client customization is required .
additional_information This is a reserved field , stay Oauth There is no actual use in the process of , Optional , But if the setting is , Must be JSON Formatted data , Such as :
{"country":"CN","country_code":"086"}
according to spring-security-oauth Description of the field in the project
Additional information for this client, not need by the vanilla OAuth protocol but might be useful, for example,for storing descriptive information.
( See ClientDetails.java Of getAdditionalInformation() Method comments )  in application , You can use this field to store some other information about the client , Such as the country of the client , region , At the time of registration IP Address, etc. .
create_time Data creation time , Accurate to seconds , It is automatically generated by taking the current system time from the database when inserting data ( Extension field )
autoapprove Set whether the user automatically Approval operation , The default value is 'false', Optional values include 'true','false', 'read','write'.
This field only applies to grant_type="authorization_code" The situation of , When the user logs in successfully , If the value is 'true' Or support scope value , Will skip the user Approve The page of , Direct authorization .

 

2、oauth_client_token

This table is used to store the... Obtained from the server in the client system token data ,  stay spring-oauth-server Not used in the project .  Yes

oauth_client_token The main operation of the watch is JdbcClientTokenServices.java Class ,  Please refer to this class for more details .

Field name Field description
create_time Data creation time , Accurate to seconds , It is automatically generated by taking the current system time from the database when inserting data ( Extension field )
token_id From the server side access_token Value .
token This is a binary field ,  The data stored is OAuth2AccessToken.java Binary after object serialization
Control data .
authentication_id This field is unique ,  According to the current username( If there is ),client_id And scope adopt MD5 encryption
Generated .  Please refer to DefaultClientKeyGenerator.java class .
user_name User name when logging in
client_id  

 

 

 

 

3、oauth_access_token

Field name Field description
create_time Data creation time , Accurate to seconds , It is automatically generated by taking the current system time from the database when inserting data ( Extension field )
token_id The value of this field will be access_token The value of is passed MD5 Stored after encryption .
token Storage will OAuth2AccessToken.java Binary data after object serialization ,  Is real AccessToken
Data value .
authentication_id This field is unique ,  Its value is based on the current username( If there is ),client_id And scope adopt MD5
Encryption generated .  Please refer to DefaultAuthenticationKeyGenerator.java class .
user_name User name when logging in ,  If the client does not have a user name ( Such as grant_type=“client_credentials”), Then the value is equal to
On client_id
client_id  
authentication Storage will OAuth2Authentication.java Binary data after object serialization .
refresh_token The value of this field will be refresh_token The value of is passed MD5 Stored after encryption .  In the project , Main operation
oauth_access_token The object of the watch is JdbcTokenStore.java.  Please refer to this class for more details

 

4、oauth_refresh_token

In the project , Main operation oauth_refresh_token The object of the watch is JdbcTokenStore.java. ( And operation oauth_access_token The object of the table

equally ); Please refer to this class for more details .  If the client's grant_type I won't support it refresh_token, It will not be used .

Field name Field description
create_time Data creation time , Accurate to seconds , It is automatically generated by taking the current system time from the database when inserting data ( Extension field )
token_id The value of this field will be refresh_token The value of is passed MD5 Stored after encryption .
token Storage will OAuth2RefreshToken.java Binary data after object serialization .
authentication Storage will OAuth2Authentication.java Binary data after object serialization .

 

 

5、oauth_code

In the project , Main operation oauth_code The object of the watch is JdbcAuthorizationCodeServices.java.  Please refer to this class for more details . Only when

grant_type by "authorization_code" when , Only in this table will data be generated ;  Other grant_type This table is not used .

 

Field name Field description
create_time Data creation time , Accurate to seconds , It is automatically generated by taking the current system time from the database when inserting data ( Extension field )
code It is generated by the storage server system code Value ( unencrypted ).
authentication Storage will AuthorizationRequestHolder.java Binary data after object serialization .

 

 

 

 

other

Oauth Supported by 5 class grant_type Fields and descriptions

Parameters

explain

 

authorization_code

Authorization code mode ( That is, log in first to get code, Get more token)

grant_type=authorization_code

password

Password mode ( Put the user name , Pass the code , Direct access to token)

grant_type=password

client_credentials

Client mode ( No users , The user registers with the client , Then the client in its own name to ’ Server side ’ Access to resources )

grant_type=client_credentials

implicit

Simplified mode ( stay redirect_uri Of Hash Pass on token; Auth The client runs in the browser , Such as JS,Flash)

grant_type=implicit

refresh_token

Refresh access_token

grant_type=refresh_token

 

 

 

 

 

The attachment

postman.json file

v2-cloud.postman_collection.json

 

 

database

mysql Of



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 ' Encrypted access_token Value ',
  `token` blob NULL COMMENT 'OAuth2AccessToken.java Binary data after object serialization ',
  `authentication_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ' Encrypted username,client_id,scope',
  `user_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Login user name ',
  `client_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' client ID',
  `authentication` blob NULL COMMENT 'OAuth2Authentication.java Binary data after object serialization ',
  `refresh_token` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Encrypted refresh_token Value ',
  PRIMARY KEY (`authentication_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' The access token ' 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 ' Login user name ',
  `clientId` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' client ID',
  `scope` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' The scope of authority to apply ',
  `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' state (Approve or Deny)',
  `expiresAt` timestamp(0) NULL DEFAULT NULL COMMENT ' Expiration time ',
  `lastModifiedAt` timestamp(0) NULL DEFAULT NULL COMMENT ' Final revision time '
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' Authorization records ' 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 ' client ID',
  `resource_ids` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' resources ID aggregate , Use commas... For multiple resources (,) Separate ',
  `client_secret` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Client key ',
  `scope` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' The scope of permission applied by the client ',
  `authorized_grant_types` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Client support grant_type',
  `web_server_redirect_uri` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Redirect URI',
  `authorities` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' What the client owns Spring Security Permission value of , Multiple commas (,) Separate ',
  `access_token_validity` int(11) NULL DEFAULT NULL COMMENT ' Access token valid time value ( Company : second ) Default (60 * 60 * 12,12 Hours )',
  `refresh_token_validity` int(11) NULL DEFAULT NULL COMMENT ' Update token valid time value ( Company : second ) Default (60 *60 * 24 * 30, 30 God )',
  `additional_information` varchar(4096) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Reserved fields ',
  `autoapprove` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Whether the user automatically Approval operation ',
  PRIMARY KEY (`client_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' Client information ' 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 ' Encrypted access_token value ',
  `token` blob NULL COMMENT 'OAuth2AccessToken.java Binary data after object serialization ',
  `authentication_id` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT ' Encrypted username,client_id,scope',
  `user_name` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Login user name ',
  `client_id` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' client ID',
  PRIMARY KEY (`authentication_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' The client is used to record token Information ' 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 ' Authorization code ( unencrypted )',
  `authentication` blob NULL COMMENT 'AuthorizationRequestHolder.java Binary data after object serialization '
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' Authorization code ' 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 ' Encrypted refresh_token Value ',
  `token` blob NULL COMMENT 'OAuth2RefreshToken.java Binary data after object serialization ',
  `authentication` blob NULL COMMENT 'OAuth2Authentication.java Binary data after object serialization '
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = ' Update token ' ROW_FORMAT = Dynamic;

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

 

 

 

 

 

 

 

 

Scroll to Top