create table sys_user
(
    id                  varchar(20)                            not null comment '用户id'
        primary key,
    su_username         char(18)                               not null comment '用户名',
    su_password         varchar(200)                           not null comment '密码',
    su_avatar           varchar(255) default ''                not null comment '头像',
    su_name             char(20)                               null comment '用户名',
    su_phone            varchar(20)  default ''                not null comment '电话',
    su_email            varchar(30)  default ''                not null comment '邮箱',
    su_gender           tinyint(1)   default 0                 not null comment '性别0女1男',
    su_birth            date                                   not null comment '出生日期',
    su_enable           tinyint(1)   default 1                 not null comment '是否启用',
    su_expired          tinyint(1)   default 1                 not null comment '是否有效',
    create_date         datetime     default CURRENT_TIMESTAMP not null comment '创建时间',
    su_password_expired tinyint(1)   default 1                 not null comment '密码是否有效',
    su_locked           tinyint(1)   default 1                 not null comment '是否未锁定',
    update_date         datetime                               null comment '更新时间',
    delete_date         datetime                               null comment '删除时间',
    deleted             tinyint(1)   default 0                 null comment '0未删除1已删除',
    constraint phone
        unique (su_username) comment '手机号唯一索引'
)
    comment '用户信息';

INSERT INTO sys_user (id, su_username, su_password, su_avatar, su_name, su_phone, su_email, su_gender, su_birth,
                      su_enable, su_expired, create_date, su_password_expired, su_locked, update_date, delete_date,
                      deleted)
VALUES ('1', 'admin', '{bcrypt}$2a$10$Va.bp9b2QJRikHuFhlpa7uZfHrtz6NRy8RJdH2CAMUKdrYXKueb5W',
        'https://fuss10.elemecdn.com/3/63/4e7f3a15429bfda99bce42a18cdd1jpeg.jpeg', 'sweetBaby', '', '', 0, '1997-05-12',
        1, 1, '2020-05-06 13:00:31', 1, 1, '2020-05-06 13:01:25', null, 0);