易语言mysql菜单权限分配_多角色、多菜单、多功能权限管理数据库设计

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,

C