/*
 Navicat Premium Data Transfer

 Source Server         : 阿里云
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : 47.101.51.239:3306
 Source Schema         : sharetieba_permission

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

 Date: 16/05/2019 16:49:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_permissions
-- ----------------------------
DROP TABLE IF EXISTS `sys_permissions`;
CREATE TABLE `sys_permissions`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `permission` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限编号',
  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限描述',
  `available` tinyint(1) NULL DEFAULT 0 COMMENT '是否锁定',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_sys_permissions_permission`(`permission`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_permissions
-- ----------------------------
INSERT INTO `sys_permissions` VALUES (4, '系统管理', '最高权限', 0);
INSERT INTO `sys_permissions` VALUES (12, 'xxx', 'xxx', 0);

-- ----------------------------
-- Table structure for sys_roles
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles`;
CREATE TABLE `sys_roles`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '角色编号',
  `role` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `description` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述',
  `pid` int(20) NULL DEFAULT NULL COMMENT '父节点',
  `available` tinyint(1) NULL DEFAULT 0 COMMENT '是否锁定',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_sys_roles_role`(`role`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_roles
-- ----------------------------
INSERT INTO `sys_roles` VALUES (4, 'root', '超级管理员', -1, 0);
INSERT INTO `sys_roles` VALUES (5, 'admin', '系统管理员', -1, 0);
INSERT INTO `sys_roles` VALUES (6, 'ops', '运维人员', -1, 0);
INSERT INTO `sys_roles` VALUES (7, 'personnel', '人事人员', -1, 0);
INSERT INTO `sys_roles` VALUES (8, 'financing', '财务人员', -1, 0);
INSERT INTO `sys_roles` VALUES (9, 'developer', '开发', -1, 0);
INSERT INTO `sys_roles` VALUES (10, 'generalize', '推广部', -1, 0);
INSERT INTO `sys_roles` VALUES (11, 'product', '产品部', -1, 0);
INSERT INTO `sys_roles` VALUES (18, '科二必过', '好', -1, 0);
INSERT INTO `sys_roles` VALUES (25, 'xxx', 'xxx', 2, 1);

-- ----------------------------
-- Table structure for sys_roles_permissions
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_permissions`;
CREATE TABLE `sys_roles_permissions`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `role_id` int(20) NULL DEFAULT NULL COMMENT '角色编号',
  `permission_id` int(20) NULL DEFAULT NULL COMMENT '权限编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sys_roles_permissions_ibfk_1`(`role_id`) USING BTREE,
  INDEX `sys_roles_permissions_ibfk_2`(`permission_id`) USING BTREE,
  CONSTRAINT `sys_roles_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `sys_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `sys_roles_permissions_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `sys_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_roles_permissions
-- ----------------------------
INSERT INTO `sys_roles_permissions` VALUES (13, 7, 4);
INSERT INTO `sys_roles_permissions` VALUES (20, 4, 4);
INSERT INTO `sys_roles_permissions` VALUES (21, 5, 12);

-- ----------------------------
-- Table structure for sys_tag
-- ----------------------------
DROP TABLE IF EXISTS `sys_tag`;
CREATE TABLE `sys_tag`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限url,标签',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标签描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_tag
-- ----------------------------
INSERT INTO `sys_tag` VALUES (4, '/index.html', '首页');
INSERT INTO `sys_tag` VALUES (11, '/views/user_manage.html', '用户管理');
INSERT INTO `sys_tag` VALUES (12, '/views/roles_manage.html', '角色管理');
INSERT INTO `sys_tag` VALUES (13, '/views/User_Tree.html', '用户权限树');
INSERT INTO `sys_tag` VALUES (14, '/views/Permission_Tree.html', '所有权限树');
INSERT INTO `sys_tag` VALUES (15, '/views/addroles.html', '用户添加权限');
INSERT INTO `sys_tag` VALUES (16, '/views/addsyspermissions.html', '角色添加权限');
INSERT INTO `sys_tag` VALUES (17, '/views/permisssion_manage.html', ' 权限管理');
INSERT INTO `sys_tag` VALUES (18, '/views/tag_manage.html', '标签管理');
INSERT INTO `sys_tag` VALUES (19, '/views/addtag.html', '角色提交标签');

-- ----------------------------
-- Table structure for sys_tag_permissions
-- ----------------------------
DROP TABLE IF EXISTS `sys_tag_permissions`;
CREATE TABLE `sys_tag_permissions`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) NULL DEFAULT NULL COMMENT '标签id',
  `permissions_id` int(11) NULL DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sys_tag_permissions_ibfk_1`(`tag_id`) USING BTREE,
  INDEX `sys_tag_permissions_ibfk_2`(`permissions_id`) USING BTREE,
  CONSTRAINT `sys_tag_permissions_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `sys_tag` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `sys_tag_permissions_ibfk_2` FOREIGN KEY (`permissions_id`) REFERENCES `sys_permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_tag_permissions
-- ----------------------------
INSERT INTO `sys_tag_permissions` VALUES (22, 4, 4);
INSERT INTO `sys_tag_permissions` VALUES (23, 11, 4);
INSERT INTO `sys_tag_permissions` VALUES (24, 12, 4);
INSERT INTO `sys_tag_permissions` VALUES (25, 13, 4);
INSERT INTO `sys_tag_permissions` VALUES (26, 14, 4);
INSERT INTO `sys_tag_permissions` VALUES (27, 15, 4);
INSERT INTO `sys_tag_permissions` VALUES (28, 16, 4);
INSERT INTO `sys_tag_permissions` VALUES (29, 17, 4);
INSERT INTO `sys_tag_permissions` VALUES (30, 18, 4);
INSERT INTO `sys_tag_permissions` VALUES (31, 19, 4);
INSERT INTO `sys_tag_permissions` VALUES (41, 4, 12);
INSERT INTO `sys_tag_permissions` VALUES (42, 11, 12);
INSERT INTO `sys_tag_permissions` VALUES (43, 12, 12);
INSERT INTO `sys_tag_permissions` VALUES (44, 13, 12);
INSERT INTO `sys_tag_permissions` VALUES (45, 14, 12);
INSERT INTO `sys_tag_permissions` VALUES (46, 15, 12);
INSERT INTO `sys_tag_permissions` VALUES (47, 16, 12);
INSERT INTO `sys_tag_permissions` VALUES (48, 17, 12);
INSERT INTO `sys_tag_permissions` VALUES (49, 18, 12);
INSERT INTO `sys_tag_permissions` VALUES (50, 19, 12);

-- ----------------------------
-- Table structure for sys_users
-- ----------------------------
DROP TABLE IF EXISTS `sys_users`;
CREATE TABLE `sys_users`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `salt` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '盐值',
  `locked` tinyint(1) NULL DEFAULT 0 COMMENT '是否锁定',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `idx_sys_users_username`(`username`) USING BTREE,
  UNIQUE INDEX `idx_sys_users_email`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_users
-- ----------------------------
INSERT INTO `sys_users` VALUES (2, 'AAA', '6b5c622399a08efabbb942db3028e970', 'salt', 0, '唯一索引邮箱1');
INSERT INTO `sys_users` VALUES (3, 'BBB', '6b5c622399a08efabbb942db3028e970', 'salt', 0, '唯一索引邮箱2');
INSERT INTO `sys_users` VALUES (4, 'Guopen', '6b5c622399a08efabbb942db3028e970', 'salt', 0, '唯一索引邮箱3');

-- ----------------------------
-- Table structure for sys_users_roles
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_roles`;
CREATE TABLE `sys_users_roles`  (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(20) NULL DEFAULT NULL COMMENT '用户编号',
  `role_id` int(20) NULL DEFAULT NULL COMMENT '角色编号',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `sys_users_roles_ibfk_1`(`user_id`) USING BTREE,
  INDEX `sys_users_roles_ibfk_2`(`role_id`) USING BTREE,
  CONSTRAINT `sys_users_roles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `sys_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `sys_users_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `sys_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 130 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_users_roles
-- ----------------------------
INSERT INTO `sys_users_roles` VALUES (120, 3, 5);
INSERT INTO `sys_users_roles` VALUES (121, 2, 4);
INSERT INTO `sys_users_roles` VALUES (122, 2, 5);
INSERT INTO `sys_users_roles` VALUES (123, 2, 6);
INSERT INTO `sys_users_roles` VALUES (124, 2, 8);
INSERT INTO `sys_users_roles` VALUES (125, 2, 9);
INSERT INTO `sys_users_roles` VALUES (126, 2, 11);
INSERT INTO `sys_users_roles` VALUES (128, 4, 4);
INSERT INTO `sys_users_roles` VALUES (129, 4, 5);

SET FOREIGN_KEY_CHECKS = 1;