RBAC 权限管理----之建表

建表：管理员表，权限表，角色表， 并模拟数据

-- 管理员 3-1
CREATE TABLE admin_manager (
    manager_id smallint unsigned NOT NULL AUTO_INCREMENT COMMENT '管理员id',
    manager_name varchar(32) NOT NULL DEFAULT '' COMMENT '管理员姓名',
    manager_pwd varchar(32) NOT NULL DEFAULT '' COMMENT '管理员密码',
    manager_salt char(32) NOT NULL DEFAULT '' COMMENT '加盐',
    manager_role_id tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',

    PRIMARY KEY(manager_id),
    UNIQUE KEY(manager_name)
) ENGINE=innoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT '后台-管理员';

-- 模拟插入数据   
insert into admin_manager(manager_name,manager_pwd,manager_salt,manager_role_id) values
('admin', '123456','123456',1),  
('tom', '123456','123456',2), 
('jack', '123456','123456',3);

-- 权限表 3-2
CREATE TABLE admin_auth (
    auth_id smallint unsigned NOT NULL AUTO_INCREMENT COMMENT '权限id',
    auth_name varchar(12) NOT NULL DEFAULT '' COMMENT '权限名称',
    auth_pid smallint unsigned NOT NULL DEFAULT '0' COMMENT '父id',
    auth_c varchar(24) NOT NULL DEFAULT '' COMMENT '控制器',
    auth_a varchar(24) NOT NULL DEFAULT '' COMMENT '操作方法',
    auth_path varchar(12) NOT NULL DEFAULT '' COMMENT '全路径:c-a',
    auth_level intyint unsigned  NOT NULL DEFAULT 0 COMMENT '级别,基本:0, 顶级:1, 次顶级:2, 次次顶级:3',
    PRIMARY KEY(auth_id)
) ENGINE=innoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT '后台-权限表';

-- 模拟插入数据   
insert into admin_auth(auth_id,auth_name,auth_pid,auth_c,auth_a,auth_path,auth_level) values
(1,'资讯管理','0','','','1','0'),   
(2,'资讯列表','1','article','list','1-2','1'),  
(3,'资讯添加','1','article','add','1-3','1'),   

(10,'商品管理','0','','','10','0'), 
(11,'商品列表','10','goods','list','10-11','1'),    
(12,'商品添加','10','goods','add','10-12','1'),
(13,'商品分类','10','goods','category','10-13','1'),

(20,'会员管理','0','','','20','0'),
(21,'会员列表','20','user','list','20-21','1'), 
(22,'会员添加','20','user','add','20-22','1'),

(30,'管理员管理','0','','','30','0'),
(31,'管理员列表','30','manager','list','30-31','1'),
(32,'权限列表','30','auth','list','30-32','1'),
(33,'角色列表','30','role','list','30-33','1'),

(40,'评论管理','0','','','40','0'), 
(41,'意见反馈','40','comment','feedback','40-41','1'),  

(50,'系统管理','0','','','50','0'),
(51,'屏蔽词','50','system','shielding','50-51','1'),   
(52,'系统日志','50','system','log','50-52','1');

-- 角色表 3-3
CREATE TABLE admin_role (
    role_id smallint unsigned NOT NULL AUTO_INCREMENT COMMENT '角色id',
    role_name varchar(24) NOT NULL DEFAULT '' COMMENT '角色名称',
    role_desc varchar(32) NOT NULL DEFAULT '' COMMENT '角色描述',
    role_auth_ids varchar(128) NOT NULL DEFAULT '' COMMENT '权限ids',
    role_auth_ac text COMMENT '控制器-方法',
    PRIMARY KEY(role_id),
    UNIQUE KEY(role_name)
) ENGINE=innoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 COMMENT '后台-角色表';

-- 模拟插入数据   
insert into admin_role values
(1,'超级管理员','超级管理员','0',''),                            -- 设置0，为方便以后操作
(2,'项目经理','项目经理','1,2,3,20,21,22','article-list,article-add,user-list,user-add'),
(3,'前端工程师','前端工程师','',''),
(4,'编辑','编辑','1,2,3','article-list,article-add'),
(5,'美工','美工','',''),
(6,'客服','客服','','');