php auth 认证原理,auth: thinkphp5.1权限认证类。 - 木兰确实
-- ----------------------------
-- Table structure for wdl_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `wdl_auth_group`;
CREATE TABLE `wdl_auth_group` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '分组名称',
`rules` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '拥有的权限，使用逗号分隔',
`create_time` int(11) NOT NULL DEFAULT '0',
`update_time` int(11) NOT NULL DEFAULT '0',
`delete_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for wdl_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `wdl_auth_group_access`;
CREATE TABLE `wdl_auth_group_access` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT NULL COMMENT '用户ID',
`group_id` int(11) DEFAULT NULL COMMENT '分组ID',
`create_time` int(11) NOT NULL DEFAULT '0',
`update_time` int(11) NOT NULL DEFAULT '0',
`delete_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-- ----------------------------
-- Table structure for wdl_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `wdl_auth_rule`;
CREATE TABLE `wdl_auth_rule` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(11) DEFAULT '0' COMMENT '上级ID',
`name` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '权限规则',
`title` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '规则中文名',
`icon` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '菜单图标',
`sort` int(11) DEFAULT '9' COMMENT '排序',
`is_show` int(11) DEFAULT '1' COMMENT '1显示；0隐藏',
`create_time` int(11) NOT NULL DEFAULT '0',
`update_time` int(11) NOT NULL DEFAULT '0',
`delete_time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;