##majiang community

##resources spring docs spring web docs spring elastic community [github deploy key]https://developer.github.com/v3/guides/managing-deploy-keys/#deploy-key app auth Mybatis Spring boot docs Thyleaf

##tools https://git-scm.com/download https://v3.bootcss.com https://www.visual-paradigm.com flyway https://flywaydb.org/getstarted/ #自动注入getter setter toString() Data https://projectlombok.org/features/all mvn command: mvn -Dmaven.wagon.http.ssl.insecure=true clean package

##script -- create database community; DROP TABLE IF EXISTS community.user； CREATE TABLE community.user ( id INT AUTO_INCREMENT PRIMARY KEY, account_id VARCHAR(100), name VARCHAR(50), token CHAR(36), gmt_create BIGINT, gmt_modified BIGINT ) ENGINE = InnoDB ROW_FORMAT = DEFAULT; .. ..bash ALTER TABLE user ADD bio VARCHAR(256) NULL;

DROP TABLE IF EXISTS community.question； CREATE TABLE community.question ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(50), description TEXT, gmt_create BIGINT, gmt_modified BIGINT, creator INT, comment_count INT DEFAULT 0, view_count INT DEFAULT 0, like_count INT DEFAULT 0, tag VARCHAR(256) ) ENGINE = InnoDB ROW_FORMAT = DEFAULT;