CREATE database if NOT EXISTS `lb-doc` default character set utf8mb4 collate utf8mb4_general_ci;
use `lb-doc`;

/*
 Navicat Premium Data Transfer

 Source Server         : docker
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : lb-doc

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

 Date: 06/07/2022 16:32:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for doc_file
-- ----------------------------
DROP TABLE IF EXISTS `doc_file`;
CREATE TABLE `doc_file`  (
  `file_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `file_size` bigint NULL DEFAULT NULL COMMENT '文件大小',
  `file_status` int NULL DEFAULT NULL COMMENT '文件状态(0-失效，1-生效)',
  `file_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件url',
  `identifier` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'md5唯一标识',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `storage_type` int NULL DEFAULT NULL COMMENT '存储类型',
  PRIMARY KEY (`file_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of doc_file
-- ----------------------------
INSERT INTO `doc_file` VALUES ('1544579737907228672', 52, 1, '/20220706/df9f7990cac34fceb0edba41d70293ee.txt', '4e8d648be10ee0b8abe89807613cbb12', 'admin', '2022-07-06 15:11:21', NULL, NULL, NULL);
INSERT INTO `doc_file` VALUES ('1544579740239261696', 7655424, 1, '/20220706/4ea9af42e00d4a418b0a4cee6c1af9bc.iso', '34cc07c5ecc59ddf7f635b20525a0a52', 'admin', '2022-07-06 15:11:22', NULL, NULL, NULL);
INSERT INTO `doc_file` VALUES ('1544579742093144064', 2099206, 1, '/20220706/d26ef942e49840b4b3a631dbc3f17289.doc', '9fbb03cc5a7565f4cab41b924391ef07', 'admin', '2022-07-06 15:11:22', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for doc_file_path
-- ----------------------------
DROP TABLE IF EXISTS `doc_file_path`;
CREATE TABLE `doc_file_path`  (
  `path_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `delete_batch_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除批次号',
  `delete_flag` int NULL DEFAULT NULL COMMENT '删除标识(0-未删除，1-已删除)',
  `delete_time` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '删除时间',
  `extend_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '扩展名',
  `file_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件id',
  `file_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名',
  `file_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件路径',
  `is_dir` int NULL DEFAULT NULL COMMENT '是否是目录(0-否,1-是)',
  `create_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `path_status` int NULL DEFAULT NULL,
  PRIMARY KEY (`path_id`) USING BTREE,
  UNIQUE INDEX `fileindex`(`file_path` ASC, `file_name` ASC, `extend_name` ASC, `delete_flag` ASC, `is_dir` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of doc_file_path
-- ----------------------------
INSERT INTO `doc_file_path` VALUES ('1544586695808774145', NULL, 0, NULL, '', NULL, 'aliyunDownload', '/', 1, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);
INSERT INTO `doc_file_path` VALUES ('1544586695812968448', NULL, 0, NULL, 'txt', '1544579737907228672', 'test.txt', '/aliyunDownload/', 0, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);
INSERT INTO `doc_file_path` VALUES ('1544586696442114048', NULL, 0, NULL, '', NULL, 'BaiduNetdiskDownload', '/', 1, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);
INSERT INTO `doc_file_path` VALUES ('1544586696450502656', NULL, 0, NULL, '', NULL, 'bdy', '/BaiduNetdiskDownload/', 1, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);
INSERT INTO `doc_file_path` VALUES ('1544586696618274816', NULL, 0, NULL, 'iso', '1544579740239261696', 'HEU_KMS_Activator_v24.2.0.iso', '/BaiduNetdiskDownload/', 0, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);
INSERT INTO `doc_file_path` VALUES ('1544586697243226112', NULL, 0, NULL, 'iso', '1544579740239261696', 'HEU_KMS_Activator_v24.2.0.iso', '/', 0, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);
INSERT INTO `doc_file_path` VALUES ('1544586697679433728', NULL, 0, NULL, 'doc', '1544579742093144064', 'Q／JXZY-GF+219.1+052-2021+ZB45（GDX2）包装机组操作规程.doc', '/', 0, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);
INSERT INTO `doc_file_path` VALUES ('1544586697847205889', NULL, 0, NULL, '', NULL, '／／⁄', '/', 1, 'admin', '2022-07-06 15:39:00', 'admin', '2022-07-06 15:39:25', 1);

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
  `role_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `role_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编码',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `create_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uniq_sys_role_role_code`(`role_code` ASC) USING BTREE,
  INDEX `idx_sr_role_code`(`role_code` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of sys_role
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;