Rbac2 · PHP筆記

```mysql SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `tp_action_log` -- ---------------------------- DROP TABLE IF EXISTS `tp_action_log`; CREATE TABLE `tp_action_log` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主鍵', `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '執行用戶id', `action_ip` bigint(20) NOT NULL COMMENT '執行行為者ip', `log` longtext NOT NULL COMMENT '日志備注', `log_url` varchar(255) NOT NULL COMMENT '執行的URL', `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '執行行為的時間', `username` varchar(255) NOT NULL COMMENT '執行者', `title` varchar(255) NOT NULL COMMENT '標題', PRIMARY KEY (`id`), KEY `id` (`id`) USING BTREE ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行為日志表'; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `tp_auth_access` -- ---------------------------- DROP TABLE IF EXISTS `tp_auth_access`; CREATE TABLE `tp_auth_access` ( `role_id` mediumint(8) unsigned NOT NULL COMMENT '角色', `rule_name` varchar(255) NOT NULL COMMENT '規則唯一英文標識,全小寫', `type` varchar(30) DEFAULT NULL COMMENT '權限規則分類，請加應用前綴,如admin_', `menu_id` int(11) DEFAULT NULL COMMENT '后臺菜單ID', KEY `role_id` (`role_id`), KEY `rule_name` (`rule_name`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='權限授權表'; -- ---------------------------- -- Records of `tp_auth_access` -- ---------------------------- BEGIN; INSERT INTO `tp_auth_access` VALUES ('2', 'index/auth/default', 'admin_url', '1'), ('2', 'index/auth/default', 'admin_url', '8'), ('2', 'index/auth/menu', 'admin_url', '9'), ('2', 'index/auth/menuadd', 'admin_url', '10'), ('2', 'index/auth/menuedit', 'admin_url', '11'), ('2', 'index/auth/menudelete', 'admin_url', '12'), ('2', 'index/auth/menuorder', 'admin_url', '13'); COMMIT; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `tp_auth_role` -- ---------------------------- DROP TABLE IF EXISTS `tp_auth_role`; CREATE TABLE `tp_auth_role` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL COMMENT '角色名稱', `pid` smallint(6) DEFAULT '0' COMMENT '父角色ID', `status` tinyint(1) unsigned DEFAULT NULL COMMENT '狀態', `remark` varchar(255) DEFAULT NULL COMMENT '備注', `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '創建時間', `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新時間', `listorder` int(3) NOT NULL DEFAULT '0' COMMENT '排序字段', PRIMARY KEY (`id`), KEY `parentId` (`pid`), KEY `status` (`status`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色表'; -- ---------------------------- -- Records of `tp_auth_role` -- ---------------------------- BEGIN; INSERT INTO `tp_auth_role` VALUES ('1', '超級管理員', '0', '1', '擁有網站最高管理員權限！', '1329633709', '1329633709', '0'), ('2', '文章管理', '0', '1', '', '0', '0', '0'); COMMIT; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `tp_auth_role_user` -- ---------------------------- DROP TABLE IF EXISTS `tp_auth_role_user`; CREATE TABLE `tp_auth_role_user` ( `role_id` int(11) unsigned DEFAULT '0' COMMENT '角色 id', `user_id` int(11) DEFAULT '0' COMMENT '用戶id', KEY `group_id` (`role_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用戶角色對應表'; -- ---------------------------- -- Records of `tp_auth_role_user` -- ---------------------------- BEGIN; INSERT INTO `tp_auth_role_user` VALUES ('2', '16'); COMMIT; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `tp_auth_rule` -- ---------------------------- DROP TABLE IF EXISTS `tp_auth_rule`; CREATE TABLE `tp_auth_rule` ( `menu_id` int(11) NOT NULL COMMENT '后臺菜單 ID', `module` varchar(20) NOT NULL COMMENT '規則所屬module', `type` varchar(30) NOT NULL DEFAULT '1' COMMENT '權限規則分類，請加應用前綴,如admin_', `name` varchar(255) NOT NULL DEFAULT '' COMMENT '規則唯一英文標識,全小寫', `url_param` varchar(255) DEFAULT NULL COMMENT '額外url參數', `title` varchar(20) NOT NULL DEFAULT '' COMMENT '規則中文描述', `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:無效,1:有效)', `rule_param` varchar(300) NOT NULL DEFAULT '' COMMENT '規則附加條件', `nav_id` int(11) DEFAULT '0' COMMENT 'nav id', PRIMARY KEY (`menu_id`), KEY `module` (`module`,`status`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='權限規則表'; -- ---------------------------- -- Records of `tp_auth_rule` -- ---------------------------- BEGIN; INSERT INTO `tp_auth_rule` VALUES ('2', 'index', 'admin_url', 'index/auth/default', '', '權限管理', '1', '', '0'), ('3', 'index', 'admin_url', 'index/auth/role', '', '角色管理', '1', '', '0'), ('4', 'index', 'admin_url', 'index/auth/roleadd', '', '角色增加', '1', '', '0'), ('5', 'index', 'admin_url', 'index/auth/roleedit', '', '角色編輯', '1', '', '0'), ('6', 'index', 'admin_url', 'index/auth/roledelete', '', '角色刪除', '1', '', '0'), ('7', 'index', 'admin_url', 'index/auth/authorize', '', '角色授權', '1', '', '0'), ('8', 'index', 'admin_url', 'index/auth/menu', '', '菜單管理', '1', '', '0'), ('9', 'index', 'admin_url', 'index/auth/menu', '', '菜單列表', '1', '', '0'), ('10', 'index', 'admin_url', 'index/auth/menuadd', '', '菜單增加', '1', '', '0'), ('11', 'index', 'admin_url', 'index/auth/menuedit', '', '菜單修改', '1', '', '0'), ('12', 'index', 'admin_url', 'index/auth/menudelete', '', '菜單刪除', '1', '', '0'), ('13', 'index', 'admin_url', 'index/auth/menuorder', '', '菜單排序', '1', '', '0'), ('14', 'index', 'admin_url', 'index/admin/index', '', '用戶管理', '1', '', '0'); COMMIT; SET FOREIGN_KEY_CHECKS = 1; SET NAMES utf8; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for `tp_menu` -- ---------------------------- DROP TABLE IF EXISTS `tp_menu`; CREATE TABLE `tp_menu` ( `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID', `parent_id` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '父級ID', `app` char(20) NOT NULL COMMENT '應用名稱app', `model` char(20) NOT NULL COMMENT '控制器', `action` char(20) NOT NULL COMMENT '操作名稱', `url_param` char(50) NOT NULL COMMENT 'url參數', `type` tinyint(1) NOT NULL DEFAULT '0' COMMENT '菜單類型 1：權限認證+菜單；0：只作為菜單', `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '狀態，1顯示，0不顯示', `name` varchar(50) NOT NULL COMMENT '菜單名稱', `icon` varchar(50) NOT NULL COMMENT '菜單圖標', `remark` varchar(255) NOT NULL COMMENT '備注', `list_order` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '排序ID', `rule_param` varchar(255) NOT NULL COMMENT '驗證規則', `nav_id` int(11) DEFAULT '0' COMMENT 'nav ID ', `request` varchar(255) NOT NULL COMMENT '請求方式（日志生成）', `log_rule` varchar(255) NOT NULL COMMENT '日志規則', PRIMARY KEY (`id`), KEY `status` (`status`), KEY `model` (`model`), KEY `parent_id` (`parent_id`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='后臺菜單表'; -- ---------------------------- -- Records of `tp_menu` -- ---------------------------- BEGIN; INSERT INTO `tp_menu` VALUES ('1', '0', 'index', 'auth', 'default', '', '0', '1', '系統管理', '', '', '10', '', '0', '', ''), ('2', '1', 'index', 'auth', 'default', '', '0', '1', '權限管理', '', '', '0', '', '0', '', ''), ('3', '2', 'index', 'auth', 'role', '', '1', '1', '角色管理', '', '', '0', '', '0', '', ''), ('4', '3', 'index', 'auth', 'roleAdd', '', '1', '0', '角色增加', '', '', '0', '', '0', '', ''), ('5', '3', 'index', 'auth', 'roleEdit', '', '1', '0', '角色編輯', '', '', '0', '', '0', '', ''), ('6', '3', 'index', 'auth', 'roleDelete', '', '1', '0', '角色刪除', '', '', '0', '', '0', '', ''), ('7', '3', 'index', 'auth', 'authorize', '', '1', '0', '角色授權', '', '', '0', '', '0', '', ''), ('8', '1', 'index', 'auth', 'default', '', '0', '1', '菜單管理', '', '', '0', '', '0', '', ''), ('9', '8', 'index', 'auth', 'menu', '', '1', '1', '菜單列表', '', '', '0', '', '0', '', ''), ('10', '9', 'index', 'auth', 'menuAdd', '', '1', '0', '菜單增加', '', '', '0', '', '0', '', ''), ('11', '9', 'index', 'auth', 'menuEdit', '', '1', '0', '菜單修改', '', '', '0', '', '0', '', ''), ('12', '9', 'index', 'auth', 'menuDelete', '', '1', '0', '菜單刪除', '', '', '0', '', '0', '', ''), ('13', '9', 'index', 'auth', 'menuOrder', '', '1', '0', '菜單排序', '', '', '0', '', '0', '', ''), ('14', '2', 'index', 'admin', 'index', '', '1', '1', '用戶管理', '', '', '0', '', '0', '', ''); COMMIT; SET FOREIGN_KEY_CHECKS = 1; ```