CREATE DATABASE  IF NOT EXISTS `yorick_manage` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `yorick_manage`;
-- MySQL dump 10.13  Distrib 8.0.33, for macos13 (arm64)
--
-- Host: localhost    Database: yorick_manage
-- ------------------------------------------------------
-- Server version	8.0.33

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

DROP TABLE IF EXISTS `sys_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_account` (
  `aid` int NOT NULL AUTO_INCREMENT,
  `account` varchar(20) DEFAULT NULL,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `mobilephone` varchar(20) DEFAULT NULL,
  `login_date` datetime DEFAULT NULL,
  `failure_time` int DEFAULT '0',
  `enabled` decimal(1,0) DEFAULT NULL,
  `head` varchar(100) DEFAULT 'default.jpg',
  PRIMARY KEY (`aid`),
  UNIQUE KEY `mobilephone_UNIQUE` (`mobilephone`),
  UNIQUE KEY `account_UNIQUE` (`account`),
  UNIQUE KEY `email_UNIQUE` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_account`
--

LOCK TABLES `sys_account` WRITE;
/*!40000 ALTER TABLE `sys_account` DISABLE KEYS */;
INSERT INTO `sys_account` VALUES (1,'11111111111','超级管理员','4425E559277213BF8B945DEB842C3C2BE3016B836A0FCCAF','123@gmail.com','11111111111','2023-06-08 12:20:39',0,1,'1686151162782&avatar-5.jpeg'),(2,'22222222222','测试人员1','D59839BF75EE2617EB77C2106B5D369BE3016B836A0FCCAF','222@gmail.com','22222222222','2023-06-07 23:37:28',0,1,'1686152238208&avatar-4.jpeg');
/*!40000 ALTER TABLE `sys_account` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_department`
--

DROP TABLE IF EXISTS `sys_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_department` (
  `did` int NOT NULL AUTO_INCREMENT COMMENT '部门ID',
  `parent_id` int DEFAULT NULL COMMENT '父级ID',
  `dname` varchar(100) DEFAULT NULL COMMENT '部门名称',
  `description` varchar(500) DEFAULT NULL COMMENT '部门描述',
  `op_time` datetime DEFAULT NULL COMMENT '创建时间',
  `enabled` int DEFAULT NULL,
  PRIMARY KEY (`did`),
  UNIQUE KEY `un_department` (`dname`,`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=502 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_department`
--

LOCK TABLES `sys_department` WRITE;
/*!40000 ALTER TABLE `sys_department` DISABLE KEYS */;
INSERT INTO `sys_department` VALUES (1,0,'测试机构','新增测试机构','2022-08-31 21:19:06',1),(2,1,'测试子机构1','测试子机构','2022-08-28 13:53:42',1),(3,1,'测试子机构2','测试子机构2','2022-08-27 17:53:03',1),(4,1,'测试子机构3','测试子机构3','2022-08-23 21:16:45',1),(5,1,'测试子机构4','测试子机构4','2022-08-23 21:16:45',1),(458,0,'测试机构2','网页新增机构','2022-09-07 20:37:49',1),(459,458,'测试机构2子机构1','测试机构2子机构1描述','2022-08-28 13:54:35',1),(460,458,'测试机构2子机构2','测试机构2子机构2描述','2022-09-07 20:37:47',1),(487,460,'子机构2-1','子机构2-1','2023-06-06 20:38:05',1);
/*!40000 ALTER TABLE `sys_department` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_resources`
--

DROP TABLE IF EXISTS `sys_resources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_resources` (
  `resource_id` int NOT NULL AUTO_INCREMENT,
  `resource_name` varchar(50) DEFAULT NULL COMMENT '资源名称',
  `resource_desc` varchar(500) DEFAULT NULL COMMENT '资源描述',
  `resource_string` varchar(500) DEFAULT NULL,
  `enabled` decimal(1,0) DEFAULT NULL COMMENT 'ENABLED',
  `parent_id` decimal(12,0) DEFAULT NULL,
  `order_num` decimal(5,0) DEFAULT NULL,
  PRIMARY KEY (`resource_id`),
  KEY `UK_SYS_RES_CODE` (`resource_name`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_resources`
--

LOCK TABLES `sys_resources` WRITE;
/*!40000 ALTER TABLE `sys_resources` DISABLE KEYS */;
INSERT INTO `sys_resources` VALUES (1,'s_account_add','账户添加','/account/addAccount',1,7,1),(2,'s_account_alter','密码修改','/account/changePassword',1,7,2),(3,'s_account_select','账户列表','/account/accountList',1,7,3),(4,'s_account_status','账户状态','/account/accountStatus',1,7,4),(5,'s_account_detail','账户详情','/account/accountDetail',1,7,5),(6,'s_account_edit','账户修改','/account/accountEdit',1,7,6),(7,'s_account','账户管理','account.html',1,0,1),(8,'s_menu_select','菜单列表','/menu/menuList',1,13,1),(10,'s_menu_add','菜单添加','/menu/addMenu',1,13,2),(11,'s_menu_alter','菜单修改','/menu/editMenu',1,13,3),(12,'s_menu_detail','菜单详情','/menu/menuDetail',1,13,4),(13,'s_menu','菜单管理','menu.html',1,0,4),(14,'s_role_select','角色列表','/role/roleList',1,19,1),(15,'s_role_add','角色添加','/role/addRole',1,19,2),(16,'s_role_detail','角色详情','/role/roleDetail',1,19,3),(17,'s_role_delete','角色删除','/role/deleteRole',1,19,4),(18,'s_role_update','角色修改','/role/editRole',1,19,5),(19,'s_role','角色管理','role.html',1,0,3),(20,'s_depart_select','机构列表','/department/departmentList',1,25,1),(21,'s_depart_add','机构添加','/department/addDepartment',1,25,2),(22,'s_depart_detail','机构详情','/department/departmentDetail',1,25,3),(23,'s_depart_edit','机构修改','/department/editDepartment',1,25,4),(24,'s_depart_delete','机构删除','/department/deleteDepartment',1,25,5),(25,'s_depart','机构管理','department.html',1,0,2),(26,'s_ipWhiteList','IP白名单管理','ipWhiteList.html',1,0,5),(27,'s_ipWhiteList_list','IP白名单列表','/ipWhiteList/ipWhiteList',1,26,1),(28,'s_ipWhiteList_add','IP白名单添加','/ipWhiteList/addIPWhiteList',1,26,2),(29,'s_ipWhiteList_edit','IP白名单修改','/ipWhiteList/editIPWhiteList',1,26,3),(30,'s_ipWhiteList_detail','IP白名单详情','/ipWhiteList/ipWhiteListDetail',1,26,4),(31,'s_ipWhiteList_delete','IP白名单删除','/ipWhiteList/deleteIPWhiteList',1,26,5);
/*!40000 ALTER TABLE `sys_resources` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_roles`
--

DROP TABLE IF EXISTS `sys_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_roles` (
  `role_id` int NOT NULL AUTO_INCREMENT,
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
  `role_desc` varchar(200) DEFAULT NULL COMMENT '角色描述',
  `enabled` decimal(1,0) DEFAULT NULL COMMENT '状态',
  `aid` int DEFAULT NULL COMMENT '创建角色',
  `op_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`role_id`),
  KEY `UK_SYS_ROLE_CODE` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_roles`
--

LOCK TABLES `sys_roles` WRITE;
/*!40000 ALTER TABLE `sys_roles` DISABLE KEYS */;
INSERT INTO `sys_roles` VALUES (1,'超级管理员','超级管理员',1,1,'2019-09-28 10:42:45'),(2,'普通管理员','部分后台权限',1,1,'2021-04-07 11:07:33'),(3,'注册用户','没有后台管理权限',1,1,'2021-04-07 11:04:07');
/*!40000 ALTER TABLE `sys_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_roles_department`
--

DROP TABLE IF EXISTS `sys_roles_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_roles_department` (
  `role_id` int DEFAULT NULL,
  `did` int DEFAULT NULL,
  `enabled` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_roles_department`
--

LOCK TABLES `sys_roles_department` WRITE;
/*!40000 ALTER TABLE `sys_roles_department` DISABLE KEYS */;
INSERT INTO `sys_roles_department` VALUES (1,1,1),(2,1,1),(3,1,1),(3,2,1);
/*!40000 ALTER TABLE `sys_roles_department` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_roles_resource`
--

DROP TABLE IF EXISTS `sys_roles_resource`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_roles_resource` (
  `role_id` int DEFAULT NULL,
  `resource_id` int DEFAULT NULL,
  `enabled` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_roles_resource`
--

LOCK TABLES `sys_roles_resource` WRITE;
/*!40000 ALTER TABLE `sys_roles_resource` DISABLE KEYS */;
INSERT INTO `sys_roles_resource` VALUES (2,7,1),(2,1,1),(2,3,1),(2,5,1),(2,25,1),(2,20,1),(2,19,1),(2,14,1),(2,15,1),(2,16,1),(2,17,1),(2,18,1),(2,13,1),(2,8,1),(1,7,1),(1,1,1),(1,2,1),(1,3,1),(1,4,1),(1,5,1),(1,6,1),(1,25,1),(1,20,1),(1,21,1),(1,22,1),(1,23,1),(1,24,1),(1,19,1),(1,14,1),(1,15,1),(1,16,1),(1,17,1),(1,18,1),(1,13,1),(1,8,1),(1,10,1),(1,11,1),(1,12,1),(1,26,1),(1,27,1),(1,28,1),(1,29,1),(1,30,1),(1,31,1);
/*!40000 ALTER TABLE `sys_roles_resource` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_users_department`
--

DROP TABLE IF EXISTS `sys_users_department`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_users_department` (
  `aid` int DEFAULT NULL,
  `did` int DEFAULT NULL,
  `enabled` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_users_department`
--

LOCK TABLES `sys_users_department` WRITE;
/*!40000 ALTER TABLE `sys_users_department` DISABLE KEYS */;
INSERT INTO `sys_users_department` VALUES (1,1,1),(1,2,1),(2,458,1);
/*!40000 ALTER TABLE `sys_users_department` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_users_roles`
--

DROP TABLE IF EXISTS `sys_users_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_users_roles` (
  `aid` int DEFAULT NULL COMMENT '人员编号',
  `role_id` int DEFAULT NULL COMMENT '角色编号',
  `enabled` int DEFAULT NULL COMMENT '状态'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_users_roles`
--

LOCK TABLES `sys_users_roles` WRITE;
/*!40000 ALTER TABLE `sys_users_roles` DISABLE KEYS */;
INSERT INTO `sys_users_roles` VALUES (1,2,1),(1,1,1),(2,2,1);
/*!40000 ALTER TABLE `sys_users_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_whitelist_ip`
--

DROP TABLE IF EXISTS `sys_whitelist_ip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sys_whitelist_ip` (
  `id` int NOT NULL AUTO_INCREMENT,
  `IP` varchar(50) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  `enabled` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_whitelist_ip`
--

LOCK TABLES `sys_whitelist_ip` WRITE;
/*!40000 ALTER TABLE `sys_whitelist_ip` DISABLE KEYS */;
INSERT INTO `sys_whitelist_ip` VALUES (1,'0:0:0:0:0:0:0:1','本机IP',1),(2,'127.0.0.1','本地IP',1),(18,'192.168.1.1','本地IP',1),(24,'192.168.1.32','本地IP',1),(25,'192.168.1.192','手机IP',1);
/*!40000 ALTER TABLE `sys_whitelist_ip` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'yorick_manage'
--
/*!50106 SET @save_time_zone= @@TIME_ZONE */ ;
/*!50106 DROP EVENT IF EXISTS `due_department_event` */;
DELIMITER ;;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;;
/*!50003 SET character_set_client  = utf8mb3 */ ;;
/*!50003 SET character_set_results = utf8mb3 */ ;;
/*!50003 SET collation_connection  = utf8mb3_general_ci */ ;;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;
/*!50003 SET sql_mode              = 'NO_AUTO_VALUE_ON_ZERO' */ ;;
/*!50003 SET @saved_time_zone      = @@time_zone */ ;;
/*!50003 SET time_zone             = 'SYSTEM' */ ;;
/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`%`*/ /*!50106 EVENT `due_department_event` ON SCHEDULE EVERY 1 DAY STARTS '2021-05-09 01:00:00' ON COMPLETION PRESERVE ENABLE DO UPDATE `sys_dpartment` SET `ENABLE`=0 WHERE TO_DAYS(OP_TIME)<TO_DAYS(NOW()) */ ;;
/*!50003 SET time_zone             = @saved_time_zone */ ;;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;;
/*!50003 SET character_set_client  = @saved_cs_client */ ;;
/*!50003 SET character_set_results = @saved_cs_results */ ;;
/*!50003 SET collation_connection  = @saved_col_connection */ ;;
/*!50106 DROP EVENT IF EXISTS `due_resource_event` */;;
DELIMITER ;;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;;
/*!50003 SET character_set_client  = utf8mb3 */ ;;
/*!50003 SET character_set_results = utf8mb3 */ ;;
/*!50003 SET collation_connection  = utf8mb3_general_ci */ ;;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;;
/*!50003 SET sql_mode              = 'NO_AUTO_VALUE_ON_ZERO' */ ;;
/*!50003 SET @saved_time_zone      = @@time_zone */ ;;
/*!50003 SET time_zone             = 'SYSTEM' */ ;;
/*!50106 CREATE*/ /*!50117 DEFINER=`root`@`%`*/ /*!50106 EVENT `due_resource_event` ON SCHEDULE EVERY 1 DAY STARTS '2021-06-23 01:00:00' ON COMPLETION PRESERVE ENABLE DO DELETE FROM `app_connection` WHERE op_time is not null AND TO_DAYS(op_time)<TO_DAYS(NOW()) */ ;;
/*!50003 SET time_zone             = @saved_time_zone */ ;;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;;
/*!50003 SET character_set_client  = @saved_cs_client */ ;;
/*!50003 SET character_set_results = @saved_cs_results */ ;;
/*!50003 SET collation_connection  = @saved_col_connection */ ;;
DELIMITER ;
/*!50106 SET TIME_ZONE= @save_time_zone */ ;

--
-- Dumping routines for database 'yorick_manage'
--
/*!50003 DROP PROCEDURE IF EXISTS `findDepartmentChildList` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb3 */ ;
/*!50003 SET character_set_results = utf8mb3 */ ;
/*!50003 SET collation_connection  = utf8mb3_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'NO_AUTO_VALUE_ON_ZERO' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `findDepartmentChildList`(IN id INTEGER)
BEGIN
  DECLARE v_depart INTEGER DEFAULT 0;
  DECLARE done INTEGER DEFAULT 0;
    -- 查询结果放入游标中
  DECLARE C_depart CURSOR FOR SELECT d.did FROM sys_department d WHERE d.parent_id = id AND d.enabled = 1;
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
  SET @@max_sp_recursion_depth = 10;
    
    -- 传入的组织id写入临时表
 INSERT INTO tmp_depart VALUES (id);
  OPEN C_depart;
  FETCH C_depart INTO v_depart;
  WHILE (done=0)
  DO
        -- 递归调用，查找下级
    CALL findDepartmentChildList(v_depart);
    FETCH C_depart INTO v_depart;
  END WHILE;
  CLOSE C_depart;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP PROCEDURE IF EXISTS `findDepartmentList` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8mb3 */ ;
/*!50003 SET character_set_results = utf8mb3 */ ;
/*!50003 SET collation_connection  = utf8mb3_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = 'NO_AUTO_VALUE_ON_ZERO' */ ;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `findDepartmentList`(IN id INTEGER)
BEGIN
  DROP TEMPORARY TABLE IF EXISTS tmp_depart;
    -- 创建临时表
    CREATE TEMPORARY TABLE tmp_depart(did INTEGER);
    -- 清空临时表数据
    DELETE FROM tmp_depart;
    -- 发起调用
    CALL findDepartmentChildList(id);
    -- 从临时表查询结果
    SELECT did FROM tmp_depart ORDER BY did;
END ;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!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 2023-06-08 12:47:08