create table user
(
    id        int auto_increment comment 'primary id',
    username  varchar(120)         not null comment 'username',
    password  varchar(64)          null comment 'password',
    note      varchar(255)         null,
    nick_name varchar(120)         null comment 'nickName',
    status    tinyint(1) default 1 null comment '1:enable 2:disable',
    create_at timestamp            null,
    update_at timestamp            null,
    delete_at timestamp            null,
    primary key (id, username)
)
    charset = utf8mb4;

create table casbin_rule
(
    ptype varchar(10)  null,
    v0    varchar(256) null,
    v1    varchar(256) null,
    v2    varchar(256) null,
    v3    varchar(256) null,
    v4    varchar(256) null,
    v5    varchar(256) null
);

create table router
(
    id        int auto_increment
        primary key,
    path      varchar(20)  null,
    name      varchar(20)  null,
    redirect  varchar(50)  null,
    title     varchar(30)  null,
    icon      varchar(100) null,
    component varchar(100) null,
    parent    int          null,
    orderNo   int          null,
    status    tinyint(1)   null,
    create_at timestamp    null,
    update_at timestamp    null,
    delete_at timestamp    null
);