text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost
  Source Server Version : 50528
  Source Host           : localhost:3306
  Source Database       : open-platform
  
  Target Server Type    : MYSQL
  Target Server Version : 50528
  File Encoding         : 65001
  
  Date: 2019-07-11 18:33:03
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for oauth_access_token
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_access_token`;
  CREATE TABLE `oauth_access_token` (
    `token_id` varchar(256) DEFAULT NULL,
    `token` blob,
    `authentication_id` varchar(128) NOT NULL,
    `user_name` varchar(256) DEFAULT NULL,
    `client_id` varchar(256) DEFAULT NULL,
    `authentication` blob,
    `refresh_token` varchar(256) DEFAULT NULL,
    PRIMARY KEY (`authentication_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2访问令牌';
  
  -- ----------------------------
  -- Records of oauth_access_token
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for oauth_approvals
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_approvals`;
  CREATE TABLE `oauth_approvals` (
    `userId` varchar(256) DEFAULT NULL,
    `clientId` varchar(256) DEFAULT NULL,
    `scope` varchar(256) DEFAULT NULL,
    `status` varchar(10) DEFAULT NULL,
    `expiresAt` datetime DEFAULT NULL,
    `lastModifiedAt` datetime DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2已授权客户端';
  
  -- ----------------------------
  -- Records of oauth_approvals
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for oauth_client_details
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_client_details`;
  CREATE TABLE `oauth_client_details` (
    `client_id` varchar(128) NOT NULL,
    `client_secret` varchar(256) NOT NULL,
    `resource_ids` varchar(256) DEFAULT NULL,
    `scope` varchar(1024) DEFAULT NULL,
    `authorized_grant_types` varchar(256) DEFAULT NULL,
    `web_server_redirect_uri` varchar(256) DEFAULT NULL,
    `authorities` varchar(2048) DEFAULT NULL,
    `access_token_validity` int(11) DEFAULT NULL,
    `refresh_token_validity` int(11) DEFAULT NULL,
    `additional_information` varchar(4096) DEFAULT NULL,
    `autoapprove` varchar(256) DEFAULT NULL,
    PRIMARY KEY (`client_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2客户端信息';
  
  -- ----------------------------
  -- Records of oauth_client_details
  -- ----------------------------
  INSERT INTO `oauth_client_details` VALUES ('7gBZcbsC7kLIWCdELIl8nxcs', '$2a$10$4di0sSQdr9yk4uTKWtZqzedsxI8sWXoR67x.G.Qmy4K2L7ZaFQt6W', '', 'userProfile', 'authorization_code,client_credentials,password', 'http://localhost:8888/login,http://localhost:8888/webjars/springfox-swagger-ui/o2c.html,http://www.baidu.com', '', '43200', '2592000', '{\"website\":\"http://www.baidu.com\",\"apiKey\":\"7gBZcbsC7kLIWCdELIl8nxcs\",\"secretKey\":\"0osTIhce7uPvDKHz6aa67bhCukaKoYl4\",\"appName\":\"平台用户认证服务器\",\"updateTime\":1562841065000,\"isPersist\":1,\"appOs\":\"\",\"appIcon\":\"\",\"developerId\":0,\"createTime\":1542016125000,\"appType\":\"server\",\"appDesc\":\"资源服务器\",\"appId\":\"1552274783265\",\"appNameEn\":\"open-cloud-uaa-admin-server\",\"status\":1}', '');
  INSERT INTO `oauth_client_details` VALUES ('rOOM15Zbc3UFWgW2h71gRFvi', '$2a$10$NSb94sKA5i9kS/F0mUBehuBs9Gtvlv8wdxQOYMg3WxMRt0nyP2Xn.', '', 'userProfile', 'authorization_code,client_credentials,password', 'http://localhost:2222/login', '', '43200', '2592000', '{\"website\":\"http://www.baidu.com\",\"apiKey\":\"rOOM15Zbc3UFWgW2h71gRFvi\",\"secretKey\":\"2Iw2B0UCMYd1cZjt8Fpr4KJUx75wQCwW\",\"appName\":\"SSO单点登录DEMO\",\"updateTime\":1568611165000,\"isPersist\":1,\"appOs\":\"\",\"appIcon\":\"\",\"developerId\":0,\"createTime\":1542016125000,\"appType\":\"pc\",\"appDesc\":\"sso\",\"appId\":\"1552294656514\",\"appNameEn\":\"sso-demo\",\"status\":1}', '');
  
  -- ----------------------------
  -- Table structure for oauth_client_token
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_client_token`;
  CREATE TABLE `oauth_client_token` (
    `token_id` varchar(256) DEFAULT NULL,
    `token` blob,
    `authentication_id` varchar(128) NOT NULL,
    `user_name` varchar(256) DEFAULT NULL,
    `client_id` varchar(256) DEFAULT NULL,
    PRIMARY KEY (`authentication_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2客户端令牌';
  
  -- ----------------------------
  -- Records of oauth_client_token
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for oauth_code
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_code`;
  CREATE TABLE `oauth_code` (
    `code` varchar(256) DEFAULT NULL,
    `authentication` blob
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2授权码';
  
  -- ----------------------------
  -- Records of oauth_code
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for oauth_refresh_token
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_refresh_token`;
  CREATE TABLE `oauth_refresh_token` (
    `token_id` varchar(256) DEFAULT NULL,
    `token` blob,
    `authentication` blob
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='oauth2刷新令牌';
  
  -- ----------------------------
  -- Records of oauth_refresh_token
  -- ----------------------------
  SET FOREIGN_KEY_CHECKS=1;
  