/*
 Navicat Premium Data Transfer

 Source Server         : facesign
 Source Server Type    : MySQL
 Source Server Version : 50736
 Source Host           : 121.40.17.18:3306
 Source Schema         : facesign

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

 Date: 20/07/2022 13:39:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for acl_menu
-- ----------------------------
DROP TABLE IF EXISTS `acl_menu`;
CREATE TABLE `acl_menu`  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上级权限',
  `menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名',
  `path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件路径',
  `perms` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `gmt_create` datetime NULL DEFAULT NULL,
  `gmt_update` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `acl_menu_id_uindex`(`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限菜单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_menu
-- ----------------------------
INSERT INTO `acl_menu` VALUES ('0', '0', '超级用户', NULL, NULL, 'admin', NULL, 'super', NULL, NULL);
INSERT INTO `acl_menu` VALUES ('1', '0,1', '单位管理', 'string', 'string', 'root', 'string', 'string', NULL, NULL);
INSERT INTO `acl_menu` VALUES ('12', '0,1,12', '修改', NULL, NULL, 'root:update', NULL, NULL, NULL, NULL);
INSERT INTO `acl_menu` VALUES ('14', '0,1,14', '查询', NULL, NULL, 'root:query', NULL, NULL, NULL, NULL);
INSERT INTO `acl_menu` VALUES ('2', '0,1,2', '部门管理', 'string', 'string', 'root:exe', 'string', 'string', NULL, NULL);
INSERT INTO `acl_menu` VALUES ('22', '0,1,2,22', '修改', NULL, NULL, 'root:exe:update', NULL, NULL, NULL, NULL);
INSERT INTO `acl_menu` VALUES ('24', '0,1,2,24', '查询', NULL, NULL, 'root:exe:query', NULL, NULL, NULL, NULL);
INSERT INTO `acl_menu` VALUES ('3', '0,1,2,3', '会议管理', NULL, NULL, 'root:exe:conf', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for acl_role
-- ----------------------------
DROP TABLE IF EXISTS `acl_role`;
CREATE TABLE `acl_role`  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名',
  `roke_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色权限字符串',
  `status` int(1) NULL DEFAULT 0 COMMENT '角色状态（0正常 1停用）',
  `remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `rid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位id',
  `gmt_create` datetime NULL DEFAULT NULL,
  `gmt_update` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `acl_role_id_uindex`(`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_role
-- ----------------------------
INSERT INTO `acl_role` VALUES ('0', '超级管理员', 'admin', 0, '有所有权限', '0', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539882356004728834', '单位管理员', 'root', 0, '管理自己的单位', 'fa3f48aaf2d04a589d640a62c59487ba', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539882357917331457', '部门管理员', 'dept', 0, '拥有部门权限', 'fa3f48aaf2d04a589d640a62c59487ba', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539882357917331458', '会议管理员', 'conf', 0, '拥有会议管理权限', 'fa3f48aaf2d04a589d640a62c59487ba', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539891483141582850', '单位管理员', 'root', 0, '管理自己的单位', '297e747415a2439cb55acc0c7999a2cb', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539891489084911618', '部门管理员', 'dept', 0, '拥有部门权限', '297e747415a2439cb55acc0c7999a2cb', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539891489084911619', '会议管理员', 'conf', 0, '拥有会议管理权限', '297e747415a2439cb55acc0c7999a2cb', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539894797224751106', '单位管理员', 'root', 0, '管理自己的单位', 'e76f0d0e04d145f7b4ee5ba35f4c1367', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539894797224751107', '部门管理员', 'dept', 0, '拥有部门权限', 'e76f0d0e04d145f7b4ee5ba35f4c1367', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539894797224751108', '会议管理员', 'conf', 0, '拥有会议管理权限', 'e76f0d0e04d145f7b4ee5ba35f4c1367', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539894909846007809', '单位管理员', 'root', 0, '管理自己的单位', '1331783a17c34dd891450739c55fa649', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539894909846007810', '部门管理员', 'dept', 0, '拥有部门权限', '1331783a17c34dd891450739c55fa649', NULL, NULL);
INSERT INTO `acl_role` VALUES ('1539894909846007811', '会议管理员', 'conf', 0, '拥有会议管理权限', '1331783a17c34dd891450739c55fa649', NULL, NULL);

-- ----------------------------
-- Table structure for acl_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `acl_role_menu`;
CREATE TABLE `acl_role_menu`  (
  `role_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色id',
  `menu_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单id',
  PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_role_menu
-- ----------------------------
INSERT INTO `acl_role_menu` VALUES ('0', '0');
INSERT INTO `acl_role_menu` VALUES ('1539882356004728834', '1');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331457', '2');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331457', '22');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331457', '24');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331457', '3');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331458', '2');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331458', '22');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331458', '24');
INSERT INTO `acl_role_menu` VALUES ('1539882357917331458', '3');
INSERT INTO `acl_role_menu` VALUES ('1539891483141582850', '1');
INSERT INTO `acl_role_menu` VALUES ('1539891489084911618', '2');
INSERT INTO `acl_role_menu` VALUES ('1539891489084911619', '3');
INSERT INTO `acl_role_menu` VALUES ('1539894797224751106', '1');
INSERT INTO `acl_role_menu` VALUES ('1539894797224751107', '2');
INSERT INTO `acl_role_menu` VALUES ('1539894797224751108', '3');
INSERT INTO `acl_role_menu` VALUES ('1539894909846007809', '1');
INSERT INTO `acl_role_menu` VALUES ('1539894909846007810', '2');
INSERT INTO `acl_role_menu` VALUES ('1539894909846007811', '3');

-- ----------------------------
-- Table structure for acl_user_role
-- ----------------------------
DROP TABLE IF EXISTS `acl_user_role`;
CREATE TABLE `acl_user_role`  (
  `user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `role_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色id',
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of acl_user_role
-- ----------------------------
INSERT INTO `acl_user_role` VALUES ('0', '0');
INSERT INTO `acl_user_role` VALUES ('0', '1539882357917331457');
INSERT INTO `acl_user_role` VALUES ('0', '1539882357917331458');
INSERT INTO `acl_user_role` VALUES ('0', '1539891483141582850');
INSERT INTO `acl_user_role` VALUES ('1003', '1539882357917331457');

-- ----------------------------
-- Table structure for tbl_conf
-- ----------------------------
DROP TABLE IF EXISTS `tbl_conf`;
CREATE TABLE `tbl_conf`  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '会议名称',
  `message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消息',
  `place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地点',
  `creater_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创始人id',
  `status` int(1) NOT NULL DEFAULT 0 COMMENT '会议状态，0没有审核，1审核通过，2审核不通过\r\n3. 正在进行 4.已结束',
  `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '富文本详情',
  `code` varchar(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '6位会议码',
  `total` int(11) NOT NULL DEFAULT 0 COMMENT '总人数',
  `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
  `dept_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门id',
  `gmt_create` datetime NULL DEFAULT NULL,
  `gmt_update` datetime NULL DEFAULT NULL,
  `deleted` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_conf
-- ----------------------------
INSERT INTO `tbl_conf` VALUES ('1', '软件一班会议', NULL, '教学楼', '1003', 4, '<p>测试会议</p>', '876490', 17, '2022-05-07 00:07:00', '606bb18d16004ae5afe51cddc892dc4e', '2022-06-23 17:18:32', '2022-07-01 17:46:32', 0);
INSERT INTO `tbl_conf` VALUES ('1539901959439134722', '说明文档测试会议', NULL, '说明文档测试会议', '0', 1, '说明文档测试会议', '763677', 7, '2022-06-30 12:00:00', 'fa3f48aaf2d04a589d640a62c59487ba', '2022-06-23 17:23:32', '2022-07-19 20:30:00', 0);
INSERT INTO `tbl_conf` VALUES ('1540687011114532866', '时博帅测试会议', NULL, '时博帅测试会议', '1005', 4, '时博帅测试会议', '143141', 1, '2023-06-17 12:00:00', '606bb18d16004ae5afe51cddc892dc4e', '2022-06-25 21:23:03', '2022-07-02 18:02:29', 1);
INSERT INTO `tbl_conf` VALUES ('1542806465156456449', '搜索引擎研发商讨', NULL, '搜索引擎研发商讨', '0', 4, '搜索引擎研发商讨', '149110', 1, '2024-07-19 12:00:00', '50050ae9020e4cb381e7a1259d8fb9a0', '2022-07-01 17:45:00', '2022-07-02 20:48:12', 0);
INSERT INTO `tbl_conf` VALUES ('1543508654430568449', '研发测试', NULL, '研发测试', '0', 1, '研发测试', '836028', 10, '2024-07-12 12:00:00', '50050ae9020e4cb381e7a1259d8fb9a0', '2022-07-03 16:15:15', '2022-07-19 20:30:00', 0);

-- ----------------------------
-- Table structure for tbl_conf_user
-- ----------------------------
DROP TABLE IF EXISTS `tbl_conf_user`;
CREATE TABLE `tbl_conf_user`  (
  `conf_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '会议id',
  `user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
  `is_sign` int(11) NOT NULL DEFAULT 0 COMMENT '是否签到，0没有签到，1已签到',
  `deleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`conf_id`, `user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_conf_user
-- ----------------------------
INSERT INTO `tbl_conf_user` VALUES ('1', '0', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1003', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1005', 1, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1006', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080451878913', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080460267522', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080460267523', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080460267524', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080460267525', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080460267526', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080460267527', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080460267528', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080468656129', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080468656130', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080468656131', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080468656132', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1', '1539887080468656133', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1539901959439134722', '0', 2, 0);
INSERT INTO `tbl_conf_user` VALUES ('1539901959439134722', '1003', 2, 0);
INSERT INTO `tbl_conf_user` VALUES ('1539901959439134722', '1005', 2, 0);
INSERT INTO `tbl_conf_user` VALUES ('1539901959439134722', '1006', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1539901959439134722', '1539887080460267522', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1539901959439134722', '1539887080460267523', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1539901959439134722', '1539887080460267524', 2, 0);
INSERT INTO `tbl_conf_user` VALUES ('1542806465156456449', '0', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '0', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1003', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1005', 1, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1006', 2, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1539887080451878913', 2, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1539887080460267522', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1539887080460267523', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1539887080460267524', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1539887080460267525', 0, 0);
INSERT INTO `tbl_conf_user` VALUES ('1543508654430568449', '1539887080460267526', 0, 0);

-- ----------------------------
-- Table structure for tbl_dept
-- ----------------------------
DROP TABLE IF EXISTS `tbl_dept`;
CREATE TABLE `tbl_dept`  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '部门id',
  `pid` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父部门id，如果是单位，父部门总为admin',
  `rid` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '根部门id，如果是单位，root部门总为自己本身',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名',
  `status` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '部门状态，0正常，1停用',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门邮箱',
  `sort` int(11) NOT NULL DEFAULT 114514 COMMENT '显示顺序',
  `gmt_create` datetime NULL DEFAULT NULL,
  `gmt_update` datetime NULL DEFAULT NULL,
  `deleted` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_dept
-- ----------------------------
INSERT INTO `tbl_dept` VALUES ('0', '0', '0', 'admin', '0', NULL, 1, NULL, NULL, 0);
INSERT INTO `tbl_dept` VALUES ('108cb0f600ac49568e3065c48f5c063e', '0,297e747415a2439cb55acc0c7999a2cb,108cb0f600ac49568e3065c48f5c063e', '297e747415a2439cb55acc0c7999a2cb', '演示', '0', 'YanShi@test.com', 0, '2022-06-23 16:44:19', '2022-06-23 16:44:19', 0);
INSERT INTO `tbl_dept` VALUES ('1331783a17c34dd891450739c55fa649', '0,1331783a17c34dd891450739c55fa649', '1331783a17c34dd891450739c55fa649', '腾讯', '0', NULL, 114514, '2022-06-23 16:55:33', '2022-06-23 16:55:33', 0);
INSERT INTO `tbl_dept` VALUES ('297e747415a2439cb55acc0c7999a2cb', '0,297e747415a2439cb55acc0c7999a2cb', '297e747415a2439cb55acc0c7999a2cb', '说明文档测试单位', '0', 'ShuoMing@test.com', 0, '2022-06-23 16:41:53', '2022-06-23 16:41:53', 0);
INSERT INTO `tbl_dept` VALUES ('50050ae9020e4cb381e7a1259d8fb9a0', '0,e76f0d0e04d145f7b4ee5ba35f4c1367,50050ae9020e4cb381e7a1259d8fb9a0', 'e76f0d0e04d145f7b4ee5ba35f4c1367', '研发部', '0', NULL, 114514, '2022-06-23 16:57:18', '2022-06-23 16:57:18', 0);
INSERT INTO `tbl_dept` VALUES ('55d59b6ad1004b2bb5ae816278d92591', '0,e76f0d0e04d145f7b4ee5ba35f4c1367,55d59b6ad1004b2bb5ae816278d92591', 'e76f0d0e04d145f7b4ee5ba35f4c1367', '运营部', '0', NULL, 114514, '2022-06-23 16:57:25', '2022-06-23 16:57:25', 0);
INSERT INTO `tbl_dept` VALUES ('606bb18d16004ae5afe51cddc892dc4e', '0,fa3f48aaf2d04a589d640a62c59487ba,9d3d8381e1d34dcb9433d94cc1164f5b,606bb18d16004ae5afe51cddc892dc4e', 'fa3f48aaf2d04a589d640a62c59487ba', '软件1班', '0', NULL, 0, '2022-06-23 16:07:35', '2022-06-23 16:07:35', 0);
INSERT INTO `tbl_dept` VALUES ('61ba656f7dc34b2d8bc8617e6e918171', '0,fa3f48aaf2d04a589d640a62c59487ba,9d3d8381e1d34dcb9433d94cc1164f5b,61ba656f7dc34b2d8bc8617e6e918171', 'fa3f48aaf2d04a589d640a62c59487ba', '软件2班', '0', NULL, 0, '2022-06-23 16:07:40', '2022-06-23 16:07:40', 1);
INSERT INTO `tbl_dept` VALUES ('9d3d8381e1d34dcb9433d94cc1164f5b', '0,fa3f48aaf2d04a589d640a62c59487ba,9d3d8381e1d34dcb9433d94cc1164f5b', 'fa3f48aaf2d04a589d640a62c59487ba', '电子系', '0', NULL, 0, '2022-06-23 16:07:12', '2022-06-23 16:07:12', 0);
INSERT INTO `tbl_dept` VALUES ('d8b0c479ee4d4d30a2fe0fc7252c77e5', '0,1331783a17c34dd891450739c55fa649,d8b0c479ee4d4d30a2fe0fc7252c77e5', '1331783a17c34dd891450739c55fa649', '11', '0', '11', 11, '2022-07-03 18:21:13', '2022-07-03 18:21:13', 0);
INSERT INTO `tbl_dept` VALUES ('e76f0d0e04d145f7b4ee5ba35f4c1367', '0,e76f0d0e04d145f7b4ee5ba35f4c1367', 'e76f0d0e04d145f7b4ee5ba35f4c1367', '百度', '0', NULL, 114514, '2022-06-23 16:55:06', '2022-06-23 16:55:06', 0);
INSERT INTO `tbl_dept` VALUES ('ea997aa843744871a52b29b470b24b4a', '0,fa3f48aaf2d04a589d640a62c59487ba,ea997aa843744871a52b29b470b24b4a', 'fa3f48aaf2d04a589d640a62c59487ba', '经管系', '0', NULL, 0, '2022-06-23 16:07:05', '2022-06-23 16:07:05', 0);
INSERT INTO `tbl_dept` VALUES ('fa3f48aaf2d04a589d640a62c59487ba', '0,fa3f48aaf2d04a589d640a62c59487ba', 'fa3f48aaf2d04a589d640a62c59487ba', '学校', '0', NULL, 0, '2022-06-23 16:05:40', '2022-06-23 16:05:40', 0);

-- ----------------------------
-- Table structure for tbl_manage_dept
-- ----------------------------
DROP TABLE IF EXISTS `tbl_manage_dept`;
CREATE TABLE `tbl_manage_dept`  (
  `dept_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `user_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`dept_id`, `user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_manage_dept
-- ----------------------------
INSERT INTO `tbl_manage_dept` VALUES ('0', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('108cb0f600ac49568e3065c48f5c063e', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('1331783a17c34dd891450739c55fa649', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('297e747415a2439cb55acc0c7999a2cb', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('50050ae9020e4cb381e7a1259d8fb9a0', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('55d59b6ad1004b2bb5ae816278d92591', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('606bb18d16004ae5afe51cddc892dc4e', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('606bb18d16004ae5afe51cddc892dc4e', '1003', 0);
INSERT INTO `tbl_manage_dept` VALUES ('9d3d8381e1d34dcb9433d94cc1164f5b', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('d8b0c479ee4d4d30a2fe0fc7252c77e5', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('e76f0d0e04d145f7b4ee5ba35f4c1367', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('ea997aa843744871a52b29b470b24b4a', '0', 0);
INSERT INTO `tbl_manage_dept` VALUES ('fa3f48aaf2d04a589d640a62c59487ba', '0', 0);

-- ----------------------------
-- Table structure for tbl_user
-- ----------------------------
DROP TABLE IF EXISTS `tbl_user`;
CREATE TABLE `tbl_user`  (
  `id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `card_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `gender` int(11) NULL DEFAULT NULL COMMENT '性别，0女，1男, 2未知',
  `avatar` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '照片url',
  `birthday` date NULL DEFAULT NULL COMMENT '生日',
  `dept_id` varchar(36) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门id',
  `gmt_create` datetime NULL DEFAULT NULL,
  `gmt_update` datetime NULL DEFAULT NULL,
  `deleted` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tbl_user
-- ----------------------------
INSERT INTO `tbl_user` VALUES ('0', 'admin', 'admin', '$2a$10$ZfunKq3mopywVxrIPa2pIeVk/cgynQ6zqxm1VMiB5vi/P3ywLcSI6', '1', NULL, 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/05/22/8ee5940c726b41deb1f5f068e5ea93aaauthor.jpg', NULL, '0', NULL, '2022-05-27 20:18:05', 0);
INSERT INTO `tbl_user` VALUES ('1003', '马世欢', '1003', '$2a$10$lU6OiW.54Mt9ozjnQyuTTOWCkqZBo5H2C3RuHluAE4fLUx17oupPWi', '1003', 'jingguanceshiu3er@164.com43', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/f334731cacfa48969ce760f4035d4c991003.jpg', '2001-02-12', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1005', '时博帅', '1005', '$2a$10$TsKNgev2Vvwd38pqwL.X1O.fCSmu8KXuCZzceAqC7QSH9Q71O7jxdC', '1005', 'XuanRanDev@qq.com', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/f19473f216824103bedcbb4aeb5477f71005.jpg', '2001-02-11', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1006', '王一赫', '1006', '$2a$10$JZhCjM6.VeWPtqifjABCk.FC83Fus/qjG6K3Ep4Im8Z4CM1b5FtF.C', '1006', 'jingguanceshiu3er@164.com41', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/044c52f87b9140bc864c46c82a9df3091006.jpg', '2001-02-10', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887080451878913', '袁杰绅', '14836701535', '$2a$10$WScb1pUDWB5UOyVykUEZReueQ74g5EkuUJyxkKSzgu/sS62/zgBgW', '0001', 'jingguanceshiuser@163.com1', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/5149cd99d18842deb53ed56dc5fe04220001.jpg', '2001-01-01', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080460267522', '张起源', '10836723535', '$2a$10$K55JOc0O/pthD6x05jmwl.tg7gSDTXy.ety/pmKi.eUfxxJ7l7IYO', '0002', 'jingguanceshiu3er@164.com2', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/42d37919196a404d83b181bc0a25d1810002.jpg', '2001-01-02', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080460267523', '雷鹏飞', '6836745535', '$2a$10$0NFzUu5akEwUJrK0436ZgulfKGSH4W3SE4JfZ2bAHwXHjCCee1Iwm', '0003', 'jingguanceshiu3er@164.com3', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/efda12bd811d424ca939278aefc723ce0003.jpg', '2001-01-03', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080460267524', '刘世琦', '2836767535', '$2a$10$zZfvcS798wRgEkqWsfrSQOC4OX4DwOkNR5whEnkqydJB/oGAP2wu6', '0004', 'jingguanceshiu3er@164.com4', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/89d626d1f9ef417b921a030baf4bee250004.jpg', '2001-01-04', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080460267525', '颜鹏宇', '2836767535', '$2a$10$bcs8uBN/qVim8jXFrh1sxe0J8ej2I8LE1Zr4lxkXzR04rWT3UQr5i', '0005', 'jingguanceshiu3er@164.com5', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/8a8a8fde2c214b1ba19b07e349f0d71a0005.jpg', '2001-01-05', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080460267526', '高志锋', '2836767535', '$2a$10$FRddP9Qy..Q0FzbEEiogDOamxpokfYBvCZfzPeLkdJKb.a4Ey8CCu', '0006', 'jingguanceshiu3er@164.com6', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/985eb963af794d419cc4c9393f125c020006.jpg', '2001-01-06', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080460267527', '李婷', '2836767535', '$2a$10$QymKdCJofABsTyh6Du7TfOf8KzwUsMY.sG1B4CsyiU9/KgGpe7l9W', '0007', 'jingguanceshiu3er@164.com7', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/06d7f93786ca40e4ada10835297c578e0007.jpg', '2001-01-07', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080460267528', '孙科威', '2836767535', '$2a$10$WsRQUDKkHniMndcUvukGbOz.cCgbDF6YLYKAS0hpVMtDzpRZ5o7.G', '0008', 'jingguanceshiu3er@164.com8', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/a6c7ae9d3ad24286a2e59344ea01dec60008.jpg', '2001-01-08', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656129', '介智森', '2836767535', '$2a$10$qf1.1LMFn/PnratXwmJspubvh00dVYZfb22GJ3.aCjUL36OEK3OIy', '0009', 'jingguanceshiu3er@164.com9', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/260a4e41df24498dbe07a36e96803d3d0009.jpg', '2001-01-09', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656130', '王雅文', '2836767535', '$2a$10$dT0.JSguTmzjE91CbmEPxeh92D6dAh8AjTj7dWwbijZt65pQ03Ggu', '0010', 'jingguanceshiu3er@164.com10', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/e3188e4210764eb9ace628e7911ccd600010.jpg', '2001-01-10', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656131', '朱培龙', '2836767535', '$2a$10$xwK.iKjaCHCkbfdHCYFH1OQHbT7X59dozbFX8wKjW0MjhE3m/.DQ.', '0011', 'jingguanceshiu3er@164.com11', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/0c6afe84d8a84bac9b806d40f06fe17f0011.jpg', '2001-01-11', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656132', '曹龙生', '2836767535', '$2a$10$OTo3cf5XZObk3PVwFFze9OyxyHxu.1WAEw7.iLmK2fpQxjGcbcaXa', '0012', 'jingguanceshiu3er@164.com12', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/c533f70119e849e6b40b4b48ebc060440012.jpg', '2001-01-12', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656133', '程亮亮', '2836767535', '$2a$10$gobsYHs/nUqDhi.DgBxjbuzIXtHi.WI8uIZCjy0uwn2d1kRptemNW', '0013', 'jingguanceshiu3er@164.com13', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/8a163c8de5a94b64aa86a800c4f6b6670013.jpg', '2001-01-13', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656134', '代世杰', '2836767535', '$2a$10$Ncm6cOMIlTY4VQMZTL5itOapvKciTY.TcbTMD63htar/MCuAyotPi', '0014', 'jingguanceshiu3er@164.com14', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/c34f9e8ebcf24ed7ab73ab74a6f2bf360014.jpg', '2001-01-14', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656135', '王路营', '2836767535', '$2a$10$NiN4ZfcMKPvAYX2uc4KOSO440VHyqNb2z8IQBsHYiIFxcBttLz7J2', '0015', 'jingguanceshiu3er@164.com15', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/2c43c73c5c2b45ee9113847a34bd68fd0015.jpg', '2001-01-15', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656136', '赵冰', '2836767535', '$2a$10$eA/IeD4pY9i7Ah6QNTUI1Osm1yBnSVTy6neLIWKuslYU/jEOL.Mmy', '0016', 'jingguanceshiu3er@164.com16', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/a06e959c3e5b4bb780429ede45cdf5f60016.jpg', '2001-01-16', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080468656137', '陈安哲', '2836767535', '$2a$10$oMB2XacS31N.23KL6vOwSuZ6SgYVADw9KG6AU91UvwRi7pk1H.odK', '0017', 'jingguanceshiu3er@164.com17', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/006925ceee6f49018075822365fb55230017.jpg', '2001-01-17', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044738', '刘愚诚', '2836767535', '$2a$10$msu0r0Vk2j5d2FnbUME5SOkXAnjtprLppGvDPLP3NSN.WY24F3d3i', '0018', 'jingguanceshiu3er@164.com18', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/03aa2fc5a3b24d949a55c92625cbb94f0018.jpg', '2001-01-18', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044739', '袁燕茹', '2836767535', '$2a$10$8upz2QH3v9ZjQIMnJZdzFuVxZDY.RX4VPYjtJMl5XEPrQj8S0mFpK', '0019', 'jingguanceshiu3er@164.com19', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/04c3f4b021414842865bf491a500ca720019.jpg', '2001-01-19', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044740', '宋诗语', '2836767535', '$2a$10$6cqxnIBkiVXahX/ZbpW6J.FxgVIpTdZ0VWxOSwbqFeKpoyXLV8t32', '0020', 'jingguanceshiu3er@164.com20', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/8b7881d063ed4c2a9419ba4c33cfe99b0020.jpg', '2001-01-20', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044741', '任欣然', '2836767535', '$2a$10$/0mTQHAYCHrcWOBB6vBIXedRFyWLf0I31bfS1/9KrW2GQQ6R0/79C', '0021', 'jingguanceshiu3er@164.com21', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/487d6e6fa3074fc9a05622ab09aea8af0021.jpg', '2001-01-21', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044742', '乔浩杰', '2836767535', '$2a$10$v8ERdwx7sW8BQ8M9agNm1Oqlps34ftKXD6TUnIp8Wd0IukE7dxMW6', '0022', 'jingguanceshiu3er@164.com22', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/006c4ba2699b4bb49e41e612517435f90022.jpg', '2001-01-22', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044743', '樊艺轲', '2836767535', '$2a$10$rQBuFwmzEj3g6Dv63cT9dO5u5x5gSApb6MYKzMZPsadj13OQtwcYW', '0023', 'jingguanceshiu3er@164.com23', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/2a55db0876ae402e8f966cd0c9e783710023.jpg', '2001-01-23', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044744', '史毅博', '2836767535', '$2a$10$dv3ASitnQYKjvGt3faIA7O1ewKlk5KJVoaSwN9aw7v2T9nTblRoBm', '0024', 'jingguanceshiu3er@164.com24', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/e1652bb8b51c4157baba577cda75e7780024.jpg', '2001-01-24', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044745', '宋芊慧', '2836767535', '$2a$10$V8dpqHNjH7.niMXashJjpO2LOmcvEUthyM/LqIhi2xyFQ1hmbNgN2', '0025', 'jingguanceshiu3er@164.com25', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/ced423a61dcb438b88b3d0e2a65812e00025.jpg', '2001-01-25', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080477044746', '宋子健', '2836767535', '$2a$10$/NjXrMCy6ktY95gHFu80oOqFU26WgLMucYPUqUrQx2eD5lnRzUplq', '0026', 'jingguanceshiu3er@164.com26', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/30573a2045204b58a01441fec8f075830026.jpg', '2001-01-26', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080485433345', '王传友', '2836767535', '$2a$10$QpVlqYdWpPyGDIx5HBXSAu/CtU9451oIeNGYvSTGQ.g8ry6.WWJoS', '0027', 'jingguanceshiu3er@164.com27', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/72a8c230beab4a948ef9868e3d03e1fa0027.jpg', '2001-01-27', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080485433346', '董倩倩', '2836767535', '$2a$10$7ZxmqfUnON06ViD.XDQJReI/QWPVaw8.5Qyc7OcoExOBDrvnAv5DG', '0028', 'jingguanceshiu3er@164.com28', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/05afec1ee9f24607b17b019170c07f990028.jpg', '2001-01-28', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080485433347', '王楷波', '2836767535', '$2a$10$B9sYYBpAsMcnQXdkdJ7NPu1NSKIxd/ANUJ5n6wGTXSvkn1mra.TCK', '0029', 'jingguanceshiu3er@164.com29', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/448364d27e9742bb8760cc14034933b00029.jpg', '2001-01-29', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080485433348', '董文磊', '2836767535', '$2a$10$PhfnVcd/9SZ0daGpKW8/zOGZLS4H3qWaAVf8Q4rLnkgd5yLxZkaXC', '0030', 'jingguanceshiu3er@164.com30', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/a68c22341138435eb306c9d894252cc00030.jpg', '2001-01-30', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887080489627650', '刘鑫琪', '2836767535', '$2a$10$obSz0oJj0T826YC2OnFfOOx4YQTO2o7U4uA1FWVF6o5I73Tsc7j0u', '0031', 'jingguanceshiu3er@164.com31', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/825e8c15fa904b86aaa49e7e62b4995a0031.jpg', '2001-01-31', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:24', 0);
INSERT INTO `tbl_user` VALUES ('1539887086042886146', '寇瑜', '2836767535', '$2a$10$3xbx3sCoziuZ6uH9Q.DAuerRpdZ1KfCa5RWAr7NzY6McpabSDjjge', '0032', 'jingguanceshiu3er@164.com32', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/eadd2f71224f4b2e8ad97ea64cbbf6490032.jpg', '2001-02-01', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274754', '李展', '2836767535', '$2a$10$ZvCvK0KHOjawgz8aIymwyOrSJY.AwxdwBr9a5pt3787/0LRwIpNxu', '0033', 'jingguanceshiu3er@164.com33', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/5445e9b674564d1d9c65c641d818d2d60033.jpg', '2001-02-02', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274755', '张雨鑫', '2836767535', '$2a$10$xd.jiBVdyJVQXDbgsBB/euAsbUXk7ny3wkSHrYmsx2N5unNnNJRk.', '0034', 'jingguanceshiu3er@164.com34', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/b19e7a2e4f3345d999c4277fde4458020034.jpg', '2001-02-03', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274756', '牛艺星', '2836767535', '$2a$10$hToEh5siDQT5Qo/C19LAa.JjbXx3a/.84Zu8hfKJIeJFW61Jaw096', '0035', 'jingguanceshiu3er@164.com35', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/d12b9d34d08c41ff8d54745ede720b5f0035.jpg', '2001-02-04', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274757', '杨怡鹏', '2836767535', '$2a$10$/dZJVBDHoQE9iZrSVZkcwe.pPFT.3DhX7QpH99XjVE9c4JTPCGuam', '0036', 'jingguanceshiu3er@164.com36', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/f645651918cc466aa50f49632fd85b7e0036.jpg', '2001-02-05', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274758', '王一赫', '2836767535', '$2a$10$42e9JujcVBrbkq3oifcR.uH9rZpIsNX41ZJmbdC/99QBZaRgstAX6', '0037', 'jingguanceshiu3er@164.com37', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/f5bd5551964f41179e03e2f8b02667770037.jpg', '2001-02-06', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274759', '杨楠', '2836767535', '$2a$10$jRrFAm/jxxcNgE4uc9R.x.oaN.VHZC7GR08GuNTLKMd6kgExYmP0.', '0038', 'jingguanceshiu3er@164.com38', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/5fd691d6dda84207ae696d7a86e531990038.jpg', '2001-02-07', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274760', '刘家震', '2836767535', '$2a$10$Yud5NylgIoFN.kGNQQlj8e7nxveDyFmFwNxtj7ME43bX9BaNzyaKO', '0039', 'jingguanceshiu3er@164.com39', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/8411b149320b45aeaa97f91fdda0b93f0039.jpg', '2001-02-08', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539887086051274761', '云成征', '2836767535', '$2a$10$dAf9jv4V.0Oh52CpoOW3YeuylC.RX.3an5PHY/.bVhXjVjBji.u/G', '0040', 'jingguanceshiu3er@164.com40', 0, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/9dd0e7d5fd7f461085433ba451e008ec0040.jpg', '2001-02-09', '606bb18d16004ae5afe51cddc892dc4e', NULL, '2022-06-23 16:24:26', 0);
INSERT INTO `tbl_user` VALUES ('1539893909600874497', '说明文档用户1', '15011111111', '$2a$10$xfb5xZ5T6wwZzQVCde4Gjuy/RV.zdWI994ovRkkbLrv5d08sje15e', '410219199912011111', 'ShuoMing1@test.com', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/6ea3f54b4bdc4bc2b2bd54edc22e4569410219199912011111.jpg', '2022-06-01', '108cb0f600ac49568e3065c48f5c063e', NULL, '2022-06-23 16:54:59', 0);
INSERT INTO `tbl_user` VALUES ('1539895851349716993', '说明文档测试用户2', '17666666667', '$2a$10$PF47VUyVLqpYvQb2lQ1nD.81sLGLocpjlxa6HIkjkxOFIDjTALcoq', '123456709111111112', 'jing212312ceshiuser@163.com', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/06/23/720ddbde93894345841de219eced70ac123456709111111112.jpg', '2001-01-01', '108cb0f600ac49568e3065c48f5c063e', NULL, '2022-06-23 16:59:16', 0);
INSERT INTO `tbl_user` VALUES ('1543176098589941761', '时博帅2号', '17666626667', '$2a$10$gM/MNRF5cTHCtozW6tP/y.n2EoTwQwhDhKh2TolReI06n.Hu1bF6G', '16666666661111112', '3135419729@qq.com', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/07/02/e18faaa1ae244bc39f17425b93381d3e16666666661111112.jpg', '2001-01-01', '50050ae9020e4cb381e7a1259d8fb9a0', NULL, '2022-07-02 18:13:47', 1);
INSERT INTO `tbl_user` VALUES ('1543176863500967938', '时博帅2号', '17666626667', '$2a$10$oZN4WaUYFDvvVB9m8V/sXe0PzyNgphNgXKbiXdJ6uGv0.9hZAOU6K', '668888888888888888', '3135419729@qq.com', 1, 'https://facesign2022.oss-cn-beijing.aliyuncs.com/2022/07/02/186c9dc07dfb4f5f87cee76fce313797668888888888888888.jpg', '2001-01-01', '50050ae9020e4cb381e7a1259d8fb9a0', NULL, '2022-07-02 18:16:50', 0);

SET FOREIGN_KEY_CHECKS = 1;