菱格社区

资料

bilibili视频
Spring 文档
Spring Web
Bootsrtap网站
Bootsrtap 文档
GitHub OAuth 文档
Mybatis 文档
Spring database
bootstrap按钮下拉菜单
thymeleaf文档
Spring拦截器

工具

H2数据库
LomBok支持
spring-boot devtools
JQuery
ApiPost-页面模拟请求插件
JSONEditOnline-在线编辑JSON
CommentJS-js时间格式转换
Markdown编辑器

脚本

-- auto-generated definition
create table USER
(
    ID           INT auto_increment
        primary key,
    ACCOUNT_ID   VARCHAR(100),
    NAME         VARCHAR(50),
    TOKEN        CHAR(36),
    GMT_CREATE   BIGINT,
    GMT_MODIFIED BIGINT,
    BIO          VARCHAR(256),
    AVATAR       VARCHAR(100)
);

-- auto-generated definition
create table DISCUSSION
(
    ID            INT auto_increment
        primary key,
    TITLE         VARCHAR(50),
    DESCRIPTION   TEXT,
    GMT_CREATE    BIGINT,
    GMT_MODIFIED  BIGINT,
    COMMENT_COUNT INT default 0,
    VIEW_COUNT    INT default 0,
    LIKE_COUNT    INT default 0,
    TAG           VARCHAR(256),
    CREATOR       INT
);

-- auto-generated definition
create table COMMENT
(
    ID            INT auto_increment,
    PARENT_ID     INT not null,
    TYPE          INT not null,
    COMMENTATOR   INT,
    GMT_CREATE    BIGINT,
    GMT_MODIFIED  BIGINT,
    LIKE_COUNT    BIGINT default 0,
    CONTENT       VARCHAR(1024),
    COMMENT_COUNT INT    default 0,
    constraint COMMENT_PK
        primary key (ID)
);

-- auto-generated definition
create table NOTIFICATION
(
    ID            INT auto_increment
        primary key,
    NOTIFIER      INT           not null,
    RECEIVER      INT           not null,
    OUTER_ID      INT           not null,
    TYPE          INT           not null,
    GMT_CREATE    BIGINT        not null,
    STATUS        INT default 0 not null,
    NOTIFIER_NAME VARCHAR(50)   not null,
    OUTER_TITLE   VARCHAR(50)   not null
);

mvn flyway:migrate