MySQL用户权限角色数据库设计(猿狂想)

SQL语句：

use hmdb;

create table Authority(

authorityID smallint unsigned primary key auto_increment, name varchar(24) not null unique,

remark varchar(200)

);

create table Role(

roleID smallint unsigned primary key auto_increment,

name varchar(24) not null unique,

remark varchar(200)

);

create table RoleAuthority(

roleID smallint unsigned,

authorityID smallint unsigned,

primary key(roleID,authorityID),

foreign key(roleID) references Role(roleID),

foreign key(authorityID) references Authority(authorityID) );

create table User(

userID smallint unsigned primary key auto_increment,

name varchar(24) not null unique,

password char(20) not null,

createTime datetime not null,

creatorID smallint unsigned,

remark varchar(200),

foreign key(creatorID) references user(userID)

);

create table UserRole(

userID smallint unsigned,

roleID smallint unsigned,

primary key(userID,roleID),

foreign key(userID) references User(userID),

foreign key(roleID) references Role(roleID)

);