/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 50648
 Source Host           : 127.0.0.1:3306
 Source Schema         : okadmin

 Target Server Type    : MySQL
 Target Server Version : 50648
 File Encoding         : 65001

 Date: 22/04/2022 20:03:13
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户名（账号）',
  `mobile` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码',
  `real_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '真实姓名',
  `sex` tinyint(4) NULL DEFAULT NULL COMMENT '性别 1：男 2：女',
  `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态  0：禁用 1：启用',
  `created_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
  `deleted_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE,
  UNIQUE INDEX `mobile`(`mobile`) USING BTREE,
  UNIQUE INDEX `email`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of member
-- ----------------------------
INSERT INTO `member` VALUES (1, 'admin', '18201072515', '18201072515@163.com', '$2a$12$xrG7ikDFMx5/W.B0gtHGUOHFhsJ3YzGtCXzNkkO6SSDnLcn2Z9Y6S', 'admin', 1, 1, 1636005335, 1636522595, NULL);
INSERT INTO `member` VALUES (46, 'test1', '13800138000', '13800138000@test.com', '$2a$12$reaaWTEFNgVxqXU9uNEPMulQVVELd/i1bV2IExI9HE9N4dyavNmcG', 'test', 1, 0, 1636341672, 1636523934, NULL);

-- ----------------------------
-- Table structure for member_role
-- ----------------------------
DROP TABLE IF EXISTS `member_role`;
CREATE TABLE `member_role`  (
  `member_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  INDEX `member_role_ibfk_1`(`member_id`) USING BTREE,
  INDEX `member_role_ibfk_2`(`role_id`) USING BTREE,
  CONSTRAINT `member_role_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `member_role_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of member_role
-- ----------------------------
INSERT INTO `member_role` VALUES (1, 1);
INSERT INTO `member_role` VALUES (1, 4);
INSERT INTO `member_role` VALUES (46, 4);

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '权限名称',
  `href` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '权限路径',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'icon',
  `is_menu` tinyint(4) NULL DEFAULT NULL COMMENT '是否是菜单 1：菜单  0：其他',
  `font_family` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'icon 字体',
  `p_id` int(11) NULL DEFAULT NULL COMMENT '父级id',
  `sort` int(11) NULL DEFAULT NULL COMMENT '排序',
  `created_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`title`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 32 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES (1, '系统管理', '#', 'ok-icon-set', 1, 'ok-icon', 0, 2, 1635822657, 1635822657);
INSERT INTO `permission` VALUES (2, '管理员管理', 'member/index', 'layui-icon-tree', 1, 'layui-icon', 1, 3, 1635822657, 1636596993);
INSERT INTO `permission` VALUES (3, '角色管理', 'role/index', 'layui-icon-tree', 1, 'layui-icon', 1, 3, 1635822657, 1636342928);
INSERT INTO `permission` VALUES (4, '权限管理', 'permission/index', 'layui-icon-password', 1, 'layui-icon', 1, 3, 1635822657, 1636342920);
INSERT INTO `permission` VALUES (5, '添加管理员', 'member/create', '', 2, 'ok-icon', 2, 3, 1635822657, 1636597009);
INSERT INTO `permission` VALUES (6, '修改管理员', 'member/edit', '', 2, 'ok-icon', 2, 3, 1635822657, 1636002965);
INSERT INTO `permission` VALUES (7, '删除管理员', 'member/delete', '', 2, 'ok-icon', 2, 3, 1635822657, 1636003747);
INSERT INTO `permission` VALUES (21, '控制台', 'index', 'ok-icon-kongzhitai_', 1, 'ok-icon', 0, -1, 1635998206, 1636689343);
INSERT INTO `permission` VALUES (22, '添加权限', 'permission/create', NULL, 2, 'ok-icon', 4, 4, 1635998206, 1635998206);
INSERT INTO `permission` VALUES (23, '修改权限', 'permission/edit', 'ok-icon-', 2, 'ok-icon', 4, 4, 1636341912, 1636341978);
INSERT INTO `permission` VALUES (24, '删除权限', 'permission/delete', 'ok-icon-', 2, 'ok-icon', 4, 4, 1636341969, 1636341969);
INSERT INTO `permission` VALUES (25, '添加角色', 'role/create', 'ok-icon-', 2, 'ok-icon', 3, 5, 1636342012, 1636342012);
INSERT INTO `permission` VALUES (26, '修改角色', 'role/edit', 'ok-icon-', 2, 'ok-icon', 3, 5, 1636342048, 1636343250);
INSERT INTO `permission` VALUES (27, '删除角色', 'role/delete', 'ok-icon-', 2, 'ok-icon', 3, 5, 1636342075, 1636342075);
INSERT INTO `permission` VALUES (28, '管理员列表', 'member/index', 'ok-icon-', 2, 'ok-icon', 2, 2, 1636342993, 1636597001);
INSERT INTO `permission` VALUES (29, '角色列表', 'role/index', 'ok-icon-', 2, 'ok-icon', 3, 4, 1636343033, 1636343099);
INSERT INTO `permission` VALUES (30, '权限列表', 'permission/index', 'ok-icon-', 2, 'ok-icon', 4, 3, 1636343070, 1636343109);
INSERT INTO `permission` VALUES (31, '仪表盘', 'panel', 'layui-icon-console', 1, 'layui-icon', 0, 0, 1636688920, 1636688920);

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色名称',
  `describe` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `created_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` int(10) UNSIGNED NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, '超级管理员', '超级管理员', 1634710026, 1636688952);
INSERT INTO `role` VALUES (4, '普通管理员', '普通管理员', 1635752563, 1636610760);

-- ----------------------------
-- Table structure for role_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission`  (
  `role_id` int(10) UNSIGNED NOT NULL,
  `permission_id` int(10) UNSIGNED NOT NULL,
  INDEX `role_id`(`role_id`) USING BTREE,
  INDEX `permission_id`(`permission_id`) USING BTREE,
  CONSTRAINT `role_permission_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `role_permission_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_permission
-- ----------------------------
INSERT INTO `role_permission` VALUES (4, 1);
INSERT INTO `role_permission` VALUES (4, 2);
INSERT INTO `role_permission` VALUES (4, 3);
INSERT INTO `role_permission` VALUES (4, 30);
INSERT INTO `role_permission` VALUES (4, 21);
INSERT INTO `role_permission` VALUES (4, 28);
INSERT INTO `role_permission` VALUES (4, 29);
INSERT INTO `role_permission` VALUES (4, 4);
INSERT INTO `role_permission` VALUES (1, 31);
INSERT INTO `role_permission` VALUES (1, 21);
INSERT INTO `role_permission` VALUES (1, 7);
INSERT INTO `role_permission` VALUES (1, 29);
INSERT INTO `role_permission` VALUES (1, 4);
INSERT INTO `role_permission` VALUES (1, 22);
INSERT INTO `role_permission` VALUES (1, 6);
INSERT INTO `role_permission` VALUES (1, 3);
INSERT INTO `role_permission` VALUES (1, 5);
INSERT INTO `role_permission` VALUES (1, 2);
INSERT INTO `role_permission` VALUES (1, 27);
INSERT INTO `role_permission` VALUES (1, 30);
INSERT INTO `role_permission` VALUES (1, 24);
INSERT INTO `role_permission` VALUES (1, 1);
INSERT INTO `role_permission` VALUES (1, 28);
INSERT INTO `role_permission` VALUES (1, 25);
INSERT INTO `role_permission` VALUES (1, 26);
INSERT INTO `role_permission` VALUES (1, 23);

SET FOREIGN_KEY_CHECKS = 1;