整合案例的源码是恒宇少年知识库小程序的接口源码，采用ApiBoot构建的接口服务项目，是一个针对ApiBoot落地使用的案例。

集成的ApiBoot依赖

该项目集成的ApiBoot模块比较多，pom.xml部分相关ApiBoot依赖如下所示：

  1. <dependencies>
  2.   <!--ApiBoot Security Oauth-->
  3.   <dependency>
  4.     <groupId>org.minbox.framework</groupId>
  5.     <artifactId>api-boot-starter-security-oauth-jwt</artifactId>
  6.   </dependency>
  7.   <!--ApiBoot Swagger-->
  8.   <dependency>
  9.     <groupId>org.minbox.framework</groupId>
  10.     <artifactId>api-boot-starter-swagger</artifactId>
  11.   </dependency>
  12.   <!--ApiBoot Http Converter-->
  13.   <dependency>
  14.     <groupId>org.minbox.framework</groupId>
  15.     <artifactId>api-boot-starter-http-converter</artifactId>
  16.   </dependency>
  17.   <!--ApiBoot Resource Load-->
  18.   <dependency>
  19.     <groupId>org.minbox.framework</groupId>
  20.     <artifactId>api-boot-starter-resource-load</artifactId>
  21.   </dependency>
  22.   <!--ApiBoot Mybatis Enhance-->
  23.   <dependency>
  24.     <groupId>org.minbox.framework</groupId>
  25.     <artifactId>api-boot-starter-mybatis-enhance</artifactId>
  26.   </dependency>
  27.   <!--ApiBoot Mybatis Pageable-->
  28.   <dependency>
  29.     <groupId>org.minbox.framework</groupId>
  30.     <artifactId>api-boot-starter-mybatis-pageable</artifactId>
  31.   </dependency>
  32. </dependencies>
  33. <build>
  34.   <plugins>
  35.     <plugin>
  36.       <groupId>org.minbox.framework</groupId>
  37.       <artifactId>api-boot-mybatis-enhance-maven-codegen</artifactId>
  38.       <version>2.0.9-SNAPSHOT</version>
  39.       <dependencies>
  40.         <!--数据驱动依赖-->
  41.         <dependency>
  42.           <groupId>mysql</groupId>
  43.           <artifactId>mysql-connector-java</artifactId>
  44.           <version>5.1.47</version>
  45.         </dependency>
  46.       </dependencies>
  47.       <executions>
  48.         <execution>
  49.           <goals>
  50.             <goal>generator</goal>
  51.           </goals>
  52.         </execution>
  53.       </executions>
  54.       <configuration>
  55.         <!--为true时执行自动生成-->
  56.         <execute>false</execute>
  57.         <dbName>knowledge</dbName>
  58.         <dbUrl>jdbc:mysql://localhost:3306</dbUrl>
  59.         <dbUserName>root</dbUserName>
  60.         <dbPassword>123456</dbPassword>
  61.         <packageName>org.minbox.framework.knowledge.library.common.entity</packageName>
  62.         <tableNamePattern>kl%</tableNamePattern>
  63.       </configuration>
  64.     </plugin>
  65.   </plugins>
  66. </build>
  67. <dependencyManagement>
  68.   <dependencies>
  69.     <!--ApiBoot Dependencies-->
  70.     <dependency>
  71.       <groupId>org.minbox.framework</groupId>
  72.       <artifactId>api-boot-dependencies</artifactId>
  73.       <version>${api.boot.version}</version>
  74.       <scope>import</scope>
  75.       <type>pom</type>
  76.     </dependency>
  77.   </dependencies>
  78. </dependencyManagement>

