-- MySQL dump 10.13  Distrib 5.6.51, for Linux (x86_64)
--
-- Host: localhost    Database: repair
-- ------------------------------------------------------
-- Server version	5.6.51

/*!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 */;

--
-- Table structure for table `sys_config`
--

DROP TABLE IF EXISTS `sys_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_config` (
  `config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '参数主键',
  `config_name` varchar(101) DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='参数配置表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_config`
--

LOCK TABLES `sys_config` WRITE;
/*!40000 ALTER TABLE `sys_config` DISABLE KEYS */;
INSERT INTO `sys_config` VALUES (1,'主框架页-默认皮肤样式名称','sys.index.skinName','skin-blue','Y','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'),(2,'用户管理-账号初始密码','sys.user.initPassword','123456','Y','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','初始化密码 123456'),(3,'主框架页-侧边栏主题','sys.index.sideTheme','theme-dark','Y','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','深黑主题theme-dark，浅色主题theme-light，深蓝主题theme-blue'),(4,'账号自助-是否开启用户注册功能','sys.account.registerUser','true','Y','admin','2018-03-16 11:33:00','admin','2022-02-01 17:19:48','是否开启注册用户功能（true开启，false关闭）'),(6,'主框架页-菜单导航显示风格','sys.index.menuStyle','default','Y','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','菜单导航显示风格（default为左侧导航菜单，topnav为顶部导航菜单）');
/*!40000 ALTER TABLE `sys_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dict_data`
--

DROP TABLE IF EXISTS `sys_dict_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dict_data` (
  `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(4) DEFAULT '0' COMMENT '字典排序',
  `dict_label` varchar(100) DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) DEFAULT NULL COMMENT '表格回显样式',
  `is_default` char(1) DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='字典数据表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dict_data`
--

LOCK TABLES `sys_dict_data` WRITE;
/*!40000 ALTER TABLE `sys_dict_data` DISABLE KEYS */;
INSERT INTO `sys_dict_data` VALUES (1,1,'男','0','sys_user_sex','','','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','性别男'),(2,2,'女','1','sys_user_sex','','','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','性别女'),(4,1,'显示','0','sys_show_hide','','primary','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','显示菜单'),(5,2,'隐藏','1','sys_show_hide','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','隐藏菜单'),(6,1,'正常','0','sys_normal_disable','','primary','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','正常状态'),(7,2,'停用','1','sys_normal_disable','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','停用状态'),(8,1,'正常','0','sys_job_status','','primary','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','正常状态'),(9,2,'暂停','1','sys_job_status','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','停用状态'),(10,1,'默认','DEFAULT','sys_job_group','','','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','默认分组'),(11,2,'系统','SYSTEM','sys_job_group','','','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统分组'),(12,1,'是','Y','sys_yes_no','','primary','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统默认是'),(13,2,'否','N','sys_yes_no','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统默认否'),(14,1,'通知','1','sys_notice_type','','warning','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','通知'),(15,2,'公告','2','sys_notice_type','','success','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','公告'),(16,1,'正常','0','sys_notice_status','','primary','Y','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','正常状态'),(17,2,'关闭','1','sys_notice_status','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','关闭状态'),(18,99,'其他','0','sys_oper_type','','info','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','其他操作'),(19,1,'新增','1','sys_oper_type','','info','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','新增操作'),(20,2,'修改','2','sys_oper_type','','info','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','修改操作'),(21,3,'删除','3','sys_oper_type','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','删除操作'),(22,4,'授权','4','sys_oper_type','','primary','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','授权操作'),(23,5,'导出','5','sys_oper_type','','warning','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','导出操作'),(24,6,'导入','6','sys_oper_type','','warning','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','导入操作'),(25,7,'强退','7','sys_oper_type','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','强退操作'),(26,8,'生成代码','8','sys_oper_type','','warning','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','生成操作'),(27,9,'清空数据','9','sys_oper_type','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','清空操作'),(28,1,'成功','0','sys_common_status','','primary','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','正常状态'),(29,2,'失败','1','sys_common_status','','danger','N','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','停用状态'),(30,0,'未处理','0','shenhe_state','','primary','Y','0','admin','2022-01-30 13:14:12','admin','2022-02-01 17:08:07',''),(31,1,'已分派','1','shenhe_state','','info','Y','0','admin','2022-01-30 13:14:19','admin','2022-02-01 17:08:14',''),(32,2,'已维修','2','shenhe_state','','danger','Y','0','admin','2022-01-30 13:14:29','admin','2022-02-01 17:08:24','');
/*!40000 ALTER TABLE `sys_dict_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_dict_type`
--

DROP TABLE IF EXISTS `sys_dict_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_dict_type` (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) DEFAULT '' COMMENT '字典类型',
  `status` char(1) DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE KEY `dict_type` (`dict_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='字典类型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_dict_type`
--

LOCK TABLES `sys_dict_type` WRITE;
/*!40000 ALTER TABLE `sys_dict_type` DISABLE KEYS */;
INSERT INTO `sys_dict_type` VALUES (1,'用户性别','sys_user_sex','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','用户性别列表'),(2,'菜单状态','sys_show_hide','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','菜单状态列表'),(3,'系统开关','sys_normal_disable','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统开关列表'),(6,'系统是否','sys_yes_no','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统是否列表'),(7,'审核状态','shenhe_state','0','admin','2022-01-30 13:13:53','',NULL,NULL);
/*!40000 ALTER TABLE `sys_dict_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_menu` (
  `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
  `parent_id` bigint(20) DEFAULT '0' COMMENT '父菜单ID',
  `order_num` int(4) DEFAULT '0' COMMENT '显示顺序',
  `url` varchar(200) DEFAULT '#' COMMENT '请求地址',
  `target` varchar(20) DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）',
  `menu_type` char(1) DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `perms` varchar(100) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) DEFAULT '#' COMMENT '菜单图标',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11131 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='菜单权限表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_menu`
--

LOCK TABLES `sys_menu` WRITE;
/*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
INSERT INTO `sys_menu` VALUES (1,'系统管理',0,1,'#','','M','0','','fa fa-gear','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统管理目录'),(3,'系统工具',0,3,'#','','M','1','','fa fa-bars','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','系统工具目录'),(100,'用户管理',1,1,'/system/user','','C','0','system:user:view','fa fa-user-o','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','用户管理菜单'),(101,'角色管理',1,2,'/system/role','','C','1','system:role:view','fa fa-user-secret','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','角色管理菜单'),(102,'菜单管理',1,3,'/system/menu','','C','1','system:menu:view','fa fa-th-list','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','菜单管理菜单'),(105,'字典管理',1,6,'/system/dict','','C','1','system:dict:view','fa fa-bookmark-o','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','字典管理菜单'),(106,'参数设置',1,7,'/system/config','','C','1','system:config:view','fa fa-sun-o','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','参数设置菜单'),(113,'表单构建',3,1,'/tool/build','','C','0','tool:build:view','fa fa-wpforms','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','表单构建菜单'),(114,'代码生成',3,2,'/tool/gen','','C','0','tool:gen:view','fa fa-code','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','代码生成菜单'),(1000,'用户查询',100,1,'#','','F','0','system:user:list','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1001,'用户新增',100,2,'#','','F','0','system:user:add','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1002,'用户修改',100,3,'#','','F','0','system:user:edit','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1003,'用户删除',100,4,'#','','F','0','system:user:remove','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1004,'用户导出',100,5,'#','','F','0','system:user:export','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1005,'用户导入',100,6,'#','','F','0','system:user:import','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1006,'重置密码',100,7,'#','','F','0','system:user:resetPwd','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1007,'角色查询',101,1,'#','','F','0','system:role:list','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1008,'角色新增',101,2,'#','','F','0','system:role:add','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1009,'角色修改',101,3,'#','','F','0','system:role:edit','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1010,'角色删除',101,4,'#','','F','0','system:role:remove','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1011,'角色导出',101,5,'#','','F','0','system:role:export','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1012,'菜单查询',102,1,'#','','F','0','system:menu:list','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1013,'菜单新增',102,2,'#','','F','0','system:menu:add','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1014,'菜单修改',102,3,'#','','F','0','system:menu:edit','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1015,'菜单删除',102,4,'#','','F','0','system:menu:remove','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1025,'字典查询',105,1,'#','','F','0','system:dict:list','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1026,'字典新增',105,2,'#','','F','0','system:dict:add','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1027,'字典修改',105,3,'#','','F','0','system:dict:edit','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1028,'字典删除',105,4,'#','','F','0','system:dict:remove','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1029,'字典导出',105,5,'#','','F','0','system:dict:export','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1030,'参数查询',106,1,'#','','F','0','system:config:list','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1031,'参数新增',106,2,'#','','F','0','system:config:add','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1032,'参数修改',106,3,'#','','F','0','system:config:edit','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1033,'参数删除',106,4,'#','','F','0','system:config:remove','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1034,'参数导出',106,5,'#','','F','0','system:config:export','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1057,'生成查询',114,1,'#','','F','0','tool:gen:list','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1058,'生成修改',114,2,'#','','F','0','tool:gen:edit','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1059,'生成删除',114,3,'#','','F','0','tool:gen:remove','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1060,'预览代码',114,4,'#','','F','0','tool:gen:preview','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(1061,'生成代码',114,5,'#','','F','0','tool:gen:code','#','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00',''),(11085,'意见反馈',0,3,'#','menuItem','M','0',NULL,'fa fa-bell','admin','2022-01-13 17:43:19','',NULL,''),(11098,'意见反馈',11085,1,'/system/fankui','','C','0','system:fankui:view','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00','意见反馈菜单'),(11099,'意见反馈查询',11098,1,'#','','F','0','system:fankui:list','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11100,'意见反馈新增',11098,2,'#','','F','0','system:fankui:add','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11101,'意见反馈修改',11098,3,'#','','F','0','system:fankui:edit','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11102,'意见反馈删除',11098,4,'#','','F','0','system:fankui:remove','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11103,'意见反馈导出',11098,5,'#','','F','0','system:fankui:export','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11104,'楼宇信息',0,2,'#','menuItem','M','0',NULL,'fa fa-bank','admin','2022-02-01 17:03:04','',NULL,''),(11105,'报修单管理',0,4,'#','menuItem','M','0',NULL,'fa fa-american-sign-language-interpreting','admin','2022-02-01 17:05:41','',NULL,''),(11106,'识别分类',0,5,'#','menuItem','M','0',NULL,'fa fa-book','admin','2022-02-01 17:06:08','',NULL,''),(11107,'楼宇信息',11104,1,'/system/louyu','','C','0','system:louyu:view','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00','楼宇信息菜单'),(11108,'楼宇信息查询',11107,1,'#','','F','0','system:louyu:list','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11109,'楼宇信息新增',11107,2,'#','','F','0','system:louyu:add','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11110,'楼宇信息修改',11107,3,'#','','F','0','system:louyu:edit','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11111,'楼宇信息删除',11107,4,'#','','F','0','system:louyu:remove','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11112,'楼宇信息导出',11107,5,'#','','F','0','system:louyu:export','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11113,'工种分配',11106,1,'/system/fenpei','','C','0','system:fenpei:view','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00','工种分配菜单'),(11114,'工种分配查询',11113,1,'#','','F','0','system:fenpei:list','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11115,'工种分配新增',11113,2,'#','','F','0','system:fenpei:add','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11116,'工种分配修改',11113,3,'#','','F','0','system:fenpei:edit','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11117,'工种分配删除',11113,4,'#','','F','0','system:fenpei:remove','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11118,'工种分配导出',11113,5,'#','','F','0','system:fenpei:export','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11119,'报修单',11105,1,'/system/baoxiu','','C','0','system:baoxiu:view','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00','报修单菜单'),(11120,'报修单查询',11119,1,'#','','F','0','system:baoxiu:list','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11121,'报修单新增',11119,2,'#','','F','0','system:baoxiu:add','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11122,'报修单修改',11119,3,'#','','F','0','system:baoxiu:edit','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11123,'报修单删除',11119,4,'#','','F','0','system:baoxiu:remove','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11124,'报修单导出',11119,5,'#','','F','0','system:baoxiu:export','#','admin','2018-03-01 00:00:00','ry','2018-03-01 00:00:00',''),(11125,'维修识别',11119,6,'#','menuItem','F','0','system:weixiu:shibie','#','admin','2022-02-01 19:38:06','',NULL,''),(11126,'学生管理',1,5,'/system/user/xuesheng','','C','0','system:user:view','#','admin',NULL,'',NULL,'学生管理'),(11127,'维修工管理',1,4,'/system/user/weixiugong','','C','0','system:user:view','#','admin',NULL,'',NULL,''),(11128,'管理员管理',1,8,'/system/user/admin','','C','0','system:user:view','#','admin',NULL,'',NULL,''),(11129,'通知管理',1,9,'/system/notice','','C','0','system:notice:view','#','admin',NULL,'',NULL,''),(11130,'通知回复管理',1,10,'/system/reply','','C','0','system:noticereply:view','#','admin',NULL,'',NULL,'');
/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role` (
  `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(30) NOT NULL COMMENT '角色名称',
  `role_key` varchar(100) NOT NULL COMMENT '角色权限字符串',
  `role_sort` int(4) NOT NULL COMMENT '显示顺序',
  `data_scope` char(1) DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `status` char(1) NOT NULL COMMENT '角色状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'超级管理员','admin',1,'1','0','0','admin','2018-03-16 11:33:00','ry','2018-03-16 11:33:00','超级管理员'),(2,'管理员','system',2,'2','0','0','admin','2018-03-16 11:33:00','admin','2022-02-01 20:01:20','普通角色'),(3,'维修工','weixiu',3,'1','0','0','admin','2022-02-01 17:10:13','admin','2022-02-01 19:37:16',''),(4,'学生','stu',4,'1','0','0','admin','2022-02-01 17:10:23','admin','2022-02-01 17:30:32','');
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_menu`
--

DROP TABLE IF EXISTS `sys_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_menu` (
  `role_id` bigint(20) NOT NULL COMMENT '角色ID',
  `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`role_id`,`menu_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色和菜单关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_menu`
--

LOCK TABLES `sys_role_menu` WRITE;
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
INSERT INTO `sys_role_menu` VALUES (2,1),(2,100),(2,1000),(2,1001),(2,1002),(2,1003),(2,1004),(2,1005),(2,1006),(2,11085),(2,11098),(2,11099),(2,11101),(2,11104),(2,11105),(2,11106),(2,11107),(2,11108),(2,11109),(2,11110),(2,11111),(2,11112),(2,11113),(2,11114),(2,11115),(2,11116),(2,11117),(2,11118),(2,11119),(2,11120),(2,11122),(2,11125),(3,11105),(3,11119),(3,11120),(4,11085),(4,11098),(4,11099),(4,11100),(4,11105),(4,11119),(4,11120),(4,11121);
/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `login_name` varchar(30) NOT NULL COMMENT '登录账号',
  `user_name` varchar(30) DEFAULT '' COMMENT '用户昵称',
  `user_type` varchar(2) DEFAULT '00' COMMENT '用户类型（00系统用户 01注册用户）',
  `email` varchar(50) DEFAULT '' COMMENT '用户邮箱',
  `phonenumber` varchar(11) DEFAULT '' COMMENT '手机号码',
  `sex` char(1) DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）',
  `avatar` varchar(100) DEFAULT '' COMMENT '头像路径',
  `password` varchar(50) DEFAULT '' COMMENT '密码',
  `salt` varchar(20) DEFAULT '' COMMENT '盐加密',
  `status` char(1) DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `del_flag` char(1) DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `login_ip` varchar(50) DEFAULT '' COMMENT '最后登录IP',
  `login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
  `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `role_id` int(11) DEFAULT NULL,
  `gongzhong` varchar(255) DEFAULT NULL COMMENT '工种',
  `xueyuan` varchar(255) DEFAULT NULL COMMENT '学院',
  `banji` varchar(255) DEFAULT NULL COMMENT '班级',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` VALUES (1,'admin','admin','00','ry@163.com','15888888888','0','','828712444e0696adf6ee5e0c7d1e41bf','838708','0','0','127.0.0.1','2022-04-26 16:21:37','admin','2018-03-16 11:33:00','ry','2022-04-26 16:21:32','管理员',1,NULL,NULL,NULL),(2,'ry','ry','00','ry@qq.com','15666666666','1','','161b08b5fb5ef466c12463eeacb7ccf6','ae3155','0','0','127.0.0.1','2022-02-01 21:01:04','admin','2018-03-16 11:33:00','ry','2022-02-01 21:01:03','测试员',2,NULL,NULL,NULL),(4,'stu001','张三','01','1678735375@qq.com','17733332222','0','','64cad01ea07f56ad1976c689830d84e8','ef263c','0','0','127.0.0.1','2022-02-01 20:09:44','','2022-02-01 17:23:36','admin','2022-02-01 20:09:43','',4,NULL,'计算机学院','软件工程一班1'),(8,'weixiu1','weixiu1','00','16783375@qq.com','18733223216','0','','c9de63bcb46591d57c6fb05098dc55f2','1b91f6','0','0','127.0.0.1','2022-02-01 20:53:35','admin','2022-02-01 19:36:28','','2022-02-01 20:53:34',NULL,3,'木工','',''),(9,'stu002','张同学','01','','18733332222','0','','a0bfedeaa01f39db9343fde8b93704ea','9a80fd','0','0','127.0.0.1','2022-02-01 20:53:43','','2022-02-01 20:47:38','','2022-02-01 20:53:43',NULL,4,NULL,'计算机科学与技术','软件工程一班'),(10,'weixiu','维修工1','00','1678735376@qq.com','17756123234','0','','221a583c87a039ce85568854ee0f6d1d','bcec4f','0','0','127.0.0.1','2022-04-21 17:33:07','admin','2022-02-01 20:50:45','ry','2022-04-21 17:33:01','',3,'水工','',''),(11,'stu003','刘同学','01','','18733334444','0','','b15cb27de938d15434eb3dc5472fc824','cc249c','0','0','127.0.0.1','2022-03-09 22:00:58','','2022-02-01 20:57:28','','2022-03-09 22:00:57',NULL,4,NULL,'计算机学院','软件工程一班'),(12,'star','cbai1','01','xy.2014@qq.com','15610606071','0','','9f89bfeb2d34eb80c5644e721b6ed56d','a29f28','0','2','127.0.0.1','2022-04-11 18:11:49','','2022-04-11 17:19:02','admin','2022-04-11 18:37:02','',4,NULL,'计算机','2'),(13,'qaq','qaq','01','','15610606071','0','','1d547e7e373807d556a3af1de4080412','a9745e','0','0','127.0.0.1','2022-04-20 14:16:20','','2022-04-11 18:30:54','','2022-04-20 14:16:19',NULL,4,NULL,'qwqw','131'),(14,'star1','star11','00','xy.20013@qq.com','15610606072','0','','c447b31b57038c19de594a17564b0988','bd9318','0','0','127.0.0.1','2022-04-11 18:38:40','admin','2022-04-11 18:38:13','admin','2022-04-13 16:10:12','',4,'选择工种','',''),(15,'testdept','test','01','','15610606071','0','','c1b7d37c3d3f607f59162a480c867184','2c1748','0','0','',NULL,'','2022-04-12 21:59:54','',NULL,NULL,4,NULL,'音乐学院','12122'),(16,'testbanji','testbanji','01','984460054@qq.com','15610606073','0','','fe40dda24e17f29aa59f606d010d9afc','31739b','0','0','',NULL,'','2022-04-13 09:38:58','admin','2022-04-13 11:00:15','',4,NULL,'软件学院','2020软件工程2班'),(17,'testtel','testtel','01','','156106060','0','','3231e01a928482dcfffb0394316d042f','7196b8','0','0','',NULL,'','2022-04-13 12:42:08','',NULL,NULL,4,NULL,'通识学院','2020国学1班'),(18,'admin232','243222','01','','156106060','0','','37281a1007b3ffd98a58c34986f5ce94','e051f1','0','0','',NULL,'','2022-04-13 12:50:15','',NULL,NULL,4,NULL,'软件学院','2020软件工程2班'),(19,'admin34252','52523525','01','','156106060','0','','04b60ed9aa6078a96d1f46108632d323','528838','0','0','',NULL,'','2022-04-13 12:53:16','',NULL,NULL,4,NULL,'计算机学院','2020计算机科学与技术2班'),(20,'admin54352','2525235','01','','156106060','0','','5ba47c570d8bf88662e6f5980c80214a','14a7b1','0','0','',NULL,'','2022-04-13 12:53:47','',NULL,NULL,4,NULL,'音乐学院','2020钢琴2班'),(21,'weixiu3','weixiu3','00','2523524544@qq.com','15610606075','0','','0f1fe642772df35ef60b58c1f74c0684','2918bb','0','0','',NULL,'admin','2022-04-20 14:28:00','',NULL,NULL,3,'木工','','');
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_online`
--

DROP TABLE IF EXISTS `sys_user_online`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_online` (
  `sessionId` varchar(50) NOT NULL DEFAULT '' COMMENT '用户会话id',
  `login_name` varchar(50) DEFAULT '' COMMENT '登录账号',
  `dept_name` varchar(50) DEFAULT '' COMMENT '部门名称',
  `ipaddr` varchar(50) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` varchar(10) DEFAULT '' COMMENT '在线状态on_line在线off_line离线',
  `start_timestamp` datetime DEFAULT NULL COMMENT 'session创建时间',
  `last_access_time` datetime DEFAULT NULL COMMENT 'session最后访问时间',
  `expire_time` int(5) DEFAULT '0' COMMENT '超时时间，单位为分钟',
  PRIMARY KEY (`sessionId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='在线用户记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_online`
--

LOCK TABLES `sys_user_online` WRITE;
/*!40000 ALTER TABLE `sys_user_online` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_user_online` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_baoxiu`
--

DROP TABLE IF EXISTS `t_baoxiu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_baoxiu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `danhao` varchar(255) DEFAULT NULL COMMENT '单号',
  `xingming` varchar(255) NOT NULL COMMENT '姓名',
  `dizhi` varchar(255) NOT NULL COMMENT '地址',
  `leixing` varchar(255) NOT NULL COMMENT '维修类型',
  `yuanyin` varchar(255) NOT NULL COMMENT '故障原因',
  `img_path` varchar(255) NOT NULL COMMENT '故障图片',
  `state` varchar(255) DEFAULT NULL COMMENT '状态',
  `weixiuren` varchar(255) DEFAULT NULL COMMENT '维修人',
  `wupinleibie` varchar(255) DEFAULT NULL COMMENT '物品类别',
  `gongzhong` varchar(255) DEFAULT NULL COMMENT '维修工种',
  `pingjia` varchar(255) DEFAULT NULL COMMENT '评价',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='报修单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_baoxiu`
--

LOCK TABLES `t_baoxiu` WRITE;
/*!40000 ALTER TABLE `t_baoxiu` DISABLE KEYS */;
INSERT INTO `t_baoxiu` VALUES (1,'W1643708222899','张三','一号宿舍楼3单元303','类型','原因','/profile/upload/2022/02/01/f4749bda-04dc-4b82-837a-e05f55af218d.jpg','2','weixiu1','商品-家具','木工','真不错','stu001','2022-02-01 17:37:03'),(2,'W1643716836774','张三','123','123','132','/profile/upload/2022/02/01/644b0b6a-cc6a-44a7-b80b-0f544ab86e86.jpg','2','weixiu1','非自然图像-屏幕截图','木工',NULL,'stu001','2022-02-01 20:00:37'),(3,'W1643719700465','张同学','一号楼3单元303','维修类型','原因','/profile/upload/2022/02/01/b84c5df6-5aaf-4189-b016-195305053d8a.jpg','2','weixiu1','商品-家具','木工','aaaass是是是','stu002','2022-02-01 20:48:20'),(4,'W1643720041128','张同学','1231','123','123','/profile/upload/2022/02/01/bddcb651-d0df-4180-8a84-4cf7b195a65d.jpg','0',NULL,'商品-洁具','水工',NULL,'stu002','2022-02-01 20:54:01'),(5,'W1643720281362','刘同学','一号楼3单元333','维修类型','故障原因','/profile/upload/2022/02/01/a174278d-adb0-4612-825f-483e868d4610.jpg','2','weixiu','商品-洁具','水工','很不错','stu003','2022-02-01 20:58:01'),(6,'W1643720459955','刘同学','13','23','12312','/profile/upload/2022/02/01/1dc88ab8-3116-4128-9402-72a35a469434.jpg','1','weixiu','非自然图像-屏幕截图','水工',NULL,'stu003','2022-02-01 21:01:00'),(7,'W1646834062308','刘同学','123','123','123','/profile/upload/2022/03/09/ea60c198-aa6b-4a86-8640-be4e6731409e.jpg','0',NULL,NULL,NULL,NULL,'stu003','2022-03-09 21:54:22'),(8,'W1646834468987','刘同学','权威','qe','ee','/profile/upload/2022/03/09/11bb1fd5-b3fb-4dd5-8dba-489c9e1cc1d9.jpg','0',NULL,NULL,NULL,NULL,'stu003','2022-03-09 22:01:09'),(9,'W1649668825626','cbai','A7','床','晃动','/profile/upload/2022/04/11/052ec7cd-6167-4275-bf95-c4a2395aadc4.jpg','2','','非自然图像-彩色动漫','建筑工','1313','star','2022-04-11 17:20:26'),(10,'W1649672466781','cbai','A7','13','1313','/profile/upload/2022/04/11/923b02d4-af0a-46c7-b3aa-75d4c6799db2.jpg','2','weixiu','非自然图像-彩色动漫','建筑工',NULL,'star','2022-04-11 18:21:07'),(11,'W1649673142918','qaq','A1','13','131','/profile/upload/2022/04/11/239b7c7d-5bd9-4d4c-a36e-fce318ed3194.jpg','2','weixiu','非自然图像-彩色动漫','建筑工','13144','qaq','2022-04-11 18:32:23'),(12,'W1650010068208','qaq','兰陵镇派出所对过小区','2424','424234242','/profile/upload/2022/04/15/e090178e-11e2-4caf-a131-23305337e523.jpg','2','weixiu1','商品-保健器械','木工','真好','qaq','2022-04-15 16:07:48'),(13,'W1650010175283','qaq','兰陵镇派出所对过小区','43242342','42424234','/profile/upload/2022/04/15/74d8ad6b-783c-4b27-864b-b21d35926f16.jpg','1','weixiu1','商品-保健器械','木工',NULL,'qaq','2022-04-15 16:09:35'),(14,'W1650435480467','qaq','A8','家具','桌子损坏','/profile/upload/2022/04/20/ba93af6c-1b53-4dd9-a50c-2d67675d3fe6.jpg','0',NULL,NULL,NULL,NULL,'qaq','2022-04-20 14:18:00');
/*!40000 ALTER TABLE `t_baoxiu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_class`
--

DROP TABLE IF EXISTS `t_class`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_class`
--

LOCK TABLES `t_class` WRITE;
/*!40000 ALTER TABLE `t_class` DISABLE KEYS */;
INSERT INTO `t_class` VALUES (1,'2020计算机科学与技术1班',1),(2,'2020计算机科学与技术2班',1),(3,'2020软件工程1班',2),(4,'2020软件工程2班',2),(5,'2020国学1班',4),(6,'2020国学2班',4),(7,'2020钢琴1班',3),(8,'2020钢琴2班',3);
/*!40000 ALTER TABLE `t_class` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_dept`
--

DROP TABLE IF EXISTS `t_dept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_dept` (
  `id` int(11) NOT NULL,
  `t_deptname` varchar(45) DEFAULT NULL,
  `create_time` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_dept`
--

LOCK TABLES `t_dept` WRITE;
/*!40000 ALTER TABLE `t_dept` DISABLE KEYS */;
INSERT INTO `t_dept` VALUES (1,'计算机学院',NULL),(2,'软件学院',NULL),(3,'音乐学院',NULL),(4,'通识学院',NULL);
/*!40000 ALTER TABLE `t_dept` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_fankui`
--

DROP TABLE IF EXISTS `t_fankui`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_fankui` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `content` varchar(255) DEFAULT NULL COMMENT '反馈',
  `reply` varchar(255) DEFAULT NULL COMMENT '回复',
  `create_by` varchar(255) DEFAULT NULL COMMENT '反馈人',
  `create_time` datetime DEFAULT NULL COMMENT '反馈时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='意见反馈';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_fankui`
--

LOCK TABLES `t_fankui` WRITE;
/*!40000 ALTER TABLE `t_fankui` DISABLE KEYS */;
INSERT INTO `t_fankui` VALUES (3,'阿萨德','123123','admin','2022-02-01 17:19:03'),(4,'123123',NULL,'stu001','2022-02-01 17:30:22'),(5,'123123',NULL,'stu001','2022-02-01 20:09:49'),(6,'123123123','3333','stu002','2022-02-01 20:47:48'),(7,'123123','123123','stu003','2022-02-01 20:57:38'),(8,'123131313','wfwfwf','star','2022-04-11 18:16:26'),(9,'1312313','46464','qaq','2022-04-11 18:31:32'),(10,'',NULL,'qaq','2022-04-20 14:23:10');
/*!40000 ALTER TABLE `t_fankui` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_fenpei`
--

DROP TABLE IF EXISTS `t_fenpei`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_fenpei` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Root字段',
  `type` varchar(255) DEFAULT NULL COMMENT '工种',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='工种分配';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_fenpei`
--

LOCK TABLES `t_fenpei` WRITE;
/*!40000 ALTER TABLE `t_fenpei` DISABLE KEYS */;
INSERT INTO `t_fenpei` VALUES (1,'商品-洁具','水工'),(2,'商品-五金','水工'),(3,'商品-生活用品','水工'),(5,'商品-家具','木工'),(7,'商品-家用电器','电工'),(8,'商品-灯具','电工'),(9,'商品-家装建材','建筑工'),(10,'商品-原材料','建筑工'),(11,'建筑-居家室内','建筑工'),(12,'建筑-室内','建筑工'),(13,'商品-家居家装','建筑工'),(14,'建筑-其他','建筑工'),(15,'商品-保健器械','木工');
/*!40000 ALTER TABLE `t_fenpei` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_louyu`
--

DROP TABLE IF EXISTS `t_louyu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_louyu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `fuzeren` varchar(255) DEFAULT NULL COMMENT '负责人',
  `lianxi` varchar(255) DEFAULT NULL COMMENT '联系方式',
  `beizhu` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='楼宇信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_louyu`
--

LOCK TABLES `t_louyu` WRITE;
/*!40000 ALTER TABLE `t_louyu` DISABLE KEYS */;
INSERT INTO `t_louyu` VALUES (1,'一号宿舍楼','张三','13544442222','备注信息备注信息备注信息'),(2,'13131','3131311','11111111111','');
/*!40000 ALTER TABLE `t_louyu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_notice`
--

DROP TABLE IF EXISTS `t_notice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_notice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text,
  `title` varchar(255) DEFAULT NULL,
  `create_by` varchar(45) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_notice`
--

LOCK TABLES `t_notice` WRITE;
/*!40000 ALTER TABLE `t_notice` DISABLE KEYS */;
INSERT INTO `t_notice` VALUES (1,'1','1',NULL,'2022-04-14 18:26:41'),(2,'2','2',NULL,'2022-04-14 18:26:41'),(3,'3','3',NULL,'2022-04-14 18:26:41'),(4,'<span style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; font-size: 14px;\">本教程于2015年7月开始撰写，耗时半年，总共148节，涵盖了Android基础入门的大部分知识，由于当时能力局限，虽已竭尽全力，但对于一些问题的分析难免有所纰漏，敬请读者海涵！IT技术更新换代很快，想想2015年还是Android 5.1横行，如今到了2018年都已经Android 8.0了，开发工具Android Studio也更新到了Android Studio 3.0.1。本系列的教程可能有些地方已经过时了，比如6.0以后的动态权限申请。一个人的力量是有限的，而且也有自己的工作忙，不可能去另外整一个大更新，今天写的，可能过几个月就过时了，这是IT界的常态，所以还是得自己学会主动去获取知识的能力，提供几个常备的知识获取站点吧，平时闲着没事可以自己上去获取知识：</span>','Android基础入门教程',NULL,'2022-04-14 18:26:41'),(5,'<p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">C 语言是一种通用的、面向过程式的计算机程序设计语言。1972 年，为了移植与开发 UNIX 操作系统，丹尼斯·里奇在贝尔电话实验室设计开发了 C 语言。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">C 语言是一种广泛使用的计算机语言，它与 Java 编程语言一样普及，二者在现代软件程序员之间都得到广泛使用。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">当前最新的 C 语言标准为 C18 ，在它之前的 C 语言标准有 C17、C11...C99 等。</p>','C 语言',NULL,'2022-04-14 18:26:41'),(6,'<p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">Python 的 3.0 版本，常被称为 Python 3000，或简称 Py3k。相对于 Python 的早期版本，这是一个较大的升级。为了不带入过多的累赘，Python 3.0 在设计的时候没有考虑向下兼容。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">Python 介绍及安装教程我们在<a href=\"https://www.runoob.com/python/python-tutorial.html\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"border: 0px; margin: 0px; padding: 0px; color: rgb(0, 102, 0); text-decoration-line: underline; transition-duration: 0.2s; transition-property: opacity; outline: none; font-size: 13px;\">Python 2.X 版本的教程</a>中已有介绍，这里就不再赘述。<a style=\"border: 0px; margin: 0px; padding: 0px; color: rgb(0, 102, 0); text-decoration-line: underline; transition-duration: 0.2s; transition-property: opacity; outline: none; font-size: 13px;\"></a></p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\"><a style=\"border: 0px; margin: 0px; padding: 0px; color: rgb(0, 102, 0); text-decoration-line: underline; transition-duration: 0.2s; transition-property: opacity; outline: none; font-size: 13px;\">你也可以点击&nbsp;</a><a target=\"_top\" href=\"https://www.runoob.com/python3/python-2x-3x.html\" rel=\"noopener noreferrer\" style=\"border: 0px; margin: 0px; padding: 0px; color: rgb(0, 102, 0); text-decoration-line: underline; transition-duration: 0.2s; transition-property: opacity; outline: none; font-size: 13px;\">Python2.x与3​​.x版本区别&nbsp;</a>来查看两者的不同。</p>','Python',NULL,'2022-04-14 18:26:41'),(9,'<ul><li>4242</li><li>42424</li><li><img src=\"http://localhost:8080/profile/upload/2022/04/14/02460a8e-f91b-4be1-9494-c5aa44e72b69.jpg\" style=\"width: 455px;\"><br></li></ul>','KELITUPAIN01',NULL,'2022-04-14 18:26:41'),(10,'<p>i给i一个</p>','888',NULL,'2022-04-15 14:56:45'),(12,'<p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">JavaScript 是 Web 的编程语言。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">所有现代的 HTML 页面都使用 JavaScript。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">JavaScript 非常容易学。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">本教程将教你学习从初级到高级 JavaScript 知识。</p>','JavaScript',NULL,'2022-04-15 15:04:44'),(13,'<p>哈哈哈哈哈哈哈哈哈哈哈</p><p>哈哈哈哈哈哈哈哈哈哈哈</p><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><p>哈哈哈哈哈哈哈哈哈哈哈</p><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p><br></p><hr><p>哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈</p><hr><p>哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈哈<br></p>','HAHAHA',NULL,'2022-04-15 15:05:32'),(14,'<p><img src=\"http://localhost:8080/profile/upload/2022/04/15/86ba2caf-8f5c-4fb2-ad55-6d3c11239314.jpg\" style=\"width: 455px;\"></p><p>98</p>','KELITUPIAN',NULL,'2022-04-15 15:11:23'),(15,'<p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">Bootstrap 是全球最受欢迎的前端组件库，用于开发响应式布局、移动设备优先的 WEB 项目。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">Bootstrap5 目前是 Bootstrap 的最新版本，是一套用于 HTML、CSS 和 JS 开发的开源工具集。它支持 Sass 变量和 mixins、响应式网格系统、大量的预建组件和强大的 JavaScript 插件，助你快速设计和自定义响应式、移动设备优先的站点。</p>','Bootstrap',NULL,'2022-04-15 15:58:36'),(16,'<p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">超文本标记语言（英语：HyperText Markup Language，简称：HTML）是一种用于创建网页的标准标记语言。</p><p style=\"border: 0px; margin-bottom: 0px; padding: 0px; line-height: 2em; overflow-wrap: break-word; word-break: break-all; font-size: 14px; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;PingFang SC&quot;, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, &quot;Noto Sans CJK SC&quot;, &quot;WenQuanYi Micro Hei&quot;, Arial, sans-serif; color: rgb(51, 51, 51);\">您可以使用 HTML 来建立自己的 WEB 站点，HTML 运行在浏览器上，由浏览器来解析。</p>','HTML',NULL,'2022-04-15 15:59:26'),(17,'<h1><b>新的一天</b></h1><p>新的开始</p><p><img src=\"http://localhost:8080/profile/upload/2022/04/16/2ab1f375-66b8-4db7-9197-a2e6699c051d.jpg\" style=\"width: 25%;\"></p><p>17139131312314</p>','新的一天',NULL,'2022-04-16 14:36:15');
/*!40000 ALTER TABLE `t_notice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `t_notice_reply`
--

DROP TABLE IF EXISTS `t_notice_reply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `t_notice_reply` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) DEFAULT NULL,
  `notice_id` int(11) DEFAULT NULL,
  `create_time` varchar(45) DEFAULT NULL,
  `reply_user` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `t_notice_reply`
--

LOCK TABLES `t_notice_reply` WRITE;
/*!40000 ALTER TABLE `t_notice_reply` DISABLE KEYS */;
INSERT INTO `t_notice_reply` VALUES (1,'24891414141',1,'2022-04-14 18:11:57.357',1),(2,'3426266436',12,'2022-04-14 18:11:57.357',1),(3,'6363456436',2,'2022-04-14 18:11:57.357',2),(4,'36436346',2,'2022-04-14 18:11:57.357',2),(5,'63464337',1,'2022-04-14 18:11:57.357',2),(6,'哈哈',1,'2022-04-14 18:11:57.357',2),(11,'32424',2,'2022-04-14 18:11:57.357',2),(12,'真好看',17,'2022-04-17 11:25:45.071',1),(20,'哈哈',17,'2022-04-17 18:10:25.959',1),(22,'哈哈哈哈',17,'2022-04-17 18:13:11.781',1),(26,'这次一定行！',17,'2022-04-17 18:33:34.434',1),(27,'哈哈',17,'2022-04-17 18:36:09.213',1),(28,'哈',17,'2022-04-17 18:36:21.486',1),(29,'哈哈哈',17,'2022-04-17 18:37:39.959',1),(30,'qaq',17,'2022-04-17 18:39:33.494',13),(31,'可以吗',17,'2022-04-17 18:43:24.88',10),(32,'1212',17,'2022-04-21 17:20:33.062',1),(33,'1212',17,'2022-04-21 17:20:33.098',1),(34,'1',17,'2022-04-21 17:34:05.391',1);
/*!40000 ALTER TABLE `t_notice_reply` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-04-27 17:02:32