以模块设定用户权限 数据结构

CREATE TABLE `pre_wukong_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '角色名',
  `descr` varchar(255) DEFAULT NULL COMMENT '角色描述',
  `created_at` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
)  COMMENT='角色表'


CREATE TABLE `pre_wukong_role_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(11) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `role_id` (`role_id`,`name`) USING BTREE
)  COMMENT='角色权限表'


CREATE TABLE `role_params` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL,
  `ability_name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `role_id` (`role_id`,`ability_name`) USING BTREE
)  COMMENT='角色参数表'