基于SSM+微信小程序的学生宿舍管理系统

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: springbootn73cv -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `springbootn73cv` -- /*!40000 DROP DATABASE IF EXISTS `springbootn73cv`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootn73cv` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `springbootn73cv`; -- -- Table structure for table `baoxiuchuli` -- DROP TABLE IF EXISTS `baoxiuchuli`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `baoxiuchuli` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `baoxiubianhao` varchar(200) DEFAULT NULL COMMENT '报修编号', `baoxiumingcheng` varchar(200) NOT NULL COMMENT '报修名称', `guzhangtupian` varchar(200) DEFAULT NULL COMMENT '故障图片', `chulijianshu` longtext COMMENT '处理简述', `chuliriqi` date DEFAULT NULL COMMENT '处理日期', `chulizhuangtai` varchar(200) NOT NULL COMMENT '处理状态', `xuehao` varchar(200) DEFAULT NULL COMMENT '学号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', `sushehao` varchar(200) DEFAULT NULL COMMENT '宿舍号', `suguanzhanghao` varchar(200) DEFAULT NULL COMMENT '宿管账号', `suguanxingming` varchar(200) DEFAULT NULL COMMENT '宿管姓名', `houqinzhanghao` varchar(200) DEFAULT NULL COMMENT '后勤账号', `houqinxingming` varchar(200) DEFAULT NULL COMMENT '后勤姓名', `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话', `userid` bigint(20) DEFAULT NULL COMMENT '用户id', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='报修处理'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `baoxiuchuli` -- LOCK TABLES `baoxiuchuli` WRITE; /*!40000 ALTER TABLE `baoxiuchuli` DISABLE KEYS */; INSERT INTO `baoxiuchuli` VALUES (131,'2022-03-07 08:35:10','报修编号1','报修名称1','upload/baoxiuchuli_guzhangtupian1.jpg','处理简述1','2022-03-07','已修好','学号1','姓名1','手机1','宿舍号1','宿管账号1','宿管姓名1','后勤账号1','后勤姓名1','联系电话1',1),(132,'2022-03-07 08:35:10','报修编号2','报修名称2','upload/baoxiuchuli_guzhangtupian2.jpg','处理简述2','2022-03-07','已修好','学号2','姓名2','手机2','宿舍号2','宿管账号2','宿管姓名2','后勤账号2','后勤姓名2','联系电话2',2),(133,'2022-03-07 08:35:10','报修编号3','报修名称3','upload/baoxiuchuli_guzhangtupian3.jpg','处理简述3','2022-03-07','已修好','学号3','姓名3','手机3','宿舍号3','宿管账号3','宿管姓名3','后勤账号3','后勤姓名3','联系电话3',3),(134,'2022-03-07 08:35:10','报修编号4','报修名称4','upload/baoxiuchuli_guzhangtupian4.jpg','处理简述4','2022-03-07','已修好','学号4','姓名4','手机4','宿舍号4','宿管账号4','宿管姓名4','后勤账号4','后勤姓名4','联系电话4',4),(135,'2022-03-07 08:35:10','报修编号5','报修名称5','upload/baoxiuchuli_guzhangtupian5.jpg','处理简述5','2022-03-07','已修好','学号5','姓名5','手机5','宿舍号5','宿管账号5','宿管姓名5','后勤账号5','后勤姓名5','联系电话5',5),(136,'2022-03-07 08:35:10','报修编号6','报修名称6','upload/baoxiuchuli_guzhangtupian6.jpg','处理简述6','2022-03-07','已修好','学号6','姓名6','手机6','宿舍号6','宿管账号6','宿管姓名6','后勤账号6','后勤姓名6','联系电话6',6); /*!40000 ALTER TABLE `baoxiuchuli` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `config` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `name` varchar(100) NOT NULL COMMENT '配置参数名称', `value` varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forum` -- DROP TABLE IF EXISTS `forum`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `forum` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `title` varchar(200) DEFAULT NULL COMMENT '帖子标题', `content` longtext NOT NULL COMMENT '帖子内容', `parentid` bigint(20) DEFAULT NULL COMMENT '父节点id', `userid` bigint(20) NOT NULL COMMENT '用户id', `username` varchar(200) DEFAULT NULL COMMENT '用户名', `isdone` varchar(200) DEFAULT NULL COMMENT '状态', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8 COMMENT='交流社区'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `forum` -- LOCK TABLES `forum` WRITE; /*!40000 ALTER TABLE `forum` DISABLE KEYS */; INSERT INTO `forum` VALUES (201,'2022-03-07 08:35:10','帖子标题1','帖子内容1',0,1,'用户名1','开放'),(202,'2022-03-07 08:35:10','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(203,'2022-03-07 08:35:10','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(204,'2022-03-07 08:35:10','帖子标题4','帖子内容4',0,4,'用户名4','开放'),(205,'2022-03-07 08:35:10','帖子标题5','帖子内容5',0,5,'用户名5','开放'),(206,'2022-03-07 08:35:10','帖子标题6','帖子内容6',0,6,'用户名6','开放'); /*!40000 ALTER TABLE `forum` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `genghuanshenqing` -- DROP TABLE IF EXISTS `genghuanshenqing`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `genghuanshenqing` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `shenqingbianhao` varchar(200) DEFAULT NULL COMMENT '申请编号', `yuansushehao` varchar(200) NOT NULL COMMENT '原宿舍号', `xinsushehao` varchar(200) NOT NULL COMMENT '新宿舍号', `genghuanyuanyin` longtext NOT NULL COMMENT '更换原因', `shenqingshijian` datetime DEFAULT NULL COMMENT '申请时间', `xuehao` varchar(200) DEFAULT NULL COMMENT '学号', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `shouji` varchar(200) DEFAULT NULL COMMENT '手机', `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片', `suguanzhanghao` varchar(200) DEFAULT NULL COMMENT '宿管账号', `suguanxingming` varchar(200) DEFAULT NULL COMMENT '宿管姓名', `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核', `shhf` longtext COMMENT '审核回复', `userid` bigint(20) DEFAULT NULL COM