text: /*
   Navicat Premium Data Transfer
  
   Source Server         : local
   Source Server Type    : MySQL
   Source Server Version : 50726
   Source Host           : localhost:3306
   Source Schema         : datax_web
  
   Target Server Type    : MySQL
   Target Server Version : 50726
   File Encoding         : 65001
  
   Date: 20/03/2020 20:09:20
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for job_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `job_permission`;
  CREATE TABLE `job_permission`  (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限名',
    `description` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限描述',
    `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `pid` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of job_permission
  -- ----------------------------
  INSERT INTO `job_permission` VALUES (1, 'ROLE_HOME', 'home', '/', NULL);
  INSERT INTO `job_permission` VALUES (2, 'ROLE_ADMIN', 'ABel', '/', NULL);
  
  -- ----------------------------
  -- Table structure for job_role
  -- ----------------------------
  DROP TABLE IF EXISTS `job_role`;
  CREATE TABLE `job_role`  (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of job_role
  -- ----------------------------
  INSERT INTO `job_role` VALUES (1, 'ROLE_ADMIN');
  INSERT INTO `job_role` VALUES (2, 'ROLE_USER');
  
  -- ----------------------------
  -- Table structure for job_user
  -- ----------------------------
  DROP TABLE IF EXISTS `job_user`;
  CREATE TABLE `job_user`  (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户主键',
    `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
    `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of job_user
  -- ----------------------------
  INSERT INTO `job_user` VALUES (1, 'admin', '$2a$10$2KCqRbra0Yn2TwvkZxtfLuWuUP5KyCWsljO/ci5pLD27pqR3TV1vy');
  INSERT INTO `job_user` VALUES (2, 'abel', 'abel');
  INSERT INTO `job_user` VALUES (3, 'adsd', '$2a$10$7/YMCv3DRGbOL6/nQltoqeNzNA.8nYAwzxUmuOh5/9by/5aV7sMcm');
  
  -- ----------------------------
  -- Table structure for permission_role
  -- ----------------------------
  DROP TABLE IF EXISTS `permission_role`;
  CREATE TABLE `permission_role`  (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `role_id` int(11) NULL DEFAULT NULL COMMENT '角色名称',
    `permission_id` int(20) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of permission_role
  -- ----------------------------
  INSERT INTO `permission_role` VALUES (1, 1, 1);
  INSERT INTO `permission_role` VALUES (2, 2, 1);
  INSERT INTO `permission_role` VALUES (3, 1, 2);
  
  -- ----------------------------
  -- Table structure for role_user
  -- ----------------------------
  DROP TABLE IF EXISTS `role_user`;
  CREATE TABLE `role_user`  (
    `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `user_id` int(20) NULL DEFAULT NULL COMMENT '角色名称',
    `role_id` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of role_user
  -- ----------------------------
  INSERT INTO `role_user` VALUES (1, 1, 1);
  INSERT INTO `role_user` VALUES (2, 2, 2);
  
  SET FOREIGN_KEY_CHECKS = 1;
  