/*
 Navicat Premium Data Transfer

 Source Server         : 123
 Source Server Type    : MySQL
 Source Server Version : 80017
 Source Host           : localhost:3306
 Source Schema         : lzh_dormitory

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

 Date: 26/03/2022 21:07:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dorm
-- ----------------------------
DROP TABLE IF EXISTS `dorm`;
CREATE TABLE `dorm`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `gmt_create` datetime(6) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '创建的时间',
  `gmt_modified` datetime(6) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '更改的时间',
  `room` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '宿舍寝室编号',
  `electric` float(10, 1) NOT NULL DEFAULT 0.0 COMMENT '电费',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dorm
-- ----------------------------
INSERT INTO `dorm` VALUES (1, '2022-03-15 16:13:23.723000', '2022-03-15 16:13:23.723000', '7101', 21.1);
INSERT INTO `dorm` VALUES (2, '2022-03-15 16:13:28.536293', '2022-03-15 16:13:28.536293', '7102', 10.1);
INSERT INTO `dorm` VALUES (3, '2022-03-15 16:13:43.239802', '2022-03-15 16:13:43.239802', '7103', 14.2);
INSERT INTO `dorm` VALUES (4, '2022-03-15 16:13:17.000000', '2022-03-15 16:13:19.000000', '7104', 10.0);
INSERT INTO `dorm` VALUES (5, '2022-03-15 16:14:30.520344', '2022-03-15 16:14:28.000000', '7105', 23.0);
INSERT INTO `dorm` VALUES (6, '2022-03-15 16:14:59.910327', '2022-03-15 16:14:59.910327', '7106', 0.0);
INSERT INTO `dorm` VALUES (7, '2022-03-15 16:16:02.000000', '2022-03-15 16:16:06.000000', '7107', 0.0);
INSERT INTO `dorm` VALUES (8, '2022-03-15 16:16:34.000000', '2022-03-15 16:16:37.000000', '7108', 0.0);
INSERT INTO `dorm` VALUES (9, '2022-03-15 16:17:56.494962', '2022-03-15 16:17:56.494962', '7109', 0.0);
INSERT INTO `dorm` VALUES (10, '2022-03-15 16:18:02.000000', '2022-03-15 16:18:04.000000', '7110', 0.0);
INSERT INTO `dorm` VALUES (11, '2022-03-15 16:18:31.000000', '2022-03-15 16:18:33.000000', '7201', 0.0);
INSERT INTO `dorm` VALUES (12, '2022-03-15 16:18:44.000000', '2022-03-15 16:18:46.000000', '7202', 0.0);
INSERT INTO `dorm` VALUES (15, '2022-03-23 12:47:17.993000', '2022-03-23 12:47:17.993000', '7203', 0.0);
INSERT INTO `dorm` VALUES (16, '2022-03-23 12:47:47.169000', '2022-03-23 12:47:47.169000', '7204', 0.0);
INSERT INTO `dorm` VALUES (17, '2022-03-26 11:27:45.000000', '2022-03-26 11:27:47.000000', '7222', 74.0);

-- ----------------------------
-- Table structure for dorm_manager
-- ----------------------------
DROP TABLE IF EXISTS `dorm_manager`;
CREATE TABLE `dorm_manager`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `gm_create` datetime(6) NULL DEFAULT NULL,
  `gmt_modified` datetime(6) NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '宿管名称',
  `home` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '管理楼栋',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dorm_manager
-- ----------------------------
INSERT INTO `dorm_manager` VALUES (1, '2022-03-16 20:06:59.000000', '2022-03-16 20:07:02.000000', '张阿姨', '一栋');
INSERT INTO `dorm_manager` VALUES (2, '2022-03-16 20:07:55.000000', '2022-03-16 20:07:58.000000', '李阿姨', '二栋');
INSERT INTO `dorm_manager` VALUES (3, '2022-03-16 20:07:43.000000', '2022-03-16 20:07:45.000000', '王阿姨', '三栋');
INSERT INTO `dorm_manager` VALUES (4, '2022-03-16 20:08:08.000000', '2022-03-16 20:08:10.000000', '杨阿姨', '四栋');
INSERT INTO `dorm_manager` VALUES (5, '2022-03-16 20:09:04.000000', '2022-03-16 20:09:09.000000', '陈阿姨', '五栋');
INSERT INTO `dorm_manager` VALUES (6, '2022-03-16 20:09:37.000000', '2022-03-16 20:09:40.000000', '刘阿姨', '六栋');
INSERT INTO `dorm_manager` VALUES (9, '2022-03-23 14:14:36.844000', '2022-03-23 14:14:36.844000', '刘文静', '一栋');

-- ----------------------------
-- Table structure for lose_found
-- ----------------------------
DROP TABLE IF EXISTS `lose_found`;
CREATE TABLE `lose_found`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `gm_create` datetime(6) NULL DEFAULT NULL,
  `gmt_modified` datetime(6) NULL DEFAULT NULL,
  `username` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '丢失物品的用户名称',
  `telephone` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '联系电话',
  `goods` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '丢失物品名称',
  `status` tinyint(255) NULL DEFAULT NULL COMMENT '状态0：未找回 1：已找回',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of lose_found
-- ----------------------------
INSERT INTO `lose_found` VALUES (1, '2022-03-17 10:13:01.000000', '2022-03-17 10:13:04.000000', '王五', '123123412', '校园卡', 0);
INSERT INTO `lose_found` VALUES (2, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (3, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (5, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 1);
INSERT INTO `lose_found` VALUES (6, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (7, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (8, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (9, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (10, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (11, '2022-03-17 11:23:22.000000', '2022-03-17 11:23:25.000000', '李四', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (12, '2022-03-18 11:23:22.000000', '2022-03-17 11:23:25.000000', '李2', '12312312312', '身份证', 0);
INSERT INTO `lose_found` VALUES (14, '2022-03-26 05:00:27.635000', '2022-03-26 05:00:27.635000', '张三', '123633274', '身份证', 0);

-- ----------------------------
-- Table structure for maintain
-- ----------------------------
DROP TABLE IF EXISTS `maintain`;
CREATE TABLE `maintain`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `gm_create` datetime(6) NOT NULL COMMENT '主动创建的时间(报表时间)',
  `gmt_modified` datetime(6) NOT NULL ON UPDATE CURRENT_TIMESTAMP(6) COMMENT '被动创建的时间（修改时间）',
  `dorm_id` int(255) NULL DEFAULT NULL COMMENT '寝室id',
  `type` int(10) NULL DEFAULT NULL COMMENT '维修类型',
  `status` tinyint(1) NULL DEFAULT 0 COMMENT '维修单是否完成(1：为完成 ，2：为未完成)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of maintain
-- ----------------------------
INSERT INTO `maintain` VALUES (1, '2022-03-16 20:10:34.000000', '2022-03-16 20:10:36.000000', 7222, 1, 0);
INSERT INTO `maintain` VALUES (2, '2022-03-23 23:11:00.000000', '2022-03-23 23:11:02.000000', 7221, 2, 1);
INSERT INTO `maintain` VALUES (4, '2022-03-26 02:33:18.294000', '2022-03-26 02:33:18.294000', 7222, 1, 0);

-- ----------------------------
-- Table structure for root
-- ----------------------------
DROP TABLE IF EXISTS `root`;
CREATE TABLE `root`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `describles` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of root
-- ----------------------------
INSERT INTO `root` VALUES (1, 'admin1', '123', '1233@123.com', '13523428924', '管理员大大');
INSERT INTO `root` VALUES (2, '王经理', 'd9b1d7db4cd6e70935368a1efb10e377', '1222233@123.com', '13684686221', NULL);
INSERT INTO `root` VALUES (3, '李四', '123', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `gm_create` datetime(6) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `gmt_modified` datetime(6) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(6),
  `type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '维修名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of type
-- ----------------------------
INSERT INTO `type` VALUES (1, '2022-03-16 19:58:01.000000', '2022-03-16 19:58:04.000000', '空调维修');
INSERT INTO `type` VALUES (2, '2022-03-16 19:58:09.000000', '2022-03-16 19:58:12.000000', '电风扇维修');
INSERT INTO `type` VALUES (3, '2022-03-16 19:59:07.000000', '2022-03-16 19:59:09.000000', '灯泡维修');
INSERT INTO `type` VALUES (4, '2022-03-16 19:59:17.000000', '2022-03-16 19:59:21.000000', '天花板漏水维修');
INSERT INTO `type` VALUES (5, '2022-03-16 20:00:29.000000', '2022-03-16 20:00:32.000000', '下水道维修');
INSERT INTO `type` VALUES (6, '2022-03-16 20:02:25.319126', '2022-03-16 20:02:25.319126', '电力维修');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `gmt_create` datetime(6) NULL DEFAULT NULL COMMENT '创建的时间',
  `gmt_modified` datetime(6) NULL DEFAULT NULL COMMENT '更改的时间',
  `user_account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户账号（默认弄成学号）',
  `user_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户密码',
  `user_type` int(255) NULL DEFAULT NULL COMMENT '用户类型',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名称',
  `sex` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '性别',
  `telephone` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '电话',
  `classes` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '班级',
  `dorm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '寝室号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (2, '2022-03-13 16:29:59.000000', '2022-03-15 16:29:54.000000', '5720181001', '123', 1, '张三', '男', '13143272905', '软件制造181', '7222');
INSERT INTO `user` VALUES (5, '2022-03-13 16:30:04.000000', '2022-03-15 16:29:57.000000', '5720181002', '123', 1, '李四', '男', '13143272902', '软件制造181', '7222');
INSERT INTO `user` VALUES (24, '2022-03-17 10:30:08.288000', '2022-03-17 10:30:08.288000', '5720181003', '123', 1, '芙蓉', '男', '13684846201', '软件制造182', '7222');
INSERT INTO `user` VALUES (25, '2022-03-17 10:35:21.881000', '2022-03-17 10:35:21.881000', '5720181004', '123', 1, '无敌畏', '男', NULL, '软件制造182', '7222');
INSERT INTO `user` VALUES (26, '2022-03-17 10:38:29.377000', '2022-03-17 10:38:29.377000', '5720181005', '123', 1, '王五1', '男', '13684846200', '软件制造182', '7222');

SET FOREIGN_KEY_CHECKS = 1;