phone varchar(50) default null comment '电话',7
status tinyint default null comment '状态,1启用，0禁用',8
avatar varchar(255) default null comment '头像',9
is_deleted tinyint default 0 comment '是否删除，1删除，0正常'10
) comment '用户表';11
insert into aj_user values(1,'admin','1234','xx@xx.com','13899008801',1,'',0);12
13
drop table if exists aj_role;14
create table aj_role(15
id int not null auto_increment primary key comment '主键id',16
role_name varchar(50) not null unique comment '角色名称',17
role_desc varchar(100) default null comment '描述',18
is_deleted tinyint default 0 comment '是否删除，1删除，0正常'19
) comment '角色表';20
insert into aj_role values(1,'admin','超级管理员',0);21
insert into aj_role values(2,'hr','人事专员',0);22
insert into aj_role values(3,'normal','普通员工',0);23
24
drop table if exists aj_user_role;25
create table aj_user_role(26
id int not null auto_increment primary key comment '主键id',27
user_id int not null comment '用户id',28
role_id int not null comment '角色id'29
) comment '用户角色关系表';30
insert into aj_user_role values (1,1,1);31
32
drop table if exists aj_role_menu;33
create table aj_role_menu(34
id int not null auto_increment primary key comment '主键id',35
role_id int not null comment '角色id',36
menu_id int not null comment '菜单id'37
) comment '角色菜单表';38
insert into aj_role_menu values (1,1,1);39
insert into aj_role_menu values (2,1,2);40
insert into aj_role_menu values (3,1,3);41
insert into aj_role_menu values (4,1,4);42
insert into aj_role_menu values (5,1,5);43
insert into aj_role_menu values (6,1,6);44
insert into aj_role_menu values (7,1,7);45
46
