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;