use rbac;

create table user
(
	user_id int primary key auto_increment,
	dept_id int,
	username varchar(40),
	password varchar(40),
	photo varchar(200)
);



create table role
(
	role_id int primary key auto_increment,
	role_name varchar(40)
);

create table permission
(
	permission_id int primary key auto_increment,
	permission_name varchar(40),
	parent_id int
);



create table user_role
(
	user_id int,
	role_id int
);

create table role_permission
(
	role_id int,
	permission_id int
);

insert into permission values(-1, 'root', null);
insert into user values(null, null, 'foo', '123', null);

select * from permission;