CREATE DATABASE IF NOT EXISTS `gen` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
USE `gen`;


-- ----------------------------
-- Table structure for datasource_config
-- ----------------------------
DROP TABLE IF EXISTS `datasource_config`;
CREATE TABLE `datasource_config`
(
 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
 `db_type` int(11) NOT NULL DEFAULT 0 COMMENT '数据库类型,1:MySql, 2:Oracle, 3:sqlserver',
 `driver_class` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '数据库驱动',
 `db_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据库名称',
 `host` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据库host',
 `port` int(11) NOT NULL DEFAULT 0 COMMENT '数据库端口',
 `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据库用户名',
 `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据库密码',
 `is_deleted` int(11) NOT NULL DEFAULT 0 COMMENT '是否已删除,1:已删除,0:未删除',
 `package_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
 `del_prefix` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
 `group_id` int(11) NULL DEFAULT NULL,
 `schema_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
 `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
 AUTO_INCREMENT = 1
 CHARACTER SET = utf8
 COLLATE = utf8_general_ci COMMENT = '数据源配置表'
 ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of datasource_config
-- ----------------------------

-- ----------------------------
-- Table structure for generate_history
-- ----------------------------
DROP TABLE IF EXISTS `generate_history`;
CREATE TABLE `generate_history`
(
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `config_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
 `md5_value` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
 `generate_time` datetime NOT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
 AUTO_INCREMENT = 1
 CHARACTER SET = utf8
 COLLATE = utf8_general_ci
 ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of generate_history
-- ----------------------------

-- ----------------------------
-- Table structure for template_config
-- ----------------------------
DROP TABLE IF EXISTS `template_config`;
CREATE TABLE `template_config`
(
 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
 `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '模板名称',
 `folder` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '目录名称',
 `file_name` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件名称',
 `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
 `is_deleted` int(11) NOT NULL DEFAULT 0 COMMENT '是否删除,1:已删除,0:未删除',
 `group_id` int(11) NULL DEFAULT NULL,
 `group_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
 AUTO_INCREMENT = 6
 CHARACTER SET = utf8
 COLLATE = utf8_general_ci COMMENT = '模板表'
 ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of template_config
-- ----------------------------
INSERT INTO `template_config`
VALUES (1, 'entity', '', '${context.javaBeanName}.java',
 'package ${context.packageName}.entity;\n\n#if(${table.hasDateField})\nimport java.util.Date;\n#end\n#if(${table.hasLocalDateField})\nimport java.time.LocalDate;\n#end\n#if(${table.hasLocalDateTimeField})\nimport java.time.LocalDateTime;\n#end\n#if(${table.hasBigDecimalField})\nimport java.math.BigDecimal;\n#end\n\n#if( \"${table.comment}\" != \"\" )\n/**\n * ${table.comment}\n */\n#end\npublic class ${context.javaBeanName} {\n#foreach($column in $columns)\n#if( \"${column.comment}\" != \"\" )\n	/** ${column.comment} */\n#end\n	private ${column.javaTypeBox} ${column.javaFieldName};\n#end\n\n#foreach(${column} in ${columns})\n	public void set${column.javaFieldNameUF}(${column.javaTypeBox} ${column.javaFieldName}) {\n		this.${column.javaFieldName} = ${column.javaFieldName};\n	}\n\n	public ${column.javaTypeBox} get${column.javaFieldNameUF}() {\n		return this.${column.javaFieldName};\n	}\n\n#end\n\n	@Override\n public boolean equals(Object o) {\n if (this == o) { return true; }\n if (o == null || getClass() != o.getClass()) {return false;}\n ${context.javaBeanName} that = (${context.javaBeanName}) o;\n return ${pk.javaFieldName}.equals(that.${pk.javaFieldName});\n }\n\n @Override\n public int hashCode() {\n return java.util.Objects.hash(${pk.javaFieldName});\n }\n\n @Override\n public String toString() {\n return \"${context.javaBeanName}{\" +\n#foreach(${column} in ${columns})\n		#if($velocityCount == 1)\n\"${column.javaFieldName}=\" + ${column.javaFieldName} +\n		#else\n\",${column.javaFieldName}=\'\" + ${column.javaFieldName} + \"\'\" + \n		#end\n#end\n\'}\';\n }\n\n}',
 0, 1, 'default');
INSERT INTO `template_config`
VALUES (2, 'mybatis', '', '${context.javaBeanName}Mapper.xml',
 '#set($jq=\"$\")\n<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\"\"http://mybatis.org/dtd/mybatis-3-mapper.dtd\" >\n<mapper namespace=\"${context.packageName}.mapper.${context.javaBeanName}Mapper\">\n	<resultMap id=\"BaseResultMap\" type=\"${context.packageName}.entity.${context.javaBeanName}\">\n #foreach($column in $columns) \n <result column=\"${column.columnName}\" property=\"${column.javaFieldName}\" />\n	#end\n	</resultMap> \n\n <!-- 表字段 -->\n <sql id=\"baseColumns\">\n #foreach($column in $columns)\n #if($velocityCount > 1),#end t.${column.columnName}\n #end\n </sql> \n\n <!-- 查询全部 -->\n <select id=\"listAll\" resultMap=\"BaseResultMap\">\n		SELECT \n 	<include refid=\"baseColumns\" />\n		FROM ${table.tableName} t\n	</select>\n\n 	<!-- 根据主键获取单条记录 -->\n <select id=\"getById\" resultMap=\"BaseResultMap\" parameterType=\"${pk.javaTypeBox}\">\n		SELECT \n 	<include refid=\"baseColumns\" />\n		FROM ${table.tableName} t\n		WHERE ${pk.columnName} = #{${pk.javaFieldName}}\n	</select>\n\n	<!-- 插入全部字段 -->\n <insert id=\"insert\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\"\n		keyProperty=\"${context.javaPkName}\" keyColumn=\"${context.pkName}\" useGeneratedKeys=\"true\"\n >\n	INSERT INTO ${table.tableName}\n <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">	 \n #foreach($column in $columns) \n 	#if(!${column.isIdentityPk}) \n 	${column.columnName},\n 	#end \n #end\n </trim>\n <trim prefix=\"VALUES (\" suffix=\")\" suffixOverrides=\",\"> \n #foreach($column in $columns) \n 	#if(!${column.isIdentityPk}) \n #{${column.javaFieldName}}, \n 	#end \n #end\n </trim>\n	</insert>\n\n <!-- 插入不为NULL的字段 -->\n <insert id=\"insertIgnoreNull\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\"\n keyProperty=\"${pk.javaFieldName}\" keyColumn=\"${context.pkName}\" useGeneratedKeys=\"true\"\n >\n INSERT INTO ${table.tableName} \n <trim prefix=\"(\" suffix=\")\" suffixOverrides=\",\">	 \n\n #foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n <if test=\"${column.javaFieldName} != null\">\n ${column.columnName},\n </if>\n #end \n #end\n </trim>\n <trim prefix=\"VALUES (\" suffix=\")\" suffixOverrides=\",\"> \n #foreach($column in $columns) \n #if(!${column.isIdentityPk}) \n <if test=\"${column.javaFieldName} != null\" >\n #{${column.javaFieldName}}, \n </if>\n #end \n #end\n </trim>\n </insert>\n\n	<!-- 更新,更新全部字段 -->\n <update id=\"update\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\n UPDATE ${table.tableName}\n <set>		\n #foreach($column in $columns) \n #if(!${column.isPk}) \n ${column.columnName}=#{${column.javaFieldName}}, \n #end \n #end\n </set>	\n WHERE ${pk.columnName} = #{${pk.javaFieldName}}\n </update> \n\n\n <!-- 更新不为NULL的字段 -->\n <update id=\"updateIgnoreNull\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\n UPDATE ${table.tableName}\n <set>\n 	#foreach($column in $columns) \n #if(!${column.isPk}) \n <if test=\"${column.javaFieldName} != null\" >\n ${column.columnName}=#{${column.javaFieldName}}, \n </if>\n #end \n #end\n </set>\n WHERE ${pk.columnName} = #{${pk.javaFieldName}}\n </update>\n\n\n	<!-- 根据主键删除记录 -->\n	<delete id=\"delete\" parameterType=\"${context.packageName}.entity.${context.javaBeanName}\">\n		UPDATE ${table.tableName}\n		SET is_deleted=1\n		WHERE ${pk.columnName} = #{${pk.javaFieldName}}\n	</delete>\n\n\n</mapper>',
 0, 1, 'default');
INSERT INTO `template_config`
VALUES (3, 'dao', '', '${context.javaBeanName}Mapper.java',
 'package ${context.packageName}.mapper;\n\nimport java.util.List;\nimport org.apache.ibatis.annotations.Mapper;\nimport ${context.packageName}.entity.${context.javaBeanName};\n\n@Mapper\npublic interface ${context.javaBeanName}Mapper {\n\n	/**\n * 查询所有记录\n *\n * @return 返回集合,没有返回空List\n */\n	List<${context.javaBeanName}> listAll();\n\n\n	/**\n * 根据主键查询\n *\n * @param id 主键\n * @return 返回记录,没有返回null\n */\n	${context.javaBeanName} getById(${pk.javaTypeBox} ${pk.javaFieldName});\n\n	/**\n * 新增,插入所有字段\n *\n * @param ${context.javaBeanNameLF} 新增的记录\n * @return 返回影响行数\n */\n	int insert(${context.javaBeanName} ${context.javaBeanNameLF});\n\n	/**\n * 新增,忽略null字段\n *\n * @param ${context.javaBeanNameLF} 新增的记录\n * @return 返回影响行数\n */\n	int insertIgnoreNull(${context.javaBeanName} ${context.javaBeanNameLF});\n\n	/**\n * 修改,修改所有字段\n *\n * @param ${context.javaBeanNameLF} 修改的记录\n * @return 返回影响行数\n */\n	int update(${context.javaBeanName} ${context.javaBeanNameLF});\n\n	/**\n * 修改,忽略null字段\n *\n * @param ${context.javaBeanNameLF} 修改的记录\n * @return 返回影响行数\n */\n	int updateIgnoreNull(${context.javaBeanName} ${context.javaBeanNameLF});\n\n	/**\n * 删除记录\n *\n * @param ${context.javaBeanNameLF} 待删除的记录\n * @return 返回影响行数\n */\n	int delete(${context.javaBeanName} ${context.javaBeanNameLF});\n\n}',
 0, 1, 'default');
INSERT INTO `template_config`
VALUES (4, 'service', '', '${context.javaBeanName}Service',
 'package ${context.packageName}.mapper;\n\nimport ${context.packageName}.entity.${context.javaBeanName};\nimport ${context.packageName}.mapper.${context.javaBeanName}Mapper;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.stereotype.Service;\n\nimport java.util.List;\n\n@Service\npublic class ${context.javaBeanName}Service {\n\n @Autowired\n private ${context.javaBeanName}Mapper ${context.javaBeanNameLF}Mapper;\n\n /**\n * 查询所有记录\n *\n * @return 返回集合,没有返回空List\n */\n public List<${context.javaBeanName}> listAll() {\n 	return ${context.javaBeanNameLF}Mapper.listAll();\n }\n\n\n /**\n * 根据主键查询\n *\n * @param id 主键\n * @return 返回记录,没有返回null\n */\n public ${context.javaBeanName} getById(${pk.javaTypeBox} ${pk.javaFieldName}) {\n 	return ${context.javaBeanNameLF}Mapper.getById(${pk.javaFieldName});\n }\n\n /**\n * 新增,插入所有字段\n *\n * @param ${context.javaBeanNameLF} 新增的记录\n * @return 返回影响行数\n */\n public int insert(${context.javaBeanName} ${context.javaBeanNameLF}) {\n 	return ${context.javaBeanNameLF}Mapper.insert(${context.javaBeanNameLF});\n }\n\n /**\n * 新增,忽略null字段\n *\n * @param ${context.javaBeanNameLF} 新增的记录\n * @return 返回影响行数\n */\n public int insertIgnoreNull(${context.javaBeanName} ${context.javaBeanNameLF}) {\n 	return ${context.javaBeanNameLF}Mapper.insertIgnoreNull(${context.javaBeanNameLF});\n }\n\n /**\n * 修改,修改所有字段\n *\n * @param ${context.javaBeanNameLF} 修改的记录\n * @return 返回影响行数\n */\n public int update(${context.javaBeanName} ${context.javaBeanNameLF}) {\n 	return ${context.javaBeanNameLF}Mapper.update(${context.javaBeanNameLF});\n }\n\n /**\n * 修改,忽略null字段\n *\n * @param ${context.javaBeanNameLF} 修改的记录\n * @return 返回影响行数\n */\n public int updateIgnoreNull(${context.javaBeanName} ${context.javaBeanNameLF}) {\n 	return ${context.javaBeanNameLF}Mapper.updateIgnoreNull(${context.javaBeanNameLF});\n }\n\n /**\n * 删除记录\n *\n * @param ${context.javaBeanNameLF} 待删除的记录\n * @return 返回影响行数\n */\n public int delete(${context.javaBeanName} ${context.javaBeanNameLF}) {\n 	return ${context.javaBeanNameLF}Mapper.delete(${context.javaBeanNameLF});\n }\n\n}',
 0, 1, 'default');
INSERT INTO `template_config`
VALUES (5, 'controller', '', '${context.javaBeanName}Controller',
 'package ${context.packageName}.mapper;\n\nimport java.util.List;\nimport org.springframework.beans.factory.annotation.Autowired;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.bind.annotation.RequestBody;\nimport org.springframework.web.bind.annotation.RestController;\n\nimport ${context.packageName}.entity.${context.javaBeanName};\nimport ${context.packageName}.service.${context.javaBeanName}Service;\n\n@RestController\npublic class ${context.javaBeanName}Controller {\n\n @Autowired\n private ${context.javaBeanName}Service ${context.javaBeanNameLF}Service;\n\n /**\n * 查询所有记录\n *\n * @return 返回集合,没有返回空List\n */\n @RequestMapping(\"list\")\n public List<${context.javaBeanName}> listAll() {\n return ${context.javaBeanNameLF}Service.listAll();\n }\n\n\n /**\n * 根据主键查询\n *\n * @param id 主键\n * @return 返回记录,没有返回null\n */\n @RequestMapping(\"getById\")\n public ${context.javaBeanName} getById(${pk.javaTypeBox} ${pk.javaFieldName}) {\n return ${context.javaBeanNameLF}Service.getById(${pk.javaFieldName});\n }\n\n /**\n * 新增,插入所有字段\n *\n * @param ${context.javaBeanNameLF} 新增的记录\n * @return 返回影响行数\n */\n @RequestMapping(\"insert\")\n public int insert(@RequestBody ${context.javaBeanName} ${context.javaBeanNameLF}) {\n return ${context.javaBeanNameLF}Service.insert(${context.javaBeanNameLF});\n }\n\n /**\n * 新增,忽略null字段\n *\n * @param ${context.javaBeanNameLF} 新增的记录\n * @return 返回影响行数\n */\n @RequestMapping(\"insert\")\n public int insertIgnoreNull(@RequestBody ${context.javaBeanName} ${context.javaBeanNameLF}) {\n return ${context.javaBeanNameLF}Service.insertIgnoreNull(${context.javaBeanNameLF});\n }\n\n /**\n * 修改,修改所有字段\n *\n * @param ${context.javaBeanNameLF} 修改的记录\n * @return 返回影响行数\n */\n @RequestMapping(\"update\")\n public int update(@RequestBody ${context.javaBeanName} ${context.javaBeanNameLF}) {\n return ${context.javaBeanNameLF}Service.update(${context.javaBeanNameLF});\n }\n\n /**\n * 修改,忽略null字段\n *\n * @param ${context.javaBeanNameLF} 修改的记录\n * @return 返回影响行数\n */\n @RequestMapping(\"updateIgnoreNull\")\n public int updateIgnoreNull(@RequestBody ${context.javaBeanName} ${context.javaBeanNameLF}) {\n return ${context.javaBeanNameLF}Service.updateIgnoreNull(${context.javaBeanNameLF});\n }\n\n /**\n * 删除记录\n *\n * @param ${context.javaBeanNameLF} 待删除的记录\n * @return 返回影响行数\n */\n @RequestMapping(\"delete\")\n public int delete(@RequestBody ${context.javaBeanName} ${context.javaBeanNameLF}) {\n return ${context.javaBeanNameLF}Service.delete(${context.javaBeanNameLF});\n }\n\n}',
 0, 1, 'default');

-- ----------------------------
-- Table structure for template_group
-- ----------------------------
DROP TABLE IF EXISTS `template_group`;
CREATE TABLE `template_group`
(
 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
 `group_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模板组名称',
 `is_deleted` int(11) NULL DEFAULT 0 COMMENT '是否删除,1:已删除,0:未删除',
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
 AUTO_INCREMENT = 2
 CHARACTER SET = utf8
 COLLATE = utf8_general_ci COMMENT = '模板组表'
 ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of template_group
-- ----------------------------
INSERT INTO `template_group`
VALUES (1, 'default', 0);