Skip to content

Commit e9a053e

Browse files
coderbruiscoderbruis
committed
add sso.sql
1 parent c979fbf commit e9a053e

File tree

1 file changed

+5
-3
lines changed

1 file changed

+5
-3
lines changed

‎sso-auth-server/doc/oauth-server.sql renamed to ‎sso-auth-server/doc/sso.sql

Lines changed: 5 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@ Target Server Type : MYSQL
1010
Target Server Version : 50731
1111
File Encoding : 65001
1212
13-
Date: 2021-07-03 17:08:14
13+
Date: 2021-07-04 12:42:31
1414
*/
1515

1616
SET FOREIGN_KEY_CHECKS=0;
@@ -56,7 +56,6 @@ CREATE TABLE `oauth_access_token` (
5656
-- ----------------------------
5757
-- Records of oauth_access_token
5858
-- ----------------------------
59-
INSERT INTO `oauth_access_token` VALUES ('25db23c825f2d37a01dbce8b8032e92b', 0xACED0005737200436F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E636F6D6D6F6E2E44656661756C744F4175746832416363657373546F6B656E0CB29E361B24FACE0200064C00156164646974696F6E616C496E666F726D6174696F6E74000F4C6A6176612F7574696C2F4D61703B4C000A65787069726174696F6E7400104C6A6176612F7574696C2F446174653B4C000C72656672657368546F6B656E74003F4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F636F6D6D6F6E2F4F417574683252656672657368546F6B656E3B4C000573636F706574000F4C6A6176612F7574696C2F5365743B4C0009746F6B656E547970657400124C6A6176612F6C616E672F537472696E673B4C000576616C756571007E000578707372001E6A6176612E7574696C2E436F6C6C656374696F6E7324456D7074794D6170593614855ADCE7D002000078707372000E6A6176612E7574696C2E44617465686A81014B59741903000078707708000001737C1B9E037870737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C0001637400164C6A6176612F7574696C2F436F6C6C656374696F6E3B7870737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000023F400000000000017400036170707874000662656172657274002466623265386239322D323436332D343435372D613135612D663937366664326637373938, '8502edc3f4c61f1000b1932e6a3756f1', 'admin', 'client', 0xACED0005737200416F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F417574683241757468656E7469636174696F6EBD400B02166252130200024C000D73746F7265645265717565737474003C4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F4F4175746832526571756573743B4C00127573657241757468656E7469636174696F6E7400324C6F72672F737072696E676672616D65776F726B2F73656375726974792F636F72652F41757468656E7469636174696F6E3B787200476F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E416273747261637441757468656E7469636174696F6E546F6B656ED3AA287E6E47640E0200035A000D61757468656E746963617465644C000B617574686F7269746965737400164C6A6176612F7574696C2F436F6C6C656374696F6E3B4C000764657461696C737400124C6A6176612F6C616E672F4F626A6563743B787000737200266A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654C697374FC0F2531B5EC8E100200014C00046C6973747400104C6A6176612F7574696C2F4C6973743B7872002C6A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65436F6C6C656374696F6E19420080CB5EF71E0200014C00016371007E00047870737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A6578700000000B77040000000B737200426F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E617574686F726974792E53696D706C654772616E746564417574686F7269747900000000000002080200014C0004726F6C657400124C6A6176612F6C616E672F537472696E673B787074000653797374656D7371007E000D74000D53797374656D436F6E74656E747371007E000D74001353797374656D436F6E74656E7444656C6574657371007E000D74001353797374656D436F6E74656E74496E736572747371007E000D74001353797374656D436F6E74656E745570646174657371007E000D74001153797374656D436F6E74656E74566965777371007E000D74000A53797374656D557365727371007E000D74001053797374656D5573657244656C6574657371007E000D74001053797374656D55736572496E736572747371007E000D74001053797374656D557365725570646174657371007E000D74000E53797374656D55736572566965777871007E000C707372003A6F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E4F41757468325265717565737400000000000000010200075A0008617070726F7665644C000B617574686F72697469657371007E00044C000A657874656E73696F6E7374000F4C6A6176612F7574696C2F4D61703B4C000B726564697265637455726971007E000E4C00077265667265736874003B4C6F72672F737072696E676672616D65776F726B2F73656375726974792F6F61757468322F70726F76696465722F546F6B656E526571756573743B4C000B7265736F7572636549647374000F4C6A6176612F7574696C2F5365743B4C000D726573706F6E7365547970657371007E0028787200386F72672E737072696E676672616D65776F726B2E73656375726974792E6F61757468322E70726F76696465722E426173655265717565737436287A3EA37169BD0200034C0008636C69656E74496471007E000E4C001172657175657374506172616D657465727371007E00264C000573636F706571007E00287870740006636C69656E74737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C654D6170F1A5A8FE74F507420200014C00016D71007E00267870737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F400000000000037708000000040000000274000A6772616E745F7479706574000870617373776F7264740008757365726E616D6574000561646D696E78737200256A6176612E7574696C2E436F6C6C656374696F6E7324556E6D6F6469666961626C65536574801D92D18F9B80550200007871007E0009737200176A6176612E7574696C2E4C696E6B656448617368536574D86CD75A95DD2A1E020000787200116A6176612E7574696C2E48617368536574BA44859596B8B7340300007870770C000000103F4000000000000174000361707078017371007E0037770C000000103F40000000000000787371007E002E3F40000000000000770800000010000000007870707371007E0037770C000000103F40000000000000787371007E0037770C000000103F40000000000000787372004F6F72672E737072696E676672616D65776F726B2E73656375726974792E61757468656E7469636174696F6E2E557365726E616D6550617373776F726441757468656E7469636174696F6E546F6B656E00000000000002080200024C000B63726564656E7469616C7371007E00054C00097072696E636970616C71007E00057871007E0003017371007E00077371007E000B0000000B77040000000B71007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E00237871007E0041737200176A6176612E7574696C2E4C696E6B6564486173684D617034C04E5C106CC0FB0200015A000B6163636573734F726465727871007E002E3F400000000000067708000000080000000271007E003071007E003171007E003271007E0033780070737200326F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657200000000000002080200075A00116163636F756E744E6F6E457870697265645A00106163636F756E744E6F6E4C6F636B65645A001563726564656E7469616C734E6F6E457870697265645A0007656E61626C65644C000B617574686F72697469657371007E00284C000870617373776F726471007E000E4C0008757365726E616D6571007E000E7870010101017371007E0034737200116A6176612E7574696C2E54726565536574DD98509395ED875B0300007870737200466F72672E737072696E676672616D65776F726B2E73656375726974792E636F72652E7573657264657461696C732E5573657224417574686F72697479436F6D70617261746F720000000000000208020000787077040000000B71007E000F71007E001171007E001371007E001571007E001771007E001971007E001B71007E001D71007E001F71007E002171007E0023787074000561646D696E, null);
6059

6160
-- ----------------------------
6261
-- Table structure for oauth_approvals
@@ -97,7 +96,10 @@ CREATE TABLE `oauth_client_details` (
9796
-- ----------------------------
9897
-- Records of oauth_client_details
9998
-- ----------------------------
100-
INSERT INTO `oauth_client_details` VALUES ('client', null, '$2a$10$r0g/vsua5ohX/pi4Wo561O9cX2.oKe4ctJvaPl6rQRYZJ8rM8D0xW', 'app', 'authorization_code,password', 'http://www.baidu.com', null, null, null, null, 'false');
99+
INSERT INTO `oauth_client_details` VALUES ('client', null, '$2a$10$r0g/vsua5ohX/pi4Wo561O9cX2.oKe4ctJvaPl6rQRYZJ8rM8D0xW', 'all', 'authorization_code,password', 'http://www.baidu.com', null, null, null, null, 'false');
100+
INSERT INTO `oauth_client_details` VALUES ('client2', null, '$2a$10$r0g/vsua5ohX/pi4Wo561O9cX2.oKe4ctJvaPl6rQRYZJ8rM8D0xW', 'user_info', 'authorization_code', 'http://localhost:8903/login', null, null, null, null, 'user_info');
101+
INSERT INTO `oauth_client_details` VALUES ('CouponSystem', null, '$2a$10$dYRcFip80f0jIKGzRGulFelK12036xWQKgajanfxT65QB4htsEXNK', 'user_info', 'authorization_code', 'http://localhost:8082/login', null, null, null, null, 'user_info');
102+
INSERT INTO `oauth_client_details` VALUES ('MemberSystem', null, '$2a$10$dYRcFip80f0jIKGzRGulFelK12036xWQKgajanfxT65QB4htsEXNK', 'user_info', 'authorization_code', 'http://localhost:8081/login', null, null, null, null, 'user_info');
101103

102104
-- ----------------------------
103105
-- Table structure for oauth_client_token

0 commit comments

Comments
 (0)