Untitled

drop table if exists `user`;
create table `user`
(
    user_id          int auto_increment primary key,
    user_account     varchar(250) CHARACTER SET utf8mb4 not null,
    user_password    varchar(100) CHARACTER SET utf8mb4 not null,
    user_create_time varchar(20)                        not null,
    user_deleted     tinyint(1) not null
);

drop table if exists `role`;
create table role
(
    role_id   int auto_increment primary key,
    role_name varchar(20) CHARACTER SET utf8mb4 not null
);

drop table if exists `user_role`;
create table user_role
(
    user_role_id int auto_increment primary key,
    user_id      int not null,
    role_id      int not null
);