WebProject/java/target/classes/sql/project.sql

drop table  if exists user;
create table user
(
    uid             bigint unsigned auto_increment comment '用户id'
        primary key,
    username        varchar(255) collate utf8mb4_general_ci             null comment '用户账户(跟accout一样)',
    password        varchar(255)                                        null comment '用户密码（跟pwd）',
    real_name       varchar(25) collate utf8mb4_general_ci default ''   null comment '真实姓名',
    birthday        DATE                                    default null    null comment '生日',
    card_id         varchar(20)                            default ''   null comment '身份证号码',
    mark            varchar(255)                           default ''   null comment '用户备注',
    group_id        int                                    default 0    null comment '用户分组id',
    nickname        varchar(100) collate utf8mb4_general_ci             null comment '用户昵称',
    avatar          varchar(256)                                        null comment '用户头像',
    phone           char(15)                                            null comment '手机号码',
    add_ip          varchar(100)                           default ''   null comment '添加ip',
    create_time     datetime                                            null comment '添加时间',
    update_time     datetime                                            null comment '最后一次登录时间',
    last_ip         varchar(100)                           default ''   null comment '最后一次登录ip',
    status          tinyint(1)                             default 1    not null comment '1为正常，0为禁止',
    level           tinyint unsigned                       default '0'  not null comment '等级',
    spread_count    int                                    default 0    null comment '下级人数',
    address          varchar(255)                           default ''   not null comment '详细地址',
    login_type      varchar(36)                            default ''   not null comment '用户登陆类型，h5,wechat,routine',
    is_del          tinyint(1)                             default 0    null,
    constraint username
        unique (username)
)
    comment '用户表';

create index level
    on user (level);

create index status
    on user (status);