seecoder-devcloud/web/src/main/resources/SQLscripts/user.sql

create table if not exists devcloud.user
(
    id         int                                 not null
        primary key,
    username   varchar(23)                         not null,
    nickname   varchar(23)                         null,
    password   char(64)                            not null,
    phone      varchar(23)                         null,
    email      varchar(63)                         not null,
    role       varchar(15) charset utf8            null,
    created_at timestamp default CURRENT_TIMESTAMP null,
    namespace  int                                 null,
    token      varchar(63)                         not null
);