基于Spring Boot + Mybatis + Mybatis Plus搭建的快速开发平台

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50719 Source Host : localhost Source Database : ifast-new2 Target Server Type : MySQL Target Server Version : 50719 File Encoding : utf-8 Date: 04/26/2019 11:52:47 AM */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `app_demo_base` -- ---------------------------- DROP TABLE IF EXISTS `app_demo_base`; CREATE TABLE `app_demo_base` ( `id` bigint(20) NOT NULL COMMENT '编号', `title` varchar(50) DEFAULT NULL COMMENT '标题', `publish` datetime DEFAULT NULL COMMENT '发布时间', `content` mediumtext COMMENT '正文', `deleted` bit(1) DEFAULT b'0' COMMENT '删除', `version` smallint(6) DEFAULT '0' COMMENT '版本', `createAt` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updateAt` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `createBy` bigint(20) DEFAULT NULL COMMENT '创建者', `updateBy` bigint(20) DEFAULT NULL COMMENT '更新者', `price` decimal(10,0) DEFAULT NULL, `depId` bigint(20) DEFAULT NULL, `comId` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='基础表'; -- ---------------------------- -- Records of `app_demo_base` -- ---------------------------- BEGIN; INSERT INTO `app_demo_base` VALUES ('1', '1', null, null, b'0', '0', '2018-10-17 11:17:46', '2018-10-17 11:17:53', null, null, null, null, null), ('2', '1', null, null, b'0', '0', '2018-10-17 11:17:41', '2018-10-17 11:17:52', null, null, null, null, null), ('3', '1', null, null, b'0', '0', '2018-10-17 11:17:37', '2018-10-17 11:43:54', null, null, null, null, null), ('1027118616500408321', 'Vue 2.0 Hello World', '2018-08-17 11:59:00', '这是我的征文', b'0', '6', '2018-08-08 17:05:35', '2018-10-17 11:17:26', '1', '1', null, null, null), ('1052420200646021122', '1', null, '111', b'0', '0', '2018-10-17 12:45:03', null, '1', null, '1', null, null), ('1052420972653789185', '111', null, '111', b'0', '0', '2018-10-17 12:48:07', null, '1', null, '111', null, null), ('1052421314086916098', '111', null, '111', b'0', '0', '2018-10-17 12:49:28', null, '1', null, '111', null, null), ('1052426738131517442', '111', null, '111', b'0', '0', '2018-10-17 13:11:07', null, '1', null, '111', null, null), ('1052427222917562369', '111', null, '111', b'0', '0', '2018-10-17 13:16:07', null, '1', null, '111', null, null), ('1052432268677824514', '111', null, '111', b'0', '0', '2018-10-17 13:36:43', null, '1', null, '111', null, null), ('1052433480089288706', '111', null, '111', b'0', '0', '2018-10-17 13:39:47', null, '1', null, '111', null, null), ('1052434025671770113', '111', null, '111', b'0', '0', '2018-10-17 13:40:39', null, '1', null, '111', null, null), ('1052434394850213889', '111', null, '111', b'0', '0', '2018-10-17 13:41:28', null, '1', null, '111', null, null), ('1052434507010097154', '111', null, '111', b'0', '0', '2018-10-17 13:43:08', null, '1', null, '111', null, null), ('1052434874858946562', '111', null, '111', b'0', '0', '2018-10-17 13:44:13', null, '1', null, '111', null, null), ('1052435150282113025', '111', null, '111', b'0', '0', '2018-10-17 13:45:14', null, '1', null, '111', null, null), ('1052435458504736769', '111', null, '111', b'0', '0', '2018-10-17 14:21:15', null, '1', null, '111', null, null), ('1052444652096143361', '111', null, '111', b'0', '0', '2018-10-17 14:23:32', null, '1', null, '111', null, null), ('1052446925337604097', '222', null, '222', b'0', '0', '2018-10-17 14:31:18', null, '1', null, '222', '333', null), ('1052447918909517826', '222', null, '222', b'0', '0', '2018-10-17 14:35:12', null, '1', null, '222', '333', '1'), ('1052450947981316098', '222', null, '222', b'0', '0', '2018-10-17 14:47:14', null, '1', null, '222', null, '1'), ('1052451128940367874', '222', null, '222', b'0', '0', '2018-10-17 14:47:57', null, '2', null, '222', null, '2'), ('1052451480536289281', '222', null, '222', b'0', '0', '2018-10-17 14:49:36', null, '2', null, '222', null, '2'), ('1052451612082245633', '222', null, '222', b'0', '0', '2018-10-17 14:50:20', null, '1', null, '222', null, '1'), ('1052451973799018497', '222', null, '222', b'0', '0', '2018-10-17 14:51:25', null, '1', null, '222', null, '1000'); COMMIT; -- ---------------------------- -- Table structure for `app_demo_base_copy` -- ---------------------------- DROP TABLE IF EXISTS `app_demo_base_copy`; CREATE TABLE `app_demo_base_copy` ( `id` bigint(20) NOT NULL COMMENT '编号', `title` varchar(50) DEFAULT NULL COMMENT '标题', `publish` datetime DEFAULT NULL COMMENT '发布时间', `content` mediumtext COMMENT '正文', `deleted` bit(1) DEFAULT b'0' COMMENT '删除', `version` smallint(6) DEFAULT '0' COMMENT '版本', `createAt` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `updateAt` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `createBy` bigint(20) DEFAULT NULL COMMENT '创建者', `updateBy` bigint(20) DEFAULT NULL COMMENT '更新者', `price` decimal(10,0) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='基础表'; -- ---------------------------- -- Records of `app_demo_base_copy` -- ---------------------------- BEGIN; INSERT INTO `app_demo_base_copy` VALUES ('1027118616500408321', 'Vue 2.0 Hello World', '2018-08-17 11:59:00', '这是我的征文', b'0', '7', '2018-08-08 17:05:35', '2018-08-22 15:34:46', '1', '1', null); COMMIT; -- ---------------------------- -- Table structure for `sys_config` -- ---------------------------- DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `k` varchar(100) DEFAULT NULL COMMENT '键', `v` varchar(1000) DEFAULT NULL COMMENT '值', `remark` varchar(100) DEFAULT NULL COMMENT '备注', `createTime` datetime DEFAULT NULL COMMENT '创建时间', `kvType` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1057172473553002499 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of `sys_config` -- ---------------------------- BEGIN; INSERT INTO `sys_config` VALUES ('2', 'oss_qiniu', '{\"AccessKey\" : \"8-HMj9EgGNIP-xuOCpSzTn-OMyGOFtR3TxLdn4Uu\",\"SecretKey\" : \"SjpGg3V6PsMdJgn42PeEd5Ik-6aNyuwdqV5CPM6A\",\"bucket\" : \"ifast\",\"AccessUrl\" : \"http://p6r7ke2jc.bkt.clouddn.com/\"}', '七牛对象存储配置', '2018-04-06 14:31:26', '4300'), ('3', 'author', 'Aron', '代码生成器配置', '2018-05-27 19:57:04', '4401'), ('4', 'email', 'izenglong@163.com', '代码生成器配置', '2018-05-27 19:57:04', '4401'), ('5', 'package', 'com.ifast.wxmp', '代码生成器配置', '2018-05-27 19:57:04', '4401'), ('6', 'autoRemovePre', 'true', '代码生成器配置', '2018-05-27 19:57:04', '4401'), ('7', 'tablePrefix', 'app', '代码生成器配置', '2018-05-27 19:57:04', '4401'), ('8', 'tinyint', 'Integer', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('9', 'smallint', 'Integer', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('10', 'mediumint', 'Integer', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('11', 'int', 'Integer', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('12', 'integer', 'Integer', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('13', 'bigint', 'Long', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('14', 'float', 'Float', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('15', 'double', 'Double', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('16', 'decimal', 'BigDecimal', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('17', 'bit', 'Boolean', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('18', 'char', 'String', '代码生成器配置', '2018-05-27 19:57:04', '4400'), ('19', 'varchar', 'String', '代码生成器配置', '2018-05-27 19