数据库结构

  1. /*
  2.  Navicat MySQL Data Transfer
  4.  Source Server         : 知识库正式
  5.  Source Server Type    : MySQL
  6.  Source Server Version : 50718
  7.  Source Host           : rm-2zeet0j72ljt4uz97wo.mysql.rds.aliyuncs.com:3306
  8.  Source Schema         : knowledge
  10.  Target Server Type    : MySQL
  11.  Target Server Version : 50718
  12.  File Encoding         : 65001
  14.  Date: 17/05/2019 13:44:51
  15. */
  17. SET NAMES utf8mb4;
  18. SET FOREIGN_KEY_CHECKS = 0;
  20. -- ----------------------------
  21. -- Table structure for clientdetails
  22. -- ----------------------------
  23. DROP TABLE IF EXISTS `clientdetails`;
  24. CREATE TABLE `clientdetails` (
  25.   `appId` varchar(128) NOT NULL,
  26.   `resourceIds` varchar(256) DEFAULT NULL,
  27.   `appSecret` varchar(256) DEFAULT NULL,
  28.   `scope` varchar(256) DEFAULT NULL,
  29.   `grantTypes` varchar(256) DEFAULT NULL,
  30.   `redirectUrl` varchar(256) DEFAULT NULL,
  31.   `authorities` varchar(256) DEFAULT NULL,
  32.   `access_token_validity` int(11) DEFAULT NULL,
  33.   `refresh_token_validity` int(11) DEFAULT NULL,
  34.   `additionalInformation` varchar(4096) DEFAULT NULL,
  35.   `autoApproveScopes` varchar(256) DEFAULT NULL,
  36.   PRIMARY KEY (`appId`)
  37. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  39. -- ----------------------------
  40. -- Table structure for kl_article_info
  41. -- ----------------------------
  42. DROP TABLE IF EXISTS `kl_article_info`;
  43. CREATE TABLE `kl_article_info` (
  44.   `AI_ID` varchar(36) NOT NULL COMMENT '主键自增',
  45.   `AI_USER_ID` varchar(36) DEFAULT NULL COMMENT '文章所属用户',
  46.   `AI_TITLE` varchar(200) DEFAULT NULL COMMENT '文章标题',
  47.   `AI_READ_COUNT` int(11) DEFAULT NULL COMMENT '阅读量',
  48.   `AI_LIKE_COUNT` int(11) DEFAULT NULL COMMENT '喜欢数量',
  49.   `AI_COMMENT_COUNT` int(11) DEFAULT NULL COMMENT '评论数量',
  50.   `AI_SHARE_COUNT` int(11) DEFAULT NULL COMMENT '分享数量',
  51.   `AI_CONTENT` longtext COMMENT '文章内容',
  52.   `AI_IS_ORIGINAL` char(1) DEFAULT 'Y' COMMENT '是否为原创文章，Y：原创，N：转载',
  53.   `AI_IS_RELEASE` char(1) DEFAULT NULL COMMENT '文章是否发布，Y：已发布，N：未发布',
  54.   `AI_IS_HOT` char(1) DEFAULT 'N' COMMENT '是否热门,Y：热门，N：非热门',
  55.   `AI_IS_TOP` char(1) DEFAULT 'N' COMMENT '是否置顶，Y：置顶，N：普通',
  56.   `AI_IS_RECOMMEND` char(1) DEFAULT 'N' COMMENT '是否推荐，Y：推荐，N：不推荐',
  57.   `AI_IS_MARKDOWN` char(1) DEFAULT 'Y' COMMENT '是否为markdown语法文章',
  58.   `AI_RELEASE_TIME` datetime DEFAULT NULL COMMENT '发布时间',
  59.   `AI_STATUS` char(3) DEFAULT 'O' COMMENT '文章状态，O：正常，D：已删除',
  60.   `AI_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  61.   `AI_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '文章创建时间',
  62.   PRIMARY KEY (`AI_ID`),
  63.   KEY `kl_article_info_AI_USER_ID_index` (`AI_USER_ID`)
  64. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章信息表';
  66. -- ----------------------------
  67. -- Table structure for kl_article_topic_info
  68. -- ----------------------------
  69. DROP TABLE IF EXISTS `kl_article_topic_info`;
  70. CREATE TABLE `kl_article_topic_info` (
  71.   `ATI_ID` varchar(36) NOT NULL COMMENT '专题主键',
  72.   `ATI_NAME` varchar(20) DEFAULT NULL COMMENT '专题名称',
  73.   `ATI_SORT` int(11) DEFAULT NULL COMMENT '排序字段，值越大越靠前',
  74.   `ATI_STATUS` char(1) DEFAULT 'O' COMMENT '专题状态，O：正常，D：已删除',
  75.   `ATI_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  76.   `ATI_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  77.   PRIMARY KEY (`ATI_ID`)
  78. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章专题信息表';
  80. -- ----------------------------
  81. -- Table structure for kl_article_topic_uni
  82. -- ----------------------------
  83. DROP TABLE IF EXISTS `kl_article_topic_uni`;
  84. CREATE TABLE `kl_article_topic_uni` (
  85.   `ATU_ID` int(11) NOT NULL AUTO_INCREMENT,
  86.   `ATU_ARTICLE_ID` varchar(36) DEFAULT NULL COMMENT '文章编号，关联kl_article_info主键',
  87.   `ATU_TOPIC_ID` varchar(36) DEFAULT NULL COMMENT '文章专题，关联kl_article_topic_info主键',
  88.   `ATU_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  89.   PRIMARY KEY (`ATU_ID`),
  90.   KEY `kl_article_topic_uni_ATU_ARTICLE_ID_index` (`ATU_ARTICLE_ID`),
  91.   KEY `kl_article_topic_uni_ATU_TOPIC_ID_index` (`ATU_TOPIC_ID`)
  92. ) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8 COMMENT='文章专题关联信息表';
  94. -- ----------------------------
  95. -- Table structure for kl_banner_info
  96. -- ----------------------------
  97. DROP TABLE IF EXISTS `kl_banner_info`;
  98. CREATE TABLE `kl_banner_info` (
  99.   `BI_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  100.   `BI_JUMP_ARTICLE_ID` varchar(36) DEFAULT NULL COMMENT '点击跳转文章编号，关联kl_article_info主键',
  101.   `BI_START_TIME` datetime DEFAULT NULL COMMENT '展示开始时间',
  102.   `BI_END_TIME` datetime DEFAULT NULL COMMENT '展示结束时间',
  103.   `BI_STATUS` char(1) DEFAULT 'O' COMMENT '轮播图状态，O：正常，D：已删除',
  104.   `BI_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  105.   `BI_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  106.   PRIMARY KEY (`BI_ID`),
  107.   KEY `kl_banner_info_BI_JUMP_ARTICLE_ID_index` (`BI_JUMP_ARTICLE_ID`)
  108. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='轮播图信息表';
  110. -- ----------------------------
  111. -- Table structure for kl_comment_info
  112. -- ----------------------------
  113. DROP TABLE IF EXISTS `kl_comment_info`;
  114. CREATE TABLE `kl_comment_info` (
  115.   `CI_ID` varchar(36) NOT NULL COMMENT '留言主键',
  116.   `CI_ARTICLE_ID` varchar(36) DEFAULT NULL COMMENT '文章编号，关联kl_article_info主键',
  117.   `CI_CREATOR_ID` varchar(36) DEFAULT NULL COMMENT '评论创建者，关联kl_user_info主键',
  118.   `CI_COMMENT_ID` varchar(36) DEFAULT NULL COMMENT '上级评论编号，关联本表主键',
  119.   `CI_TARGET_ID` varchar(36) DEFAULT NULL COMMENT '回复目标用户编号，关联kl_user_info主键',
  120.   `CI_CONTENT` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT '留言内容',
  121.   `CI_IS_AUTHOR` char(1) DEFAULT NULL COMMENT '是否为作者评论，Y：作者评论，N：非作者',
  122.   `CI_LIKE_COUNT` int(11) DEFAULT NULL COMMENT '评论喜欢数量',
  123.   `CI_COMMENT_COUNT` int(11) DEFAULT NULL COMMENT '评论的评论、回复数量',
  124.   `CI_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '留言时间',
  125.   PRIMARY KEY (`CI_ID`),
  126.   KEY `kl_comment_info_CI_ARTICLE_ID_index` (`CI_ARTICLE_ID`),
  127.   KEY `kl_comment_info_CI_COMMENT_ID_index` (`CI_COMMENT_ID`),
  128.   KEY `kl_comment_info_CI_CREATOR_ID_index` (`CI_CREATOR_ID`),
  129.   KEY `kl_comment_info_CI_TARGET_ID_index` (`CI_TARGET_ID`)
  130. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文章评论信息表';
  132. -- ----------------------------
  133. -- Table structure for kl_common_resource
  134. -- ----------------------------
  135. DROP TABLE IF EXISTS `kl_common_resource`;
  136. CREATE TABLE `kl_common_resource` (
  137.   `CR_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  138.   `CR_TYPE_ID` varchar(36) DEFAULT NULL COMMENT '资源类型，关联kl_common_resource_type主键',
  139.   `CR_TARGET_ID` varchar(36) DEFAULT NULL COMMENT '资源所属目标编号',
  140.   `CR_URL` text COMMENT '资源路径',
  141.   `CR_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  142.   PRIMARY KEY (`CR_ID`),
  143.   KEY `kl_common_resource_CR_TARGET_ID_index` (`CR_TARGET_ID`),
  144.   KEY `kl_common_resource_CR_TYPE_ID_index` (`CR_TYPE_ID`)
  145. ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COMMENT='统一资源';
  147. -- ----------------------------
  148. -- Table structure for kl_common_resource_type
  149. -- ----------------------------
  150. DROP TABLE IF EXISTS `kl_common_resource_type`;
  151. CREATE TABLE `kl_common_resource_type` (
  152.   `CRT_ID` varchar(36) NOT NULL COMMENT '资源编号',
  153.   `CRT_NAME` varchar(30) DEFAULT NULL COMMENT '资源类型名称',
  154.   `CRT_FLAG` varchar(50) DEFAULT NULL COMMENT '资源类型标识',
  155.   `CRT_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  156.   `CRT_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  157.   PRIMARY KEY (`CRT_ID`)
  158. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='统一资源类型';
  160. -- ----------------------------
  161. -- Table structure for kl_feedback
  162. -- ----------------------------
  163. DROP TABLE IF EXISTS `kl_feedback`;
  164. CREATE TABLE `kl_feedback` (
  165.   `KF_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '反馈主键自增',
  166.   `KF_USER_ID` varchar(36) DEFAULT NULL COMMENT '反馈用户编号，关联kl_user_info主键',
  167.   `KF_CONTENT` text COMMENT '反馈内容',
  168.   `KF_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '反馈时间',
  169.   PRIMARY KEY (`KF_ID`)
  170. ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COMMENT='意见反馈信息表';
  172. -- ----------------------------
  173. -- Table structure for kl_user_balance_info
  174. -- ----------------------------
  175. DROP TABLE IF EXISTS `kl_user_balance_info`;
  176. CREATE TABLE `kl_user_balance_info` (
  177.   `UBI_ID` varchar(36) NOT NULL COMMENT '账户主键',
  178.   `UBI_USER_ID` varchar(36) DEFAULT NULL COMMENT '用户编号，关联kl_user_info主键',
  179.   `UBI_TYPE_ID` varchar(36) DEFAULT NULL COMMENT '账户类型编号，关联kl_balance_type主键',
  180.   `UBI_BALANCE` decimal(8,2) DEFAULT NULL COMMENT '账户余额，保留两位小数点',
  181.   `UBI_IS_LOCK` char(1) DEFAULT 'N' COMMENT '账户是否锁定，Y：已锁定，N：未锁定',
  182.   `UBI_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  183.   `UBI_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  184.   PRIMARY KEY (`UBI_ID`),
  185.   KEY `kl_user_balance_info_UBI_USER_ID_index` (`UBI_USER_ID`),
  186.   KEY `kl_user_balance_info_UBI_TYPE_ID_index` (`UBI_TYPE_ID`)
  187. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户账户信息表';
  189. -- ----------------------------
  190. -- Table structure for kl_user_balance_record
  191. -- ----------------------------
  192. DROP TABLE IF EXISTS `kl_user_balance_record`;
  193. CREATE TABLE `kl_user_balance_record` (
  194.   `BR_ID` int(11) NOT NULL AUTO_INCREMENT,
  195.   `BR_BALANCE_ID` varchar(36) DEFAULT NULL COMMENT '所属账户编号，关联kl_balance_info主键',
  196.   `BR_BEFORE` decimal(8,2) DEFAULT NULL COMMENT '变动之前的值',
  197.   `BR_COUNT` decimal(8,2) DEFAULT NULL COMMENT '变动的值',
  198.   `BR_AFTER` decimal(8,2) DEFAULT NULL COMMENT '变动后的值',
  199.   `BR_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  200.   `BR_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  201.   PRIMARY KEY (`BR_ID`),
  202.   KEY `kl_balance_record_BR_BALANCE_ID_index` (`BR_BALANCE_ID`)
  203. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='账户变动记录';
  205. -- ----------------------------
  206. -- Table structure for kl_user_balance_type
  207. -- ----------------------------
  208. DROP TABLE IF EXISTS `kl_user_balance_type`;
  209. CREATE TABLE `kl_user_balance_type` (
  210.   `UBT_ID` varchar(36) NOT NULL COMMENT '账户类型主键',
  211.   `UBT_NAME` varchar(20) DEFAULT NULL COMMENT '账户类型名称',
  212.   `UBT_FLAG` varchar(20) DEFAULT NULL COMMENT '账户类型标识',
  213.   `UBT_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  214.   PRIMARY KEY (`UBT_ID`)
  215. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户账户类型';
  217. -- ----------------------------
  218. -- Table structure for kl_user_info
  219. -- ----------------------------
  220. DROP TABLE IF EXISTS `kl_user_info`;
  221. CREATE TABLE `kl_user_info` (
  222.   `UI_ID` varchar(36) CHARACTER SET utf8 NOT NULL COMMENT '主键自增',
  223.   `UI_NICK_NAME` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户昵称',
  224.   `UI_OPEN_ID` varchar(30) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户微信openId',
  225.   `UI_PASSWORD` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '用户密码',
  226.   `UI_LAST_LOGIN_TIME` datetime DEFAULT NULL COMMENT '最后登录时间',
  227.   `UI_STATUS` char(1) CHARACTER SET utf8 DEFAULT 'O' COMMENT '用户状态，O：正常，D：已删除',
  228.   `UI_IS_LOCK` char(1) CHARACTER SET utf8 DEFAULT 'N' COMMENT '是否锁定，Y：锁定，N：未锁定',
  229.   `UI_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  230.   `UI_MARK` varchar(200) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注信息',
  231.   PRIMARY KEY (`UI_ID`),
  232.   KEY `kl_user_info_UI_OPEN_ID_index` (`UI_OPEN_ID`)
  233. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户基本信息';
  235. -- ----------------------------
  236. -- Table structure for kl_user_like_record
  237. -- ----------------------------
  238. DROP TABLE IF EXISTS `kl_user_like_record`;
  239. CREATE TABLE `kl_user_like_record` (
  240.   `ULR_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  241.   `ULR_USER_ID` varchar(36) DEFAULT NULL COMMENT '用户编号，关联kl_user_info主键',
  242.   `ULR_ARTICLE_ID` varchar(36) DEFAULT NULL COMMENT '文章编号，关联kl_article_info主键',
  243.   `ULR_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  244.   `URL_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  245.   PRIMARY KEY (`ULR_ID`),
  246.   KEY `kl_user_like_record_ULR_ARTICLE_ID_index` (`ULR_ARTICLE_ID`),
  247.   KEY `kl_user_like_record_ULR_USER_ID_index` (`ULR_USER_ID`)
  248. ) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='用户喜欢文章记录';
  250. -- ----------------------------
  251. -- Table structure for kl_user_read_record
  252. -- ----------------------------
  253. DROP TABLE IF EXISTS `kl_user_read_record`;
  254. CREATE TABLE `kl_user_read_record` (
  255.   `URR_ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  256.   `URR_USER_ID` varchar(36) DEFAULT NULL COMMENT '阅读用户编号，关联kl_user_info主键',
  257.   `URR_ARTICLE_ID` varchar(36) DEFAULT NULL COMMENT '文章编号，关联kl_article_info主键',
  258.   `URR_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '阅读时间',
  259.   `URR_MARK` varchar(200) DEFAULT NULL COMMENT '备注信息',
  260.   PRIMARY KEY (`URR_ID`),
  261.   KEY `kl_article_read_record_ARR_ARTICLE_ID_index` (`URR_ARTICLE_ID`),
  262.   KEY `kl_article_read_record_ARR_USER_ID_index` (`URR_USER_ID`)
  263. ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 COMMENT='文章阅读记录';
  265. -- ----------------------------
  266. -- Table structure for oauth_access_token
  267. -- ----------------------------
  268. DROP TABLE IF EXISTS `oauth_access_token`;
  269. CREATE TABLE `oauth_access_token` (
  270.   `token_id` varchar(256) DEFAULT NULL,
  271.   `token` blob,
  272.   `authentication_id` varchar(128) NOT NULL,
  273.   `user_name` varchar(256) DEFAULT NULL,
  274.   `client_id` varchar(256) DEFAULT NULL,
  275.   `authentication` blob,
  276.   `refresh_token` varchar(256) DEFAULT NULL,
  277.   PRIMARY KEY (`authentication_id`)
  278. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  280. -- ----------------------------
  281. -- Table structure for oauth_approvals
  282. -- ----------------------------
  283. DROP TABLE IF EXISTS `oauth_approvals`;
  284. CREATE TABLE `oauth_approvals` (
  285.   `userId` varchar(256) DEFAULT NULL,
  286.   `clientId` varchar(256) DEFAULT NULL,
  287.   `scope` varchar(256) DEFAULT NULL,
  288.   `status` varchar(10) DEFAULT NULL,
  289.   `expiresAt` datetime DEFAULT NULL,
  290.   `lastModifiedAt` datetime DEFAULT NULL
  291. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  293. -- ----------------------------
  294. -- Table structure for oauth_client_details
  295. -- ----------------------------
  296. DROP TABLE IF EXISTS `oauth_client_details`;
  297. CREATE TABLE `oauth_client_details` (
  298.   `client_id` varchar(128) NOT NULL,
  299.   `resource_ids` varchar(256) DEFAULT NULL,
  300.   `client_secret` varchar(256) DEFAULT NULL,
  301.   `scope` varchar(256) DEFAULT NULL,
  302.   `authorized_grant_types` varchar(256) DEFAULT NULL,
  303.   `web_server_redirect_uri` varchar(256) DEFAULT NULL,
  304.   `authorities` varchar(256) DEFAULT NULL,
  305.   `access_token_validity` int(11) DEFAULT NULL,
  306.   `refresh_token_validity` int(11) DEFAULT NULL,
  307.   `additional_information` varchar(4096) DEFAULT NULL,
  308.   `autoapprove` varchar(256) DEFAULT NULL,
  309.   PRIMARY KEY (`client_id`)
  310. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  312. -- ----------------------------
  313. -- Table structure for oauth_client_token
  314. -- ----------------------------
  315. DROP TABLE IF EXISTS `oauth_client_token`;
  316. CREATE TABLE `oauth_client_token` (
  317.   `token_id` varchar(256) DEFAULT NULL,
  318.   `token` blob,
  319.   `authentication_id` varchar(128) NOT NULL,
  320.   `user_name` varchar(256) DEFAULT NULL,
  321.   `client_id` varchar(256) DEFAULT NULL,
  322.   PRIMARY KEY (`authentication_id`)
  323. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  325. -- ----------------------------
  326. -- Table structure for oauth_code
  327. -- ----------------------------
  328. DROP TABLE IF EXISTS `oauth_code`;
  329. CREATE TABLE `oauth_code` (
  330.   `code` varchar(256) DEFAULT NULL,
  331.   `authentication` blob
  332. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  334. -- ----------------------------
  335. -- Table structure for oauth_refresh_token
  336. -- ----------------------------
  337. DROP TABLE IF EXISTS `oauth_refresh_token`;
  338. CREATE TABLE `oauth_refresh_token` (
  339.   `token_id` varchar(256) DEFAULT NULL,
  340.   `token` blob,
  341.   `authentication` blob
  342. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  344. SET FOREIGN_KEY_CHECKS = 1;

源码下载