FCB社区

资料

Spring
Spring web
Spring boot
ES社区
[Github Deploy Key](https://developer.github.com/v3/guides/managing-depgeneratorConfig.xml集成Mybatis Generatorloy-keys/#deploy-keys)
Bootstrap
Github OAuth
菜鸟教程
Thymeleaf
Mybatis Spring Dev Tool
Spring MVC
Markdown 插件
UFfile SDK
Count(*) VS Count(1)

工具

Git
Visual Paradigm
Flyway
Lombok
ctotree
Table of content sidebar
One Tab
Live Reload json在线解析工具
Postman

脚本

create table USER
(
	ID INTEGER auto_increment,
	ACCOUNT_ID VARCHAR(100),
	NAME VARCHAR(50),
	TOKEN CHAR(36),
	GMT_CREATE BIGINT,
	GMT_MODIFIED BIGINT,
	BIO VARCHAR(256),
	AVATAR_URL VARCHAR(100),
	constraint USER_PK
		primary key (ID)
);

create table QUESTION
(
	ID INTEGER auto_increment,
	TITLE VARCHAR(50),
	DESCRIPTION CLOB,
	GMT_CREATE BIGINT,
	GMT_MODIFIED BIGINT,
	CREATOR INTEGER,
	COMMENT_COUNT INTEGER default 0,
	VIEW_COUNT INTEGER default 0,
	LIKE_COUNT INTEGER default 0,
	TAG VARCHAR(256),
	constraint QUESTION_PK
		primary key (ID)
);

数据库结构版本控制
mvn flyway:migrate
使用MGB生成mapper、xml和model
mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate