设计一个千人千面的权限系统，我只用了10分钟

-- 建库
create database scaffold;
use scaffold;

-- 创建资源表，页面部分
CREATE TABLE resource (
id int not null primary key auto_increment,
resourcename varchar(64)  COMMENT '资源名称',
resourceurl varchar(64) COMMENT '资源路径h5',
content varchar(128) COMMENT '资源描述',
flag varchar(64) COMMENT '其他标志'
)ENGINE=InnoDB;

-- 菜单表
CREATE TABLE tmenu (
id int not null primary key auto_increment,
mununame varchar(64) NOT NULL COMMENT '菜单名称',
content varchar(128) COMMENT '菜单描述',
flag varchar(64) COMMENT '标志'
)ENGINE=InnoDB;

-- 菜单与资源的关系表
CREATE TABLE menu_resource (
id int not null primary key auto_increment,
menusid int COMMENT '菜单id',
resourcesid int COMMENT '资源id',
CONSTRAINT m_tmenu FOREIGN KEY (menusid) REFERENCES tmenu (id) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT m_resources FOREIGN KEY (resourcesid) REFERENCES resource (id) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=InnoDB;

-- 角色表
CREATE TABLE role (
id int NOT NULL PRIMARY KEY auto_increment,
rolename varchar(64) COMMENT '角色名称',
menuid varchar(64) COMMENT '菜单id',
content varchar(128) COMMENT '内容描述',
flag varchar(64) COMMENT '标志'
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 角色菜单表
CREATE TABLE role_menu (
id int not null primary key auto_increment,
roid int COMMENT '角色id',
tmid int COMMENT '菜单id',
CONSTRAINT role_r_tm FOREIGN KEY (roid) REFERENCES role (id) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT role_tm1 FOREIGN KEY (tmid) REFERENCES tmenu (id) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 用户表
CREATE TABLE user (
id int primary key not null auto_increment,
loginid varchar(128) NOT NULL COMMENT '用户登录号，手机号',
username varchar(64) not null COMMENT '用户名称',
userpassword varchar(64) not null COMMENT '用户密码',
useremil varchar(64) COMMENT '用户电子邮箱',
roid int not null COMMENT '用户权限标志',
CONSTRAINT user_role FOREIGN KEY (roid) REFERENCES role (id) ON DELETE CASCADE ON UPDATE CASCADE
)ENGINE=InnoDB DEFAULT CHARSET=utf8;