/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : jwgin

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

 Date: 31/12/2021 15:44:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '用户名字',
  `account` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '密码',
  `pass_salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '加密盐',
  `role` int(1) NULL DEFAULT NULL,
  `addtime` int(11) NULL DEFAULT NULL,
  `uptime` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES (1, 'jwcode', 'jwcode', '8c5bb3198fa495adbf1b896b0ce08a35a314879a7095a5be7f9a5f5448faa8c2', 'jw', 999, 1638428208, 1638428208);
INSERT INTO `admin_user` VALUES (2, 'sAdmin', 'sAdmin', 'dc2daf045044210b305cdb360e2d582521ad8c0ed64d28e2962ab7948c878bcb', 'sA', 2, 1638428208, 1638428208);

-- ----------------------------
-- Table structure for permission_api
-- ----------------------------
DROP TABLE IF EXISTS `permission_api`;
CREATE TABLE `permission_api`  (
  `api_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_content` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '说明',
  `api_method` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '请求方法',
  `api_path` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '请求地址',
  `api_statu` int(1) NULL DEFAULT NULL COMMENT '1启用 2禁用',
  PRIMARY KEY (`api_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = 'api' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of permission_api
-- ----------------------------
INSERT INTO `permission_api` VALUES (1, '获取角色列表', 'GET', '/admin/route/role', 1);
INSERT INTO `permission_api` VALUES (2, '获取web权限', 'GET', '/admin/route/web', 1);
INSERT INTO `permission_api` VALUES (3, '添加web权限', 'PUT', '/admin/route/web', 1);
INSERT INTO `permission_api` VALUES (4, '修改web权限', 'POST', '/admin/route/web', 1);
INSERT INTO `permission_api` VALUES (5, '删除web权限', 'DELETE', '/admin/route/web', 1);
INSERT INTO `permission_api` VALUES (6, '获取角色列表', 'GET', '/admin/route/role', 1);
INSERT INTO `permission_api` VALUES (7, '添加角色列表', 'PUT', '/admin/route/role', 1);
INSERT INTO `permission_api` VALUES (8, '更新角色列表', 'POST', '/admin/route/role', 1);
INSERT INTO `permission_api` VALUES (9, '删除角色列表', 'DELETE', '/admin/route/role', 1);
INSERT INTO `permission_api` VALUES (10, '获取api列表', 'GET', '/admin/route/api', 1);
INSERT INTO `permission_api` VALUES (11, '添加api列表', 'PUT', '/admin/route/api', 1);
INSERT INTO `permission_api` VALUES (12, '更新api列表', 'POST', '/admin/route/api', 1);
INSERT INTO `permission_api` VALUES (13, '删除api列表', 'DELETE', '/admin/route/api', 1);

-- ----------------------------
-- Table structure for permission_web
-- ----------------------------
DROP TABLE IF EXISTS `permission_web`;
CREATE TABLE `permission_web`  (
  `web_id` int(11) NOT NULL AUTO_INCREMENT,
  `web_pid` int(5) NULL DEFAULT 0,
  `web_path` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `web_to` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `web_content` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `web_icon` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL,
  `web_sort` int(10) NULL DEFAULT NULL,
  `web_statu` int(1) NOT NULL DEFAULT 2 COMMENT '1启用 2不启用',
  PRIMARY KEY (`web_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '后台web路由' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of permission_web
-- ----------------------------
INSERT INTO `permission_web` VALUES (1, 0, NULL, NULL, '系统管理', 'el-icon-setting', 666, 1);
INSERT INTO `permission_web` VALUES (2, 1, '/Admin/Users', 'views/Admin/Users', '管理员列表', 'el-icon-warning-outline', 666, 1);
INSERT INTO `permission_web` VALUES (3, 1, '/Admin/ApiRole', 'views/Admin/ApiRole', 'api权限列表', 'el-icon-warning-outline', 666, 1);
INSERT INTO `permission_web` VALUES (4, 1, '/Admin/Auth', 'views/Admin/Auth', '角色管理', 'el-icon-warning-outline', 666, 1);
INSERT INTO `permission_web` VALUES (5, 1, '/Admin/WebRole', 'views/Admin/WebRole', 'web权限列表', 'el-icon-warning-outline', 666, 1);
INSERT INTO `permission_web` VALUES (6, 0, '123', '123', '文章管理', 'el-icon-document', 123, 1);
INSERT INTO `permission_web` VALUES (7, 6, '123', '123', '123', '123', 123, 1);

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`  (
  `rule_id` int(11) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '权限名称',
  `role_content` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '描述',
  `role_api_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '拥有的api能力',
  `role_web_list` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '拥有的web能力',
  PRIMARY KEY (`rule_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_unicode_ci COMMENT = '角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'guest', '游客', '', '1,2,6,7');
INSERT INTO `roles` VALUES (2, '测试一下?', '测试一下?', '1,2,3,4,5,6,7,8,9,10,11,12,13', '1,3,4,5,6,7');
INSERT INTO `roles` VALUES (3, '123', '123', '3', '');

SET FOREIGN_KEY_CHECKS = 1;