/* Navicat MySQL Data Transfer
Source Server : 192.168.1.186 Source Server Version : 50542 Source Host : 192.168.1.186:3306 Source Database : ruanwen
Target Server Type : MYSQL Target Server Version : 50542 File Encoding : 65001
Date: 2020-06-08 15:53:46 */
SET FOREIGN_KEY_CHECKS=0;
-- Table structure for model_has_permissions
DROP TABLE IF EXISTS model_has_permissions
;
CREATE TABLE model_has_permissions
(
permission_id
bigint(20) unsigned NOT NULL,
model_type
varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
model_id
bigint(20) unsigned NOT NULL,
PRIMARY KEY (permission_id
,model_id
,model_type
),
KEY model_has_permissions_model_id_model_type_index
(model_id
,model_type
) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Table structure for model_has_roles
DROP TABLE IF EXISTS model_has_roles
;
CREATE TABLE model_has_roles
(
role_id
bigint(20) unsigned NOT NULL,
model_type
varchar(190) COLLATE utf8mb4_unicode_ci NOT NULL,
model_id
bigint(20) unsigned NOT NULL,
PRIMARY KEY (role_id
,model_id
,model_type
),
KEY model_has_roles_model_id_model_type_index
(model_id
,model_type
) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Table structure for permissions
DROP TABLE IF EXISTS permissions
;
CREATE TABLE permissions
(
id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
parent_id
int(11) NOT NULL DEFAULT '0',
name
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口地址',
display_name
varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
url
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '页面路由',
guard_name
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
sort
smallint(6) NOT NULL DEFAULT '0' COMMENT '排序,数字越大越在前面',
icon
varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
created_time
timestamp NULL DEFAULT NULL,
updated_time
timestamp NULL DEFAULT NULL,
type
tinyint(1) NOT NULL DEFAULT '0' COMMENT '0菜单,1按钮',
PRIMARY KEY (id
)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Table structure for role_has_permissions
DROP TABLE IF EXISTS role_has_permissions
;
CREATE TABLE role_has_permissions
(
permission_id
bigint(20) unsigned NOT NULL,
role_id
bigint(20) unsigned NOT NULL,
PRIMARY KEY (permission_id
,role_id
),
KEY role_has_permissions_role_id_foreign
(role_id
) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-- Table structure for roles
DROP TABLE IF EXISTS roles
;
CREATE TABLE roles
(
id
bigint(20) unsigned NOT NULL AUTO_INCREMENT,
name
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
description
varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
guard_name
varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'web',
create_time
timestamp NULL DEFAULT NULL,
update_time
timestamp NULL DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
#安装方法
composer require wangcb/permission
#User模型类加
class User extend Model{ use HasRole; }
$res = $user->getAllPermissions(); //获取所有权限
$user->can('/auth/add');//判断是否有权限
$res = $user->getMenu(); //获取权限菜单树
$user->getRoles();//获取用户角色
$user->clearRole();//删除用户所有角色
$user->roles([1,2,3]);//给用户分配角色