首页 > 代码库 > ThinkPHP权限认证表设计

ThinkPHP权限认证表设计

-- ----------------------------
-- Table structure for think_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `think_auth_group`;
CREATE TABLE `think_auth_group` (
 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 `title` char(100) NOT NULL DEFAULT ‘‘,
 `status` tinyint(1) NOT NULL DEFAULT ‘1‘,
 `rules` char(80) NOT NULL DEFAULT ‘‘,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=‘用户组表‘;
 
-- ----------------------------
-- Records of think_auth_group
-- ----------------------------
INSERT INTO `think_auth_group` VALUES (‘1‘, ‘管理组‘, ‘1‘, ‘1,2‘);
 
-- ----------------------------
-- Table structure for think_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `think_auth_group_access`;
CREATE TABLE `think_auth_group_access` (
 `uid` mediumint(8) unsigned NOT NULL COMMENT ‘用户id‘,
 `group_id` mediumint(8) unsigned NOT NULL COMMENT ‘用户组id‘,
 UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
 KEY `uid` (`uid`),
 KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT=‘用户组明细表‘;
 
-- ----------------------------
-- Records of think_auth_group_access
-- ----------------------------
INSERT INTO `think_auth_group_access` VALUES (‘1‘, ‘1‘);
INSERT INTO `think_auth_group_access` VALUES (‘1‘, ‘2‘);
 
-- ----------------------------
-- Table structure for think_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `think_auth_rule`;
CREATE TABLE `think_auth_rule` (
 `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 `name` char(80) NOT NULL DEFAULT ‘‘ COMMENT ‘规则唯一标识‘,
 `title` char(20) NOT NULL DEFAULT ‘‘ COMMENT ‘规则中文名称‘,
 `status` tinyint(1) NOT NULL DEFAULT ‘1‘ COMMENT ‘状态:为1正常,为0禁用‘,
 `type` char(80) NOT NULL,
 `condition` char(100) NOT NULL DEFAULT ‘‘ COMMENT ‘规则表达式,为空表示存在就验证,不为空表示按照条件验证‘,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT=‘规则表‘;
 
-- ----------------------------
-- Records of think_auth_rule
-- ----------------------------
INSERT INTO `think_auth_rule` VALUES (‘1‘, ‘Home/index‘, ‘列表‘, ‘1‘, ‘Home‘, ‘‘);
INSERT INTO `think_auth_rule` VALUES (‘2‘, ‘Home/add‘, ‘添加‘, ‘1‘, ‘Home‘, ‘‘);
INSERT INTO `think_auth_rule` VALUES (‘3‘, ‘Home/edit‘, ‘编辑‘, ‘1‘, ‘Home‘, ‘‘);
INSERT INTO `think_auth_rule` VALUES (‘4‘, ‘Home/delete‘, ‘删除‘, ‘1‘, ‘Home‘, ‘‘);
 
 
DROP TABLE IF EXISTS `think_user`;
CREATE TABLE `think_user` (
 `id` int(11) NOT NULL,
 `username` varchar(30) DEFAULT NULL,
 `password` varchar(32) DEFAULT NULL,
 `age` tinyint(2) DEFAULT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-- ----------------------------
-- Records of think_user
-- ----------------------------
INSERT INTO `think_user` VALUES (‘1‘, ‘admin‘, ‘21232f297a57a5a743894a0e4a801fc3‘, ‘25‘);
 
 

ThinkPHP权限认证表设